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.

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 ____.

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 ____.

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.

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.

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?

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: ____.

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 ____.