Question 1

When you finish creating a report with the Report Wizard,you can choose to preview the report or _____.

Accepted Answer

A)  modify the report's design 
B)  continue by creating a second report 
C)  send the report to a colleague 
D)  print the report 
A)  modify the report's design 
B)  continue by creating a second report 
C)  send the report to a colleague 
D)  print the report A

Question 2

Database templates create tables and queries,but not forms and reports.

Accepted Answer

A) True 
 B)False  False

Question 3

Which of the following are features of Access reports? Select all the options that apply.

Accepted Answer

A)  headers 
B)  calculations on groups of records 
C)  easy-to-use data entry screens 
D)  footers 
A)  headers 
B)  calculations on groups of records 
C)  easy-to-use data entry screens 
D)  footers A,B,D

Question 4

_____ view provides the most options for defining fields.

Accepted Answer

A)  Field Create 
B)  Field Define 
C)  Table Create 
D)  Table Design 
A)  Field Create 
B)  Field Define 
C)  Table Create 
D)  Table Design

Question 5

You can use a report to enter a record into the database.

Accepted Answer

A) True 
 B)False

Question 6

When you use the _____,Access asks you for the information it needs to create a query.

Accepted Answer

A)  Create Query Wizard 
B)  Form Wizard 
C)  Query Design command 
D)  Simple Query Wizard 
A)  Create Query Wizard 
B)  Form Wizard 
C)  Query Design command 
D)  Simple Query Wizard

Question 7

To learn more about a data type,you can enter the name of the data type in the Tell Me box.

Accepted Answer

A) True 
 B)False

Question 8

A group of related fields,such as all the demographic information for one customer,is called a _____.

Accepted Answer

A)  table 
B)  record 
C)  query 
D)  field 
A)  table 
B)  record 
C)  query 
D)  field

Question 9

You can use the Compact and Repair Database button on the Database Tools tab to reduce the size of the database.

Accepted Answer

A) True 
 B)False

Question 10

The _____ refers to the data you would edit if you started typing.

Accepted Answer

A)  focus 
B)  emphasis 
C)  editor 
D)  highlight 
A)  focus 
B)  emphasis 
C)  editor 
D)  highlight

Question 11

Which of the following are advantages of using Microsoft Access to manage data? Select all the options that apply.

Accepted Answer

A)  Access provides data-entry forms. 
B)  Access allows more than one user to enter data at the same time. 
C)  Access stores all the data in a single table. 
D)  Access minimizes duplicate data. 
A)  Access provides data-entry forms. 
B)  Access allows more than one user to enter data at the same time. 
C)  Access stores all the data in a single table. 
D)  Access minimizes duplicate data.

Question 12

What can you do with the navigation buttons on a datasheet? Select all the options that apply.

Accepted Answer

A)  Move the focus to the next record. 
B)  Create a new blank record. 
C)  Delete a record. 
D)  Move the focus to the first record. 
A)  Move the focus to the next record. 
B)  Create a new blank record. 
C)  Delete a record. 
D)  Move the focus to the first record.

Question 13

What Access tool can you use to enter dates in a Date/Time field?

Accepted Answer

A)  Date Box 
B)  Calendar Picker 
C)  Property Sheet 
D)  Lookup Wizard 
A)  Date Box 
B)  Calendar Picker 
C)  Property Sheet 
D)  Lookup Wizard

Question 14

A new blank desktop database includes one table named Table1.

Accepted Answer

A) True 
 B)False

Question 15

To navigate to the first record in a form,first switch to Form Design view.

Accepted Answer

A) True 
 B)False

Question 16

After you create a table,you must save the entire database so you do not lose the new table.

Accepted Answer

A) True 
 B)False

Question 17

Tables,queries,and forms are examples of Access ____.

Accepted Answer

A)  values 
B)  objects 
C)  fields 
D)  controls 
A)  values 
B)  objects 
C)  fields 
D)  controls

Question 18

What happens when you close a module?

Accepted Answer

A)  The module begins to run automatically. 
B)  The Visual Basic window closes. 
C)  The module is hidden in the Navigation Pane. 
D)  The Visual Basic window highlights any syntax errors. 
A)  The module begins to run automatically. 
B)  The Visual Basic window closes. 
C)  The module is hidden in the Navigation Pane. 
D)  The Visual Basic window highlights any syntax errors.

Question 19

Which type of template creates a traditional Access database?

Accepted Answer

A)  Application Part 
B)  custom web app 
C)  custom desktop 
D)  desktop database 
A)  Application Part 
B)  custom web app 
C)  custom desktop 
D)  desktop database

Question 20

What can you use to find information about Access commands and features and instructions about how to use them?

Accepted Answer

A)  Query Wizard 
B)  Access Wizard 
C)  Command box 
D)  Tell Me box 
A)  Query Wizard 
B)  Access Wizard 
C)  Command box 
D)  Tell Me box

When you finish creating a report with the Report Wizard,you can choose to preview the report or _____.

Database templates create tables and queries,but not forms and reports.

Which of the following are features of Access reports? Select all the options that apply.

_____ view provides the most options for defining fields.

You can use a report to enter a record into the database.

When you use the _____,Access asks you for the information it needs to create a query.

To learn more about a data type,you can enter the name of the data type in the Tell Me box.

A group of related fields,such as all the demographic information for one customer,is called a _____.

You can use the Compact and Repair Database button on the Database Tools tab to reduce the size of the database.

The _____ refers to the data you would edit if you started typing.

Which of the following are advantages of using Microsoft Access to manage data? Select all the options that apply.

What can you do with the navigation buttons on a datasheet? Select all the options that apply.

What Access tool can you use to enter dates in a Date/Time field?

A new blank desktop database includes one table named Table1.

To navigate to the first record in a form,first switch to Form Design view.

After you create a table,you must save the entire database so you do not lose the new table.

Tables,queries,and forms are examples of Access ____.

What happens when you close a module?

Which type of template creates a traditional Access database?

What can you use to find information about Access commands and features and instructions about how to use them?

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters

Exam 1: Getting Started With Excel

When you finish creating a report with the Report Wizard,you can choose to preview the report or _____.

Database templates create tables and queries,but not forms and reports.

Which of the following are features of Access reports? Select all the options that apply.

_____ view provides the most options for defining fields.

You can use a report to enter a record into the database.

When you use the _____,Access asks you for the information it needs to create a query.

To learn more about a data type,you can enter the name of the data type in the Tell Me box.

A group of related fields,such as all the demographic information for one customer,is called a _____.

You can use the Compact and Repair Database button on the Database Tools tab to reduce the size of the database.

The _____ refers to the data you would edit if you started typing.

Which of the following are advantages of using Microsoft Access to manage data? Select all the options that apply.

What can you do with the navigation buttons on a datasheet? Select all the options that apply.

What Access tool can you use to enter dates in a Date/Time field?

A new blank desktop database includes one table named Table1.

To navigate to the first record in a form,first switch to Form Design view.

After you create a table,you must save the entire database so you do not lose the new table.

Tables,queries,and forms are examples of Access ____.

What happens when you close a module?

Which type of template creates a traditional Access database?

What can you use to find information about Access commands and features and instructions about how to use them?

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters