Question 1

When you close a report in Print Preview, Access displays the report in Design view.

Accepted Answer

A) True 
 B)False

Question 2

The Split Form tool creates a form using all the fields in the selected table or query and splits the window into four panes.

Accepted Answer

A) True 
 B)False

Question 3

When you need to change the data type for a selected field, you can do so by clicking the Data Type arrow in the ____ group on the Fields tab.

Accepted Answer

A)  Data 
B)  Views 
C)  Properties 
D)  Formatting 
A)  Data 
B)  Views 
C)  Properties 
D)  Formatting

Question 4

Just like when used in forms, you can add text to a report by adding it in the ____ control.

Accepted Answer

A)  text 
B)  address 
C)  comment 
D)  label 
A)  text 
B)  address 
C)  comment 
D)  label

Question 5

The ____ Wizard will take you through the steps of creating a report.

Accepted Answer

A)  Report 
B)  Parameter 
C)  Display 
D)  Calculate 
A)  Report 
B)  Parameter 
C)  Display 
D)  Calculate

Question 6

Describe the general syntax of the IF procedure.

Accepted Answer

The IF procedure begins with the code wo

Question 7

____________________ protects the data in the tables to make sure that data is not accidentally deleted or changed, resulting in inconsistent data.

Accepted Answer

Referentia

Question 8

A(n) ____________________ button is a button that users can click to perform common tasks.

Accepted Answer

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

Question 9

When ____ appear in a report, they appear in controls.

Accepted Answer

A)  properties 
B)  datasheets 
C)  worksheets 
D)  fields 
A)  properties 
B)  datasheets 
C)  worksheets 
D)  fields

Question 10

Another option for finding data quickly is to use the ____ command, which is available when you are using a table or query datasheet, form, or report.

Accepted Answer

A)  Find 
B)  Look 
C)  Hunt 
D)  Replace 
A)  Find 
B)  Look 
C)  Hunt 
D)  Replace

Question 11

Case AC 1-1 Jonathan is the IT manager for a Toy Company and is looking into using different types of database objects. Jonathan has information in Excel worksheets that he wants to add to the database. Worksheets are similar to datasheets, so he chooses to transfer this information into ____ objects.

Accepted Answer

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

Question 12

If you add a new field between two existing fields, Access recognizes the new field and places it as the last tab stop in the form.

Accepted Answer

A) True 
 B)False

Question 13

Figure AC 8-1   In Figure AC 8-1 above, item 2 points to ____.

Accepted Answer

A)  multiple tables in a query 
B)  parameters for the criteria field 
C)  the results from the query 
D)  the relationship with Employee ID fields 
A)  multiple tables in a query 
B)  parameters for the criteria field 
C)  the results from the query 
D)  the relationship with Employee ID fields

Question 14

Before printing a datasheet, you should view it in ____ so you can check the print settings.

Accepted Answer

A)  Print Preview 
B)  Datasheet view 
C)  black and white 
D)  Zoom mode 
A)  Print Preview 
B)  Datasheet view 
C)  black and white 
D)  Zoom mode

Question 15

AC Adv Case 13-1 Eric has been asked to write a VBA function to calculate the average salaries for his company's salespeople for the past five years. Eric asks for your help in getting started with VBA programming using the company's salary database. Eric suspects there will be similar requests in the future and wants the function he creates to be available for various database procedures. You suggest Eric define the function in a ____.

Accepted Answer

A)  control 
B)  subroutine 
C)  case 
D)  module 
A)  control 
B)  subroutine 
C)  case 
D)  module

Question 16

A lookup property can only be in the form of a combo box.

Accepted Answer

A) True 
 B)False

Question 17

The Back Up Database option is accessed by clicking the ____ option within the File tab.

Accepted Answer

A)  Save 
B)  Save & Publish 
C)  Backup 
D)  Save & Backup 
A)  Save 
B)  Save & Publish 
C)  Backup 
D)  Save & Backup

Question 18

Match between columns
                        Premises: Used when you want to enter data.

Accepted Answer

The Answer of expression and combo box and list box is...

Question 19

To insert a line, click the Line button in the Controls group on the ____ tab. Move the pointer to the report, click the plus sign in the pointer where you want the line to begin, and then drag the pointer to the location where you want the line to end.

Accepted Answer

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

Question 20

AC Case 12-2 Jennifer has designed a new Salary database. She would like to hide the Navigation pane and the Ribbon. Jennifer also wants to make sure that only authorized users, such as the database manager, can work with tables and other objects in Design view. She asks for your assistance. You explain that these options are located in the ____ dialog box.

Accepted Answer

A)  Startup 
B)  Macro 
C)  Access Options 
D)  Startup Options 
A)  Startup 
B)  Macro 
C)  Access Options 
D)  Startup Options

When you close a report in Print Preview, Access displays the report in Design view.

The Split Form tool creates a form using all the fields in the selected table or query and splits the window into four panes.

When you need to change the data type for a selected field, you can do so by clicking the Data Type arrow in the ____ group on the Fields tab.

Just like when used in forms, you can add text to a report by adding it in the ____ control.

The ____ Wizard will take you through the steps of creating a report.

Describe the general syntax of the IF procedure.

____________________ protects the data in the tables to make sure that data is not accidentally deleted or changed, resulting in inconsistent data.

A(n) ____________________ button is a button that users can click to perform common tasks.

When ____ appear in a report, they appear in controls.

Another option for finding data quickly is to use the ____ command, which is available when you are using a table or query datasheet, form, or report.

If you add a new field between two existing fields, Access recognizes the new field and places it as the last tab stop in the form.

Figure AC 8-1 In Figure AC 8-1 above, item 2 points to ____.

Before printing a datasheet, you should view it in ____ so you can check the print settings.

A lookup property can only be in the form of a combo box.

The Back Up Database option is accessed by clicking the ____ option within the File tab.

To insert a line, click the Line button in the Controls group on the ____ tab. Move the pointer to the report, click the plus sign in the pointer where you want the line to begin, and then drag the pointer to the location where you want the line to end.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 1: Microsoft Access Basics

When you close a report in Print Preview, Access displays the report in Design view.

The Split Form tool creates a form using all the fields in the selected table or query and splits the window into four panes.

When you need to change the data type for a selected field, you can do so by clicking the Data Type arrow in the ____ group on the Fields tab.

Just like when used in forms, you can add text to a report by adding it in the ____ control.

The ____ Wizard will take you through the steps of creating a report.

Describe the general syntax of the IF procedure.

____________________ protects the data in the tables to make sure that data is not accidentally deleted or changed, resulting in inconsistent data.

A(n) ____________________ button is a button that users can click to perform common tasks.

When ____ appear in a report, they appear in controls.

Another option for finding data quickly is to use the ____ command, which is available when you are using a table or query datasheet, form, or report.

If you add a new field between two existing fields, Access recognizes the new field and places it as the last tab stop in the form.

Figure AC 8-1 In Figure AC 8-1 above, item 2 points to ____.

Before printing a datasheet, you should view it in ____ so you can check the print settings.

A lookup property can only be in the form of a combo box.

The Back Up Database option is accessed by clicking the ____ option within the File tab.

To insert a line, click the Line button in the Controls group on the ____ tab. Move the pointer to the report, click the plus sign in the pointer where you want the line to begin, and then drag the pointer to the location where you want the line to end.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters