Question 1

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

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.

Question 3

The first step in the Form Wizard is to _____.

Accepted Answer

A)   select a layout for the form
B)   select a sort order for the records
C)   select the fields to include in the form
D)   provide a name for the form

Question 4

For a Comments field that contains many words, set a Long data type.

Accepted Answer

A) True 
 B)False

Question 5

When you double-click an Access database icon, you have the choice of opening a database or creating a new one.

Accepted Answer

A) True 
 B)False

Question 6

_____ is the default name for a new table in an Access database.

Accepted Answer

A)   Table1
B)   NewTable
C)   Table
D)   TableA

Question 7

Microsoft Access 2016 can best be described as ____ software.

Accepted Answer

A)   spreadsheet
B)   relationship
C)   utility
D)   database

Question 8

To display the data in a table, you open the table in Table Design view.

Accepted Answer

False - Datasheet
False - Data...

Question 9

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 10

A new blank desktop database includes one table named Table1.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following are Access objects?

Accepted Answer

A)   forms
B)   spreadsheets
C)   reports
D)   queries

Question 12

To navigate records in Form view, you use the buttons on the _____.

Accepted Answer

A)   navigation bar
B)   Navigation Pane
C)   Home tab
D)   record bar

Question 13

You can create a table in Table Datasheet view or Table Design view.

Accepted Answer

A) True 
 B)False

Question 14

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 15

What should you do when you are finished working a database?

Accepted Answer

A)   Open and then save each object in the database.
B)   Close the Navigation Pane.
C)   Sign out so other people can use the database.
D)   Close the database.

Question 16

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 17

Each item on a form is called a _____.

Accepted Answer

A)   control
B)   field
C)   layout
D)   format

Question 18

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 19

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

Accepted Answer

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

Question 20

A _____ is a grid that displays fields as columns and records as rows.

Accepted Answer

A)   query
B)   datasheet
C)   logical table
D)   report

Exam 1: Getting Started With Excel

When you double-click an Access database icon, you have the choice of opening a database or creating a new one.

Correct AnswerverifiedShow Answer

_____ is the default name for a new table in an Access database.

Correct AnswerverifiedShow Answer

What should you do when you are finished working a database?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

A _____ is a grid that displays fields as columns and records as rows.

Correct AnswerverifiedShow Answer

The first step in the Form Wizard is to _____.

Correct AnswerverifiedShow Answer

To navigate records in Form view, you use the buttons on the _____.

Correct AnswerverifiedShow Answer

Which of the following are Access objects?

Correct AnswerverifiedShow Answer

Microsoft Access 2016 can best be described as ____ software.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Each item on a form is called a _____.

Correct AnswerverifiedShow Answer

To display the data in a table, you open the table in Table Design view.

Correct AnswerverifiedFalse - DatasheetFalse - Data...View AnswerShow Answer

You can create a table in Table Datasheet view or Table Design view.

Correct AnswerverifiedShow Answer

A new blank desktop database includes one table named Table1.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

For a Comments field that contains many words, set a Long data type.

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified