Access

What Query view is shown in this image?

• Datasheet View
• Design View

Where do you configure the field properties of a Table?

• Design View
• Datasheet View
• Access View
• Window View

Where do you see the results of a Query?

• Query Design View
• Query Datasheet View
• Query DataSet Review
• Table Design View

Data type where the field can contain any character is "_____".

• text
• autonumber
• currency
• decimal

If you want to put your data into alphabetical order by last name, you could use the __________ command.

• Shift
• Font
• autofill
• Sort

To rename a table or other database object, first 

• save it.
  
• close it.
  
• edit it. 
• open it. 

A complete list of field properties is available in 

• the Navigation Pane.
  
• Datasheet view.
  
• Design view. 
• all of the above. 

Which field property requires users to enter data in a specific format such as a telephone number or social security?

• Validation Text
• Default Value
• Required
• Input Mask

The Default Value property can be used for which field?

• Short Text
• Number
• Currency
• All of the above

When you create a new blank database, Access opens a database that contains

• one of each type of database object.
• a table.
• sample data.
• a template.