Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

When you edit a record,pressing ESC once removes the changes to the field.What happens if you press ESC a second time?

Accepted Answer

A)  Access restores the changes to the field. 
B)  Access deletes the record. 
C)  Access deletes the field. 
D)  Access removes all changes to the record. 
A)  Access restores the changes to the field. 
B)  Access deletes the record. 
C)  Access deletes the field. 
D)  Access removes all changes to the record.

Question 3

To back up a database,you use the _____ command.

Accepted Answer

A)  Make a Backup 
B)  Back Up Database 
C)  Package and Sign 
D)  Compact & Repair 
A)  Make a Backup 
B)  Back Up Database 
C)  Package and Sign 
D)  Compact & Repair

Question 4

Which of the following can you define in Table Datasheet view? Select all the options that apply.

Accepted Answer

A)  field descriptions 
B)  field names 
C)  data types 
D)  field properties 
A)  field descriptions 
B)  field names 
C)  data types 
D)  field properties

Question 5

To navigate to a record in a table,switch to Table Design view.

Accepted Answer

A) True 
 B)False

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

What is the difference between entering a record using a form and entering a record using a datasheet?

Accepted Answer

A)  A form uses a different navigation bar from the one in a datasheet. 
B)  A form cannot be sorted,while a datasheet can. 
C)  A form presents records one at a time,while a datasheet lists all records. 
D)  A form displays field names and record data,while a datasheet does not. 
A)  A form uses a different navigation bar from the one in a datasheet. 
B)  A form cannot be sorted,while a datasheet can. 
C)  A form presents records one at a time,while a datasheet lists all records. 
D)  A form displays field names and record data,while a datasheet does not.

Question 8

In an Employees table,what is the appropriate data type for a field that shows the hiring date?

Accepted Answer

A)  Calendar 
B)  Date 
C)  Date/Time 
D)  Lookup 
A)  Calendar 
B)  Date 
C)  Date/Time 
D)  Lookup

Question 9

To rename a field in Table Datasheet view,you change the text in the _____.

Accepted Answer

A)  column heading 
B)  first record 
C)  primary key 
D)  Navigation Pane 
A)  column heading 
B)  first record 
C)  primary key 
D)  Navigation Pane

Question 10

When editing a record,what key can you use to navigate to the next record?

Accepted Answer

A)  DOWN ARROW 
B)  END 
C)  LEFT ARROW 
D)  ESC 
A)  DOWN ARROW 
B)  END 
C)  LEFT ARROW 
D)  ESC

Question 11

Which Access object contains all of the data in the database?

Accepted Answer

A)  form 
B)  macro 
C)  table 
D)  query 
A)  form 
B)  macro 
C)  table 
D)  query

Question 12

Which of the following is a best practice when you are creating a table containing employee names?

Accepted Answer

A)  Separate the first and last names into two fields. 
B)  Keep the first and last names together in one field. 
C)  Assign the Long data type to any field containing names. 
D)  Create the table in Table Datasheet view. 
A)  Separate the first and last names into two fields. 
B)  Keep the first and last names together in one field. 
C)  Assign the Long data type to any field containing names. 
D)  Create the table in Table Datasheet view.

Question 13

When using the Report Wizard,you can click the Back button to review previous dialog boxes.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following are examples of changing a table's design? Select all the options that apply.

Accepted Answer

A)  Add a field to the table. 
B)  Rename a field in the table. 
C)  Change a field value. 
D)  Change a field's data type. 
A)  Add a field to the table. 
B)  Rename a field in the table. 
C)  Change a field value. 
D)  Change a field's data type.

Question 15

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

Accepted Answer

A) True 
 B)False

Question 16

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 17

You can create an Access report by selecting fields from one or more tables or _____.

Accepted Answer

A)  records 
B)  forms 
C)  queries 
D)  modules 
A)  records 
B)  forms 
C)  queries 
D)  modules

Question 18

Before you can rename a field,you must change its data type.

Accepted Answer

A) True 
 B)False

Question 19

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 20

Which data type stores web addresses?

Accepted Answer

A)  Web 
B)  URL 
C)  HTML 
D)  Hyperlink 
A)  Web 
B)  URL 
C)  HTML 
D)  Hyperlink

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

When you edit a record,pressing ESC once removes the changes to the field.What happens if you press ESC a second time?

To back up a database,you use the _____ command.

Which of the following can you define in Table Datasheet view? Select all the options that apply.

To navigate to a record in a table,switch to Table Design view.

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

What is the difference between entering a record using a form and entering a record using a datasheet?

In an Employees table,what is the appropriate data type for a field that shows the hiring date?

To rename a field in Table Datasheet view,you change the text in the _____.

When editing a record,what key can you use to navigate to the next record?

Which Access object contains all of the data in the database?

Which of the following is a best practice when you are creating a table containing employee names?

When using the Report Wizard,you can click the Back button to review previous dialog boxes.

Which of the following are examples of changing a table's design? Select all the options that apply.

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

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

You can create an Access report by selecting fields from one or more tables or _____.

Before you can rename a field,you must change its data type.

Which data type stores only one of two values?

Which data type stores web addresses?

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

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

When you edit a record,pressing ESC once removes the changes to the field.What happens if you press ESC a second time?

To back up a database,you use the _____ command.

Which of the following can you define in Table Datasheet view? Select all the options that apply.

To navigate to a record in a table,switch to Table Design view.

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

What is the difference between entering a record using a form and entering a record using a datasheet?

In an Employees table,what is the appropriate data type for a field that shows the hiring date?

To rename a field in Table Datasheet view,you change the text in the _____.

When editing a record,what key can you use to navigate to the next record?

Which Access object contains all of the data in the database?

Which of the following is a best practice when you are creating a table containing employee names?

When using the Report Wizard,you can click the Back button to review previous dialog boxes.

Which of the following are examples of changing a table's design? Select all the options that apply.

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

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

You can create an Access report by selecting fields from one or more tables or _____.

Before you can rename a field,you must change its data type.

Which data type stores only one of two values?

Which data type stores web addresses?

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