Question # 1 Define Microsoft Access and its components (tables, relationships, forms, queries, reports).

Question # 2 List the responsibilities of a database administrator as they relate to assuring data security and integrity.

Question Type: Multiple Choice

Question # 3 On which tab is the Queries group located?

a) Home

b) Create

c) Database Tools

d) Table contextual tab under Table Tools

Question Type: Fill-in-the-blank

Question # 4 A/an ___________ is a set of instructions used for working with data

Question Type: Multiple Choice

Question # 5 Which of the following can a query do?

a) extract information from one table

b) extract information from multiple tables

c) modify data in a table

d) delete data from a table

Question Type: Multiple Choice

Question # 6 What is the most basic type of query?

a) advanced

b) elementary

c) select

d) fundamental

Question Type: Multiple Choice

Question # 7 In which view do the results of a select query display?

a) Report View

b) Table View

c) Datasheet View

d) Form View

Question Type: Multiple Select

Question # 8 In which of the following ways are queries different from filters?

a) Queries can be saved for future use.

b) Queries can show a subset of the data.

c) Queries can utilize data from multiple tables.

d) Queries can utilize data from other queries.

Question Type: Fill-in-the-blank

Question # 9 The tables or queries from which a query gets its data are referred to as its ___________.

Question Type: Multiple Select

Question # 10 What are the options in the first screen of the Query Wizard?

a) Advanced Query Wizard

b) Simple Query Wizard

c) Find Unmatched Query Wizard

d) Multiple Columns Query Wizard

Question Type: Multiple Select

Question # 11 When creating a simple query through the Query Wizard, what are the options in the last screen?

a) Convert the query to crosstab.

b) Open the query to view information.

c) Save the query as a form.

d) Modify the query design.

Question Type: Multiple Choice

Question # 12 How do you run a query after it has been created?

a) On the Home tab, click Selection.

b) Select it in the Navigation Pane and click Space.

c) Double-click it in the Navigation Pane.

d) On the File tab, click Open.

Question Type: Multiple Choice

Question # 13 How do you rename a query?

a) Double-click it in the Navigation pane.

b) Right-click it in the Navigation pane and select Rename.

c) Select it in the Navigation pane and press Enter.

d) Open the Object Properties and change the name.

Question Type: Multiple Select

Question # 14 What are the different options for deleting a query?

a) Click the Delete button on the Home tab.

b) Right-click it in the Navigation pane and choose Delete.

c) Double-click it in the Navigation pane.

d) Select it in the Navigation Pane and press the Delete key.

Question Type: Multiple Choice

Question # 15 What happens when a query is closed?

a) It is automatically saved.

b) It is run again.

c) It is closed without being saved.

d) It is removed from the Navigation pane.

Question Type: Multiple Choice

Question # 16 When are two records considered duplicates?

a) when there is a field in both records that contains the same value

b) when there are two fields in one of the records that contain the same data

c) when all fields in one of the records contain the same data

d) when all the corresponding fields in both records contain the same values

Question Type: Multiple Choice

Question # 17 How many tables can a query read data from?

a) just one

b) one or two if the tables have a field with the same name

c) one or two if the tables have one duplicate record

d) multiple

Question Type: Fill-in-the-blank

Question # 18 Before creating a query from multiple tables, you must first ensure that the tables have a defined ___________.

Question Type: Multiple Choice

Question # 19 In order to view records in one table that do not have a matching record in another table, what query do you use?

a) Crosstab

b) Find Duplicates

c) Find Unmatched

d) Find Matched

Question Type: Multiple Choice

Question # 20 On how many tables can the Find Duplicates query run?

a) just one

b) two that have a relationship

c) two that do not have a relationship

d) three