Exam 11: Introduction to Access: Finding Your Way Through an Access Database

A primary key may use a(n)________ data type--a generated primary key that is automatically incremented each time a record is added.

How is referential integrity helpful?

A template is a predefined database that can be used to jumpstart the creation of a database.

You can create a Web app from a Web app template from the Backstage view.

The Undo button does not reverse the most recent change in Access 2013.

You can create or modify a table's field names and data types in ________ view.

Which of the following is TRUE about Access' Compact and Repair feature?

Alice is working in a database containing the names,service locations,and services offered by landscapers.She needs to find landscapers that offer services in the Phoenix area and that service rare plants.The best way for her to search for this data is to perform a:

Describe how Access sorts multiple criteria in a database.

Which of the following is an object that adds functionality to a database and is written using VBA?

Which of the following is NOT a tab in Access 2013?

Ryan is working in a database that organizes vendor contact information.Ryan must find vendors located in Seattle and Portland.The vendors must have offices in both cities in order to meet Ryan's requirements.He should use the Filter by Form ________ condition.

Access' ________ feature creates a duplicate copy of a database.

Microsoft ________ is the database management system included in Office 20013 Professional.

A field that is defined as a primary key in one table is defined as a(n)________ in a related table.

Objects that are part of an Access database are available from the ________ within Access.

What does a custom Web app enable you to do?

Information is what is typically entered into a database.Data is the finished product of the database.

A relationship is a connection between: