1. The save location for a database in Access is chosen:

a. while entering data into the tables of the database b.while creating tables within the database c. when the data base is created d. when the data base is closed

2. What object or objects store data in an Access database?

a. Reports b. Forms c.Tables d. Queries e. or all of the above

3. Where in Access can you see the database structure will show the tables and how they are related?

a. relationship window b. structure window c. view structure tab d. other

4. Which of the following is NOT a main object type in an Access database?

a. forms b. templates c. queries d. tables

5. Which of the following is NOT a tab in Access 2016?

a. home b. format c. create d. file

6. The ____ view in Access looks similar to an Excel spreadshet

a. datasheet b. design

7. You can create or modify a table's field names and data types in ___ view

a. form b. datasheet c. report d. design

8. A primary key:

a. must contain a unique value for each record within a table. b. is a unique record wihtin a relational database c. has the same value for all recrords in a relational database d. must include letters

9. When you make a change to the content of a record in an Access table, when are the changes saved?

a. when you move the insertion point to a different table, form, query, or report in the database b. when you press F11 or click the save button on the quick access toolbar c. when you move the insertion point to a different record d. when you click the save or save as button form the file tab or the button on the quick access toolbar

10. A relational database has the ability to create a relationship between two:

a. fields b. forms c. files d. tables

11. The process of saving in Access is nearly the same as it is in other Microsoft Office applications

a. true b. false

12. Changes to the format of an object in Access are saved using the save button, Access will prompt you to save design changes to tables, forms, reports, and queries prior to closing them

a. true b. false

13. The backspace key will always get you out of editing a row in a table, it will undo all text edits to that row

a. true b. false

14. The .laccdb file is the file that contains the Access database structure

a. true b. false

15. A query can only provide information from one table

a. true b. false

16. A query must always pull data from multiple tables

a. true b. false

17. Which of the following objects allows you to see some of the columns and rows in an underlying table by creating a "result table"?

a. table b. report c. form d. query

18. A form can be used in Access to:

a. all of the above b. look at existing data c. delete data d. enter new data e. change existing data

19. A database is a collection of one or more:

a. reports b. tables c. fields d. rows

20. In a database, a single characteristics of a table is a:

a. table b. record c. field d. row