Question 1

Compacting a database has the same result as backing up a database.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

Which of the following statements describe a query datasheet? Select all the options that apply.

Accepted Answer

A)  You can edit the records in a query datasheet. 
B)  You store data in a query by entering a record in a query datasheet. 
C)  You can display a subset of records and fields from a table in a query datasheet. 
D)  You can sort and filter a query datasheet. 
A)  You can edit the records in a query datasheet. 
B)  You store data in a query by entering a record in a query datasheet. 
C)  You can display a subset of records and fields from a table in a query datasheet. 
D)  You can sort and filter a query datasheet.

Question 5

Which of the following techniques can you use to navigate to the next record in a datasheet? Select all the options that apply.

Accepted Answer

A)  First record button 
B)  Next record button 
C)  TAB key 
D)  DOWN ARROW key 
A)  First record button 
B)  Next record button 
C)  TAB key 
D)  DOWN ARROW key

Question 6

When editing a record using a form, how can you move from field to field in the same record?

Accepted Answer

A)  Press TAB. 
B)  Click the Next field button in the navigation bar. 
C)  Press the PAGE DOWN key. 
D)  Click the right arrow button in the navigation bar. 
A)  Press TAB. 
B)  Click the Next field button in the navigation bar. 
C)  Press the PAGE DOWN key. 
D)  Click the right arrow button in the navigation bar.

Question 7

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

Question 8

Which of the following are Access data types? Select all the options that apply.

Accepted Answer

A)  Number 
B)  Street Address 
C)  Date/Time 
D)  Currency 
A)  Number 
B)  Street Address 
C)  Date/Time 
D)  Currency

Question 9

You can assign most but not all data types to a field in Table Datasheet view.

Accepted Answer

A) True 
 B)False

Question 10

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

Question 11

What should you do if you want to make a copy of a database in a secure location?

Accepted Answer

A)  Back up the database. 
B)  Compact and repair the database 
C)  Convert the database. 
D)  Split the database. 
A)  Back up the database. 
B)  Compact and repair the database 
C)  Convert the database. 
D)  Split the database.

Question 12

You use the Report tool to quickly create a report based on the selected table.

Accepted Answer

A) True 
 B)False

Question 13

What is the most efficient way to navigate to the last record in a table containing 100 records?

Accepted Answer

A)  Press the END key. 
B)  Press TAB as many times as necessary. 
C)  Use the Next record button on the navigation bar. 
D)  Use the Last record button on the navigation bar. 
A)  Press the END key. 
B)  Press TAB as many times as necessary. 
C)  Use the Next record button on the navigation bar. 
D)  Use the Last record button on the navigation bar.

Question 14

A form selects a subset of fields and records from one or more tables, and then presents the selected data as a single datasheet.

Accepted Answer

False - qu

Question 15

Which data type stores only one of two values?

Accepted Answer

A)  Hyperlink 
B)  Date/Time 
C)  Yes/No 
D)  AutoNumber 
A)  Hyperlink 
B)  Date/Time 
C)  Yes/No 
D)  AutoNumber

Question 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

Besides reducing file size, what other benefit does compacting an Access database provide?

Accepted Answer

A)  sorting the records in the database 
B)  repairing the database 
C)  saving the database 
D)  relating tables in the database 
A)  sorting the records in the database 
B)  repairing the database 
C)  saving the database 
D)  relating tables in the database

Question 19

Before you close a database, you must save any changes you made to the data.

Accepted Answer

A) True 
 B)False

Question 20

What data type should you assign to a field that stores postal codes?

Accepted Answer

A)  Number 
B)  Address 
C)  Required 
D)  Short Text 
A)  Number 
B)  Address 
C)  Required 
D)  Short Text

Compacting a database has the same result as backing up a database.

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

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

Which of the following statements describe a query datasheet? Select all the options that apply.

Which of the following techniques can you use to navigate to the next record in a datasheet? Select all the options that apply.

When editing a record using a form, how can you move from field to field in the same record?

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

Which of the following are Access data types? Select all the options that apply.

You can assign most but not all data types to a field in Table Datasheet view.

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

What should you do if you want to make a copy of a database in a secure location?

You use the Report tool to quickly create a report based on the selected table.

What is the most efficient way to navigate to the last record in a table containing 100 records?

A form selects a subset of fields and records from one or more tables, and then presents the selected data as a single datasheet.

Which data type stores only one of two values?

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

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

Besides reducing file size, what other benefit does compacting an Access database provide?

Before you close a database, you must save any changes you made to the data.

What data type should you assign to a field that stores postal codes?

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

Compacting a database has the same result as backing up a database.

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

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

Which of the following statements describe a query datasheet? Select all the options that apply.

Which of the following techniques can you use to navigate to the next record in a datasheet? Select all the options that apply.

When editing a record using a form, how can you move from field to field in the same record?

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

Which of the following are Access data types? Select all the options that apply.

You can assign most but not all data types to a field in Table Datasheet view.

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

What should you do if you want to make a copy of a database in a secure location?

You use the Report tool to quickly create a report based on the selected table.

What is the most efficient way to navigate to the last record in a table containing 100 records?

A form selects a subset of fields and records from one or more tables, and then presents the selected data as a single datasheet.

Which data type stores only one of two values?

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

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

Besides reducing file size, what other benefit does compacting an Access database provide?

Before you close a database, you must save any changes you made to the data.

What data type should you assign to a field that stores postal codes?

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