Microsoft Access Quiz

What is the main function of the drop-down arrow in the Navigation Pane?

• To change sorting options

• To delete objects

• To print objects

• To share objects

Which data type is used to store monetary values?

• Currency

• Number

• Date/Time

• Short Text

Which data type allows you to attach files such as pictures and documents?

• Attachment

• Hyperlink

• OLE Object

• Long Text

Which tab do you switch to for Design View on the Home tab?

• Design View

• Create

• Table

• Lookup Wizard

What determines the order of fields in a table?

• The order you enter the field names

• The data type selected

• The size of the database

• The number of records

What data type is automatically created for a Primary Key in Access?

• Text

• Currency

• AutoNumber

• Date/Time

Which view should you be in to set a Primary Key?

• Datasheet View

• Design View

• Layout View

• Form View

What should you do after setting a Primary Key?

• Close the table

• Save the table

• Delete the table

• Change the view

What type of data can an input mask format?

• Only text data

• Only numerical data

• Various types of data

• Only image data

Which of the following is an example of an input mask?

• Email

• Phone Number

• Hyperlink

• Description