AsterQuiz

databaseVersión en línea

Practice creating and organizing a student identification table in Microsoft Access.

por Eman Ahmed
1

Which option starts a new blank database in Access?

2

What is the database name used in the lesson?

3

Which ribbon path creates a table in Design View?

4

What data type is assigned to the ID field?

5

Which field is set as the primary key?

6

What data type is used for fname and lname?

7

Which data type is appropriate for registration_date and birth_date?

8

What data type is used for the new_student field?

9

What name should you give the saved table?

10

In Design View, which command inserts a field row?

Explanation

Choose Blank Database to create a new file from scratch.

The lesson names the database Students Database before creating it.

Use Create, then select Table Design to define the fields and their data types.

AutoNumber assigns a new unique number to each student record.

The ID field is selected as the primary key, so each student has a unique identifier.

Names are stored as Short Text fields.

Date/Time stores dates such as registration and birth dates.

Yes/No represents a two-choice value, shown as a checkbox in the table.

Save the table with the name Identification.

Select the row where the new field should go, then use Insert Rows. Delete Rows removes a selected field row.