Question 1

After you select an action, Access displays the argument(s) ____ the action.

Accepted Answer

A)  on top of 
B)  below 
C)  to the left of 
D)  to the right of 
A)  on top of 
B)  below 
C)  to the left of 
D)  to the right of

Question 2

Table, form, and report objects in the database can have the same name.

Accepted Answer

A) True 
 B)False

Question 3

If you don't want to print the letter for the currently displayed record, click Exclude this recipient in the Mail Merge pane.

Accepted Answer

A) True 
 B)False

Question 4

The ____ Value property enters the same field value in a field every time a new record is added to the table.

Accepted Answer

A)  Default 
B)  Repeat 
C)  Redo 
D)  Sample 
A)  Default 
B)  Repeat 
C)  Redo 
D)  Sample

Question 5

When you create a report using the Report Wizard, you might need to adjust the report's width to eliminate blank pages. You know that you need to make this change when you see ____ in the report.

Accepted Answer

A)  blank lines 
B)  blank pages 
C)  a line of pound signs 
D)  a page of pound signs 
A)  blank lines 
B)  blank pages 
C)  a line of pound signs 
D)  a page of pound signs

Question 6

The main navigation form serves as the main menu, letting you select the ____ navigation forms in the main form.

Accepted Answer

A)  lower-level 
B)  upper-level 
C)  startup 
D)  control 
A)  lower-level 
B)  upper-level 
C)  startup 
D)  control

Question 7

The ____ object is similar to a macro, but allows more complex programming of database operations.

Accepted Answer

A)  Table 
B)  Module 
C)  Query 
D)  Report 
A)  Table 
B)  Module 
C)  Query 
D)  Report

Question 8

A navigation form acts as a map for the splash screen.

Accepted Answer

A) True 
 B)False

Question 9

Typically records in a table appear in rows, and the columns display the information for the field.

Accepted Answer

A) True 
 B)False

Question 10

Selecting a newly added navigation form tab lets you view a report in the subform control.

Accepted Answer

A) True 
 B)False

Question 11

Match between columns
                        Premises: If you do not see the Field List pane, click the Add Existing Fields button in the ____ group on the Design tab.

Accepted Answer

The Answer of New and Home and Tools and File is...

Question 12

In a table, the first key is the field that contains a unique field value for each record in the table.

Accepted Answer

A) True 
 B)False

Question 13

Just like in Form Design view, you can adjust the height of a section by dragging its bottom edge up or down, and you can select a section in a report by clicking its ____.

Accepted Answer

A)  control icon 
B)  section bar 
C)  upper edge 
D)  lower edge 
A)  control icon 
B)  section bar 
C)  upper edge 
D)  lower edge

Question 14

You can change the colors used in the rows of the datasheet by clicking the arrow on the Alternate Row Color button in the Text Formatting group on the ____________________ tab.

Accepted Answer

The answer of You can change the colors used in...

Question 15

Another type of condition that you can create causes a record to be displayed in the query datasheet when the record matches a range of values. This is called a ____.

Accepted Answer

A)  complex condition 
B)  multi-field condition 
C)  simple condition 
D)  range-of-values condition 
A)  complex condition 
B)  multi-field condition 
C)  simple condition 
D)  range-of-values condition

Question 16

A(n) ____________________ is a document that includes codes that print information from a data source.

Accepted Answer

The answer of A(n) ____________________ is a document that includes...

Question 17

Backing up a database rearranges how the database is stored on the disk and optimizes the performance of the database.

Accepted Answer

A) True 
 B)False

Question 18

Case AC 2-2 Jennifer is creating a new inventory management table for the pet store where she works. She is spending the time upfront to make sure the data types are all assigned correctly. Jennifer's boss asks her if they can include detailed descriptions of each item in the database. The descriptions would be approximately 5000 characters. For this field she assigns the ____ data type.

Accepted Answer

A)  Text 
B)  Memo 
C)  AutoNumber 
D)  Description 
A)  Text 
B)  Memo 
C)  AutoNumber 
D)  Description

Question 19

You can remove a control from a control layout in a report just like you can for a form. Display the report in ____ view, click the control to select it, right-click the control to open the shortcut menu, point to Layout, and then click Remove Layout.

Accepted Answer

A)  Format 
B)  Layout 
C)  Design 
D)  Data 
A)  Format 
B)  Layout 
C)  Design 
D)  Data

Question 20

When setting up lookup properties, the ____ Type lets you select from where the items in the list will come.

Accepted Answer

A)  Field Source 
B)  Field Input 
C)  Row Source 
D)  List 
A)  Field Source 
B)  Field Input 
C)  Row Source 
D)  List

After you select an action, Access displays the argument(s) ____ the action.

Table, form, and report objects in the database can have the same name.

If you don't want to print the letter for the currently displayed record, click Exclude this recipient in the Mail Merge pane.

The ____ Value property enters the same field value in a field every time a new record is added to the table.

When you create a report using the Report Wizard, you might need to adjust the report's width to eliminate blank pages. You know that you need to make this change when you see ____ in the report.

The main navigation form serves as the main menu, letting you select the ____ navigation forms in the main form.

The ____ object is similar to a macro, but allows more complex programming of database operations.

A navigation form acts as a map for the splash screen.

Typically records in a table appear in rows, and the columns display the information for the field.

Selecting a newly added navigation form tab lets you view a report in the subform control.

In a table, the first key is the field that contains a unique field value for each record in the table.

Just like in Form Design view, you can adjust the height of a section by dragging its bottom edge up or down, and you can select a section in a report by clicking its ____.

You can change the colors used in the rows of the datasheet by clicking the arrow on the Alternate Row Color button in the Text Formatting group on the ____________________ tab.

Another type of condition that you can create causes a record to be displayed in the query datasheet when the record matches a range of values. This is called a ____.

A(n) ____________________ is a document that includes codes that print information from a data source.

Backing up a database rearranges how the database is stored on the disk and optimizes the performance of the database.

You can remove a control from a control layout in a report just like you can for a form. Display the report in ____ view, click the control to select it, right-click the control to open the shortcut menu, point to Layout, and then click Remove Layout.

When setting up lookup properties, the ____ Type lets you select from where the items in the list will come.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 1: Microsoft Access Basics

After you select an action, Access displays the argument(s) ____ the action.

Table, form, and report objects in the database can have the same name.

If you don't want to print the letter for the currently displayed record, click Exclude this recipient in the Mail Merge pane.

The ____ Value property enters the same field value in a field every time a new record is added to the table.

When you create a report using the Report Wizard, you might need to adjust the report's width to eliminate blank pages. You know that you need to make this change when you see ____ in the report.

The main navigation form serves as the main menu, letting you select the ____ navigation forms in the main form.

The ____ object is similar to a macro, but allows more complex programming of database operations.

A navigation form acts as a map for the splash screen.

Typically records in a table appear in rows, and the columns display the information for the field.

Selecting a newly added navigation form tab lets you view a report in the subform control.

In a table, the first key is the field that contains a unique field value for each record in the table.

Just like in Form Design view, you can adjust the height of a section by dragging its bottom edge up or down, and you can select a section in a report by clicking its ____.

You can change the colors used in the rows of the datasheet by clicking the arrow on the Alternate Row Color button in the Text Formatting group on the ____________________ tab.

Another type of condition that you can create causes a record to be displayed in the query datasheet when the record matches a range of values. This is called a ____.

A(n) ____________________ is a document that includes codes that print information from a data source.

Backing up a database rearranges how the database is stored on the disk and optimizes the performance of the database.

You can remove a control from a control layout in a report just like you can for a form. Display the report in ____ view, click the control to select it, right-click the control to open the shortcut menu, point to Layout, and then click Remove Layout.

When setting up lookup properties, the ____ Type lets you select from where the items in the list will come.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters