Exam 2: Introduction to Access

What is not true about field properties?

A(n) ________ allows you to poll the data in your database.

In Datasheet view, what does a pencil symbol to the left of a record indicate?

A customer's cell phone would be an example of a ________.

Reports can draw data from tables or queries.

What is not true about records?

What is not true about the Compact and Repair Database utility?

Your birthday would be a good candidate for a primary key.

Match the following terms with their description: I. Report II. Selection Filter III. Sort IV. Table V. Template A. An object which displays formatted information in a professional manner B. Listing records in a specific sequence C. A way of limiting the number of records displayed D. Used to jumpstart your database E. The object in which the data is stored

Databases only work with data, not information.

When you split a database, what object type is put in the back end?

What database object organizes your data by rows and columns?

The ________ icon indicates that a field is the primary key.

To create a database from a template you would use which view?

How would you sort records in a field so that the oldest birthday is listed first?

The ________ command helps you locate specific records.

Microsoft SSL Server is an example of an advanced DBMS.

Match the following with their description: I. <>, =., >, < II. AND, OR, NOT III. Contains "Bill" IV. Tabs Documents interface V. Oracle A. Could be used in a selection filter B. Objects open in their own area under the ribbon. C. Comparison operators D. A more advanced DBMS E. Operators

Match the following terms with their description: I. Navigation Pane II. Object III. Primary key IV. Record V. Relationship A. A component which makes the database function B. A complete collection of all fields about one entity C. A connection between tables using a common field D. That which uniquely identifies records in a table E. An interface that lists the objects in an Access database

If you see plus signs (+) next to records in Datasheet view, then you know that two or more tables are related.