Review Questions Answer Key

Microsoft Access 2013

Answers to Review Questions

Lesson 1

1. Which of the following is a benefit of storing data in multiple, related tables?

a. It makes the tables easier to understand when you view them in Datasheet view.

b. It minimizes the repetition of data.

c. It makes the database larger.

d. It makes the data accessible by all versions of Microsoft Access.

2. Which of the following types of database objects is often used as a data entry screen?

a. A query.

b. A report.

c. A macro.

d. A form.

3. The commands and options in Backstage view are related to:

a. file management tasks.

b. entering data into tables.

c. relating tables to one another.

d. automating tasks within a database.

4. What does the globe icon in the template gallery indicate?

a. The template is available in over 70 languages.

b. The template will work in all versions of Microsoft Access.

c. The template is for a web app.

d. The template was developed by Microsoft and Google.

5. Which of the following is the native file format for Access 2013 databases?

a. .mdb

b. .accdb

c. .db

d. .sql

Lesson 2

1. For a relationship between fields in two tables to be created, the fields must:

a. have the same data type.

b. have the same name.

c. be stored in separate databases.

d. be defined as lookup fields.

For a relationship between fields in two tables to be created, the fields must have the same data type.

2. Which of the following is the smallest Field Size setting that will allow a number field to store the value 1,452,137.5?

a. Integer c. Single

b. Long Integer d. Double

Single. The Single field size setting uses four bytes of storage. The Double field size setting uses eight bytes. The Integer and Long Integer field size settings store only whole numbers, not fractional values.

3. What is the default Field Size setting for a Short Text field in Access?

a. 12 c. Double

b. Single d. 255

The default FieldSize setting for a Short Text field in Access is 255.

4. A primary key:

a. should use Social Security numbers whenever possible.

b. cannot be a composite key.

c. should be null whenever possible.

d. should be a value that will never change.

A primary key should be a value that will never change.

5. Kevin needs to update a field in a linked table. He should:

a. delete the source data file so that it does not interfere with the linked table.

b. adjust the value directly in the linked table.

c. adjust the value in the source data file.

d. run the linked table update manager.

Kevin should adjust the value in the source data file. You cannot edit values directly in a linked table.

Lesson 3

1. Which statement accurately compares filtering to sorting?

a. Filtering removes records from table, whereas sorting simply hides records.

b. Filtering hides records in a table, whereas sorting changes the physical order of the records.

c. Filtering isolates a subset of data, whereas sorting simply changes the display order.

d. Filtering and sorting both change the physical order of records.

Filtering isolates a subset of data. Sorting changes the order in which the records display. (Lesson 3, Filtering Records)

2. Amanda wants to add another table to her query. Which of the following buttons should she click on the Ribbon?

a. Make Table

b. View

c. Show Table

d. Update

Amanda should click the Show Table button to open the Show Table dialog box. Clicking the Make Table button converts a select query into a make-table query. Clicking the View button opens a menu of available views for the current object. Clicking the Update button converts a select query to an update query. (Lesson 3, Working with Joined Tables)

3. Phil is having difficulty achieving the sort order he wants for his datasheet. He wants to sort in ascending order by state, and then in descending order by city. Which of the following is most likely the problem?

a. The query is read-only and cannot be modified.

b. The primary key for the table is a number field, making it impossible to sort on a text field.

c. The Format property for the State field is set to Non-indexed.

d. The City field is further left than the State field in the design grid.

The City field is further left than the State field in the design grid. When you sort by multiple fields, the field furthest to the left in the design grid becomes the primary sort order key; the next field to the right for which you specify a sort order becomes the secondary sort key, and so on. (Lesson 3, Sorting query fields)

4. What function does the Zoom box serve?

a. You can use it to build accurate expressions.

b. You can use it to display expressions and make them easier to read.

c. You can use it to optimize a query and make it run faster.

d. You can use it to quickly add the fields in a field list to the design grid.

The Zoom box is a dialog box that displays expressions and allows you to adjust the font, font size and font color. (Lesson 3, Adding calculated fields to a query)

5. The results of an action query:

a. cannot be reversed.

b. are reversible.

c. summarize data.

d. run other queries stored in the same database.

The results of an action query cannot be reversed. Making backup copies of the tables and testing the query first as a select query are recommended precautionary actions. (Lesson 3, Creating Action Queries)

Lesson 4

1. Ken created a form based on a Departments table, and created a form based on an Employees table. There is no established relationship in the database between the Departments table and the Employees table. Ken wants to use his Employees form as subform in the Departments form. What must he do to make sure the Employees subform shows the correct records for the current record in the Departments form?

a. Create the form using an automated from tool that will automatically link the forms correctly.

b. Set the Control Source property for the main form to a query.

c. Set the Link Master Fields and Link Child Fields properties in the Property Sheet for the subform.

d. Set the Record Source property for the subform to a query.

Ken needs to set the Link Master Fields and Link Child Fields properties in the Property Sheet. These settings identify the primary and foreign key fields in the tables on which the forms are based. You can click in the Link Master Fields or the Link Child Fields row in the Property Sheet to display the Build button (…). Click the Build button to open the Subform Field

2. Which of the following actions can you perform in Design view, but not in Layout view?

a. Resize form sections.

b. View the Property Sheet for a control.

c. Drag fields onto the form from the Field List.

d. Add a combo box from the Ribbon onto the form.

You can access and resize form sections only in Design view.

3. Sheila is working on a form in Layout view. She is trying to resize one text box control without affecting the other controls in the same column. What should Sheila do?

a. Switch to Design view.

b. Set the Size Mode property for the text box control.

c. Drag the right and bottom boundaries of the design grid as close as possible to the control she wants to resize.

d. Remove the control she wants to format independently from the layout.

Sheila should remove the control from the layout. To move and size controls independently, you must remove them from the layout.

4. Phil can click a control named Composer on his ConcertoMasterpieces form. He can also tab to the Composer control. However, he cannot edit its data. Which of the following property settings are in effect for the Composer control?

a. Locked=Yes; Enabled=Yes.

b. Locked=Yes; Enabled=No.

c. Locked=No; Tab Stop=No.

d. Locked=No; Enabled=Yes.

Locked=Yes; Enabled=Yes. If Phil can click or tab to the control, the Enabled property is set to Yes. If Phil cannot edit the control, its Locked Property is set to Yes.

5. Which of the following objects does not have a Property Sheet?

a. A form

b. A form footer section

c. A check box control

d. All of the listed items have a Property Sheet

Each control on a form possesses specific properties that affect its behavior and appearance. Sections of a form and the form itself possess properties that exert similar control. Properties can be viewed in a control’s Property sheet.

Lesson 5

1. Which of the following is a limitation of the Report Tool?

a. It generates reports that are connected to a single data source only.

b. It is time-consuming to use.

c. It adds only the first four fields of data to the report.

d. It generates reports that cannot be modified.

The Report Tool generates reports that are connected to a single data source only. To create a report that uses more than one data source, use the Report wizard or create a report from scratch.

2. Phil sees blank pages when he examines his report in Print Preview. Which of the following can cause this situation?

a. The report’s margins are too narrow to force the data to display.

b. The report does not have a valid data source.

c. There are empty records in the database.

d. The report is too wide for the paper.

The report is too wide for the paper. The report width (plus the space for the margins) must fit within the edges of the selected paper size.

3. Ken has added an unbound text box control to a report and he wants to use the text box to display the total price for each line item in an order. He should enter the expression =[Quantity]*[UnitPrice] in which property for the unbound text box control?

a. The Record Source property.

b. The Control Source property.

c. The Row Source property.

d. The Expression Source property.

Ken should enter the expression in the Control Source property for the unbound text box control.

4. Which of the following statements is true of date and time stamps in reports?

a. There are five formats available for each.

b. They must be inserted as a pair of controls.

c. They cannot be automatically inserted into a report footer.

d. You can insert only one or the other; not both.

You cannot automatically insert a date and/or time into the report footer section. There are three formats available for each, and you can insert them individually or as a pair of controls.

5. Amanda opens a report on customers in Print Preview and sees that the report will be 135 pages long. Amanda needs information on customers from three states only. Which of the following is the best solution to allow Amanda to obtain her printed output without wasting so much paper on unneeded information?

a. Amanda should apply a filter to the report before printing.

b. Amanda should sort the report by state and print only the pages between her first state and her last state.

c. Amanda should use the Find command to wade through the report in Report view, and print each page that contains information that she needs.

d. Amanda should print the entire report and recycle the pages she does not need.

Amanda should apply a filter to the report before printing. If there is a large amount of data in the underlying data source for a report, it is useful to be able to filter a subset of records that you want to include in the report.

Lesson 6

1. Joan has forgotten the password for an Access database she created three months ago. Which of the following would provide the best chance for her to access her data?

a. The Undo command.

b. The Microsoft Knowledge Base.

c. A phone conversation with a Microsoft technical support expert.

d. The most recent backup file that has not been password-protected.

2. Ken wants to “clean up” his database file by removing non-essential database objects. There are several queries and forms that he believes are no longer relevant. How should he proceed?

a. Ken can view the object dependencies for each object in question.

b. Ken can delete each object he thinks is no longer necessary; if it turns out that he still needs them, he can undo the deletions.

c. Ken can set the database to compact and repair on close. Compacting removes any unnecessary database objects.

d. Ken can split the database into a front end and back end; splitting the database removes any unnecessary database objects.

3. What information is automatically appended to a database file name when you back up the database?

a. the IP address of the system on which the database resides.

b. the date of the backup.

c. the path to the database server where the database resides.

d. the name of the person performing the backup.

4. Which of the following statements about ACCDE databases is true?

a. Users cannot print reports in an ACCDE database.

b. Users cannot read table data in an ACCDE database.

c. Users cannot change the design of forms or reports in an ACCDE database.

d. Uses cannot enter or edit data in an ACCDE database.

5. Which of the following is true about a database backup file?

a. A database backup file is automatically saved in ACCDE format.

b. A database backup file is simply a copy of the database.

c. A database backup file is a compiled version of the database.

d. A database backup file can only be opened using a specialized Backup/Recovery application.