Question 1

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

Question 2

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

Question 3

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

Question 4

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.

Question 5

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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.

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Which data type stores only one of two values?

Accepted Answer

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

Question 11

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.

Question 12

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.

Question 13

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 14

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Which data type stores web addresses?

Accepted Answer

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

Question 17

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.

Question 18

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.

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 1: Getting Started With Excel

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which data type stores only one of two values?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which data type stores web addresses?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified