Question 1

Case AC 6-1 Kathleen is working with a large recipient list for an upcoming promotional mailing. She has opened the Mail Merge Recipients dialog box. Kathleen needs to put the mail merge recipient list in alphabetical order. What is her next step?

Accepted Answer

A)  Write a sort command and fill it in the Data source box 
B)  Click the Filter link to open the Filter and Sort dialog box 
C)  Click the Sort link to open the Filter and Sort dialog box 
D)  None of the above

Question 2

Describe a lookup property and explain the advantage of using one. Be sure to include a discussion on how to set lookup properties and the three forms of lookup property boxes.

Accepted Answer

The answer of Describe a lookup property and explain the...

Question 3

Briefly describe Filter by Selection and Filter by Form. Imagine that you are searching for songs in a database. Give an example of a situation where you would use Filter by Selection and a situation where you would use Filter by Form.

Accepted Answer

The answer of Briefly describe Filter by Selection and Filter...

Question 4

When you change control formats, you will typically be changing the text box when the ____ is displayed.

Accepted Answer

A)  record 
B)  field 
C)  data 
D)  property

Question 5

The different options for creating reports are located in the Reports group on the Design tab.

Accepted Answer

A) True 
 B)False

Question 6

Case Access 7-2 Andrew is an accountant with a large investment firm in New York. He keeps an Access database of travel expenditures for all of the auditors within the Oversight and Supervision Division. His database is updated nightly as part of the Computer Operations critical path runtime workload. During your initial discussion with Andrew, he raises a concern regarding how changes to the field data will affect his calculations. You explain to Andrew that if an amount in either of the fields changes, the result in the calculated field ____.

Accepted Answer

A)  remains the same 
B)  is replaced by pound signs (#) 
C)  will show the new result 
D)  is null

Question 7

The tab order can be changed in Design view by selecting the ____ button in the Tools group of the Design tab.

Accepted Answer

A)  Change Order 
B)  Tab Order 
C)  Reorder 
D)  Reset

Question 8

Case AC 6-2 Ross is exporting Access data into Word. What should Ross do to get the export of the Access database into Microsoft Word started?

Accepted Answer

A)  Click the Export Data tab on the Ribbon, and then click the Word button in the Format group 
B)  Click the External Data tab on the Ribbon, click the More button in the Export group, and then click Word. 
C)  Click the Internal Data tab on the Ribbon, and then click the Word button in the Export group 
D)  None of the above

Question 9

By selecting multiple controls, you have the ability to apply formats to several controls at one time.

Accepted Answer

A) True 
 B)False

Question 10

Because macros often need to be changed, it is a good idea to include a comment for each ____.

Accepted Answer

A)  macro action 
B)  macro field 
C)  macro filter 
D)  query

Question 11

AC Case 12-1 Taylor needs to display a splash screen when users open an inventory database. She knows VBA has a macro to help with this task; however, Taylor is unsure of how to use the macro. Taylor asks for your assistance. To create the macro used to display the splash screen, Taylor should use the ____ window to select the actions she wants Access to perform when the database is opened.

Accepted Answer

A)  Create 
B)  Actions 
C)  Macro 
D)  Options

Question 12

A(n) ____________________ displays a list of values and lets you select one from the list.

Accepted Answer

The answer of A(n) ____________________ displays a list of values...

Question 13

A(n) crosstab query rearranges data in a table or query so that it appears in another format.

Accepted Answer

A) True 
 B)False

Question 14

When you export data, you copy it from another Access database, an Excel workbook, a text file, or some other file format into an existing or new table in the current database.

Accepted Answer

A) True 
 B)False

Question 15

Case AC 8-1 Eric runs a small computer repair service. He decides to reduce prices by 5% to see if he can obtain more clients. Eric quickly creates and runs an update database query against his price table to lower the prices displayed on his Web site and then decides to take a lunch break. In the meantime, Eric begins receiving many client emails and calls inquiring on the 50% price drop advertised on his Web site. What is the most likely cause for Eric's Web site to be displaying a 50% price drop for services?

Accepted Answer

A)  Eric's server is displaying last years test data. 
B)  Eric ran the query on the wrong server. 
C)  Records in his price table were changed as soon as Eric ran the query. 
D)  A competitor's Web site is listing Eric's phone number.

Question 16

Case AC 14-1 Ron wants to convert his paper-based customer information system to an Access 2010 database stored on his laptop. However, Ron is concerned about placing the information on his laptop because he also uses the laptop for Internet access. He asks for your advice. To ease Ron's concerns, you start by explaining that Access 2010 combines two tools for database security: ____.

Accepted Answer

A)  login IDs and database passwords 
B)  login IDs and row-level locking 
C)  database passwords and encryption 
D)  system passwords and encryption

Question 17

When data is formatted using comma separators, it is called limited data.

Accepted Answer

A) True 
 B)False

Question 18

You can use an update action query to instantly update all the employee salaries in a table by five percent.

Accepted Answer

A) True 
 B)False

Question 19

In Open Exclusive mode, only the person who opened the database can use and make changes to it; all other users are locked out from opening and using the database.

Accepted Answer

A) True 
 B)False

Question 20

In Datasheet view, the table displays its data in rows and columns in a ____.

Accepted Answer

A)  datasheet 
B)  spreadsheet 
C)  report 
D)  query program

Exam 1: Microsoft Access Basics

Case AC 6-1 Kathleen is working with a large recipient list for an upcoming promotional mailing. She has opened the Mail Merge Recipients dialog box. Kathleen needs to put the mail merge recipient list in alphabetical order. What is her next step?

Describe a lookup property and explain the advantage of using one. Be sure to include a discussion on how to set lookup properties and the three forms of lookup property boxes.

Briefly describe Filter by Selection and Filter by Form. Imagine that you are searching for songs in a database. Give an example of a situation where you would use Filter by Selection and a situation where you would use Filter by Form.

When you change control formats, you will typically be changing the text box when the ____ is displayed.

The different options for creating reports are located in the Reports group on the Design tab.

The tab order can be changed in Design view by selecting the ____ button in the Tools group of the Design tab.

Case AC 6-2 Ross is exporting Access data into Word. What should Ross do to get the export of the Access database into Microsoft Word started?

By selecting multiple controls, you have the ability to apply formats to several controls at one time.

Because macros often need to be changed, it is a good idea to include a comment for each ____.

A(n) ____________________ displays a list of values and lets you select one from the list.

A(n) crosstab query rearranges data in a table or query so that it appears in another format.

When you export data, you copy it from another Access database, an Excel workbook, a text file, or some other file format into an existing or new table in the current database.

When data is formatted using comma separators, it is called limited data.

You can use an update action query to instantly update all the employee salaries in a table by five percent.

In Open Exclusive mode, only the person who opened the database can use and make changes to it; all other users are locked out from opening and using the database.

In Datasheet view, the table displays its data in rows and columns in a ____.