Microsoft Access Quiz

Data that is organized in a useful manner is:

• normalized data

• information

• facts.

• a query

Which of the following is NOT a benefit of avoiding redundancy in a database?

• Conserves space

• Prevents unauthorized manipulation of data

• Reduces errors when recording new data

• User doesn't have to remember where data is stored

Each table row contains all categories of data pertaining to one entity and is called a:

• field.

• database.

• record.

• query

In Microsoft Access, all data is stored in one or more

• macros

• forms

• tables

• queries

An Access record is saved when you

• save the table in which it was created

• press Save on the File tab on the Ribbon

• close the database

• move to the next record

To rename a table, you can:

• click the Database Tools tab on the Ribbon

• right-click the table name in the Navigation Pane

• click Save As from the File menu

• open Windows Explorer

Before populating a table, which is the correct sequence of steps?

• Create and name the database; save the database; design, create and name the table

• Design the table, name the table, save the database

• Create the table, design the table, name the table, save and name the database

• Create the database, create the table, design the table, save and name the database.

While in Datasheet view, to display a table in Design View

• in the Preview group, click the View button arrow and click Design View

• on the Quick Access Toolbar, click Design View

• in the Views group, click the View button and click Design View

• in the Navigation Pane, click Design View

When creating a new table, Access does NOT:

• prevent the user from modifying the ID field

• format the first field as Autonumber

• assign the ID field as the primary key

• create a first field called ID

The most common database objects are:

• tables, panes, and property sheets

• tables, queries, forms, and reports

• ) tables, relationships, and panes

• tables, queries, and relationships