Question 1

In a datasheet, what do you click to select a record for deletion?

Accepted Answer

A)   column heading
B)   field in the record
C)   record deletion button
D)   record selector button

Question 2

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

Accepted Answer

A)   Shutter Bar Open/Close button
B)   Expand button
C)   View tab
D)   Navigation bar

Question 3

In which object can you rename a field?

Accepted Answer

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

Question 4

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 5

Which data type stores web addresses?

Accepted Answer

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

Question 6

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.

Question 7

Which of the following options are available to you when you start Access? Select all the options that apply.

Accepted Answer

A)   Import an existing database.
B)   Open an existing database.
C)   Create a new blank database.
D)   Create a database from a template.

Question 8

When you enter a record in a table, you are working in navigation mode.

Accepted Answer

False - ed...

Question 9

You can enter, edit, and navigate data in a query datasheet just like in a report datasheet.

Accepted Answer

False - ta...

Question 10

The Form Wizard prompts you for information it needs to create a form, such as the fields, layout, and title for the form.

Accepted Answer

A) True 
 B)False

Question 11

To close an Access module, you must close the Visual Basic Editor.

Accepted Answer

A) True 
 B)False

Question 12

Which data type is used for sequential integers controlled by Access?

Accepted Answer

A)   Number
B)   AutoNumber
C)   SeqNumber
D)   Integer

Question 13

Which of the following are tasks you perform when creating tables? Select all the options that apply.

Accepted Answer

A)   Name the table.
B)   Define the fields in the table.
C)   Select a data type for each field.
D)   Arrange the controls for easy data entry.

Question 14

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

Question 15

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 16

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 17

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

Question 18

Which of the following is the fastest way to open an Access database?

Accepted Answer

A)   Start Access from the Start menu.
B)   Double-click the database icon.
C)   Start Access, and then create a new database.
D)   Right-click the database icon.

Question 19

Each row in a table datasheet displays a _____.

Accepted Answer

A)   data type
B)   property
C)   field
D)   record

Question 20

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

Exam 1: Getting Started With Excel

In which object can you rename a field?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The Form Wizard prompts you for information it needs to create a form, such as the fields, layout, and title for the form.

Correct AnswerverifiedShow Answer

To close an Access module, you must close the Visual Basic Editor.

Correct AnswerverifiedShow Answer

Each row in a table datasheet displays a _____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following is the fastest way to open an Access database?

Correct AnswerverifiedShow Answer

In a datasheet, what do you click to select a record for deletion?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following are tasks you perform when creating tables? Select all the options that apply.

Correct AnswerverifiedShow Answer

Which of the following options are available to you when you start Access? Select all the options that apply.

Correct AnswerverifiedShow Answer

Which data type stores web addresses?

Correct AnswerverifiedShow Answer

You can enter, edit, and navigate data in a query datasheet just like in a report datasheet.

Correct AnswerverifiedFalse - ta...View AnswerShow Answer

When you enter a record in a table, you are working in navigation mode.

Correct AnswerverifiedFalse - ed...View AnswerShow Answer

Which data type is used for sequential integers controlled by Access?

Correct AnswerverifiedShow Answer

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

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
False - ta...
View Answer

Correct Answer
verified
False - ed...
View Answer

Correct Answer
verified

Correct Answer
verified