Exam 8: Access

Before you close a query datasheet, you must save your changes to the data.

You use the Header button to add a title to a report in Report Design view.

If you import data from Excel often, you can save the import steps so you can repeat them easily and accurately.

The _____ is the wildcard character that stands for any single character in criteria.

In a form, how you can highlight the CustomerType text box only when it contains the value New?

When editing a record using a form, how can you move from field to field in the same record?

Which of the following are formatting properties you can apply to many report controls?

Before you close a database, you must save any changes you made to the data.

A subdatasheet shows the records on the "one" side of a one-to-many relationship.

You add the Calculation row to the query design grid to specify how you want to group records and perform calculations on them.

Which data type is used for sequential integers controlled by Access?

Which of the following can you change when formatting a datasheet?

Which of the following criteria uses the correct syntax for a Date/Time field in a query?

If you set a database _____, all users must enter that combination of characters before they are allowed to open the database.

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

To quickly remove all Lookup properties from a field, change the Display Control property to _____.

After running a Delete query, you cannot _____.

What data type is most appropriate for a field named SquareFeet?

Which chart type uses vertical bars to compare values?

When using the Report Wizard, you can click the Back button to review previous dialog boxes.