Question 1

When designing a database, you should

•  determine the input and then design the tables.
•  determine the output and then design the tables.
•  develop the forms and then input the data.
•  input the data and then design the reports.

Question 2

To locate a blank field, your criterion in a query would be

•  blank.
•  empty.
•  null.
•  void.

Question 3

Which wizard is NOT available from the query wizard?

•  Crosstab query wizard
•  Find duplicates query wizard
•  Simple query wizard
•  Summarize query wizard

Question 4

Access has _____ data types.

•  six
•  eight
•  10
•  12

Question 5

All of the following describe a many-to-many relationship in Access except

•  a junction table is used.
•  many matching records are found in each direction between tables.
•  may be used to connect to Oracle and other databases.
•  there must be at least four tables.

Question 6

Which of the following statements is true about queries?

•  Forms and queries are actually the same thing.
•  Queries can only be based on one table.
•  Queries can be based on one or more related tables.
•  The instructions to create a query are not stored in the database.

Question 7

(CO 2) When building a calculated field, formulas can be created using the

•  form wizard.
•  expression builder.
•  report builder.
•  table wizard.

Question 8

You can add records through the

•  datasheet view of a table.
•  design view of a table.
•  report view.
•  All of the above

Question 9

A parameter query is

•  a select query where the user provides the criterion at run time.
•  an action query used to modify data.
•  an aggregate query used to summarize field data.
•  used to backup databases.

Question 10

All of the following are true about a delete query except

•  a delete query is an action query.
•  access will display a warning message before running the delete query.
•  it can be created by clicking the create tab, query wizard, and then select delete query.
•  it selects records from a table and then removes them from the table.