Exam 10: Creating a Database

Tables, forms, queries, and reports are program components called objects

You can create a database in Access by starting with a ____.

In the accompanying figure, item 2 points to the ____.

A database containing just one table is called a ____ database.

A relational database contains only one table.

To close Access, click Close on the _________________ tab.

In the accompanying figure, item 1 is the name of the only ____ in the database.

Every new table in Access includes a blank ID field which is automatically designated as the primary key field

Each row in a database table is called a(n) record

The data you enter in each field is called a field ____.

In  _____________________ view, you can view records but cannot add, delete or edit records.

In Datasheet view, the left pane below the Ribbon is called the ____ pane. It is where all database objects for the open database are listed.

It is easier to add fields to new or existing tables in Datasheet view.

_____ controls are devices for inputting data such as text boxes, list arrows, or check boxes.

The simplest way to create a form is to click the Form button on the _______________ tab.

In the accompanying figure, the words Short Text refer to a ____.

A form is a summary of database information specifically designed for printing.

A(n) ____ is a user-friendly window that contains text boxes and labels that let users easily input data, usually one record at a time.

You work for a small pet shop and the store manager asks you to convert some of his paper records to an online system. A simple database exists and the owner wants to add to the existing database. Assuming you can extend the database with every possible need for the store, what objects must be included in addition to the table(s) that make up the database?

When you click a field name to add a new record, the field ____ appears in the status bar.