Name: 

Database Design Language (DBDL) is a programming language.

In Access, table names can be up to 128 characters in length.

In a one-to-many relationship, each row in the first table may be associated with many rows in the second table.

File names can be a maximum of 260 characters including the file extension.

A folder is a specific location on a storage medium.

In Datasheet view, a table is represented as a collection of rows and columns called a datasheet.

Grouping means creating separate collections of records sharing some common characteristic.

Form view displays a single record at a time.

A DataForm combines both a datasheet and a form.

In Access, the columns in a table are called records.

A unique identifier also is called a primary key.

Replication is the storing of a piece of data in more than one place.

The maximum number of characters allowed in a field whose data type is Text is 1024.

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Text.

The Monetary data type is used for fields that contain only monetary data.

The URL Address data type can store text that can be used as a hyperlink address.

To delete the ID field that Access creates automatically for a new table, the table must appear in Layout view rather than Datasheet view.

One way to undo changes to a field is to click the Undo button on the Table Tools tab.

Access is a ____.

In Access, a(n) ____ consists of a collection of tables, each of which contains information on a specific subject.

A(n) ____ contains information about a given person, product, or event.

____ words are words that have a special meaning to Access and cannot be used for the names of fields or tables.

In Access, table and field names can be up to ____ characters in length.

To change the save location for a database, click ____ in the Favorite Links section.

When you create a new database, the name of the database appears on the ____ bar.

One way to create a table, is to click ____ on the Ribbon and then click the Table button.

You only can delete a primary key in ____ view.

To delete a field in a table, right-click the column heading for the field, and then click ____ on the shortcut menu.

To change the name of a field, right-click the column heading for the field, click ____ on the shortcut menu, and then type the desired field name.

To insert a field between existing fields, right-click the column heading for the field that will follow the new field, and then click ____ on the shortcut menu.

You can place an insertion point by clicking in the field or by pressing ____.

To quit Access, click the ____ button on the right side of the Access title bar.

To hide the Navigation Pane, click the ____ Button.

To preview and then print a table, select the table, click the Office Button, point to the Print command arrow to display the Print submenu, and then click ____ on the Print submenu.

To change the print orientation from portrait to landscape, click the ____ button on the Print Preview tab.

If the Field Size for a field whose data type is Number is set to ____, the field size will be an integer value in the range of 0 to 255.

A(n) ___ combines both a datasheet and a form.

To back up a database, use the ____ command on the Office Button menu.

____________________ means storing the same fact in more than one place.

In the accompanying figure, the ____________________ Pane contains a list of all the objects in the database.

In the accompanying figure, the words Form View at the lower left of the screen appear on the ____________________.

In the accompanying figure, the buttons at the bottom-right edge of the screen are ____________________ buttons, which you use to change the view that is currently displayed.

____________________ is a feature that allows you to point to a gallery choice and see its effect in the database object — without actually selecting the choice.

Initially, the Quick Access Toolbar contains the ____________________, Undo, and Redo commands.

A(n)____________________ is a software tool that can be used to create a database; add, change, and delete data in the database; sort and retrieve data; and create forms and reports using the data in the database.

The rows in the tables are called ____________________.

A(n) ____________________ contains a specific piece of information within a record.

Table names can be from 1 to ____________________ characters in length and can contain letters, digits, and spaces.

When you create a database, you should follow some general guidelines for database design. What are these seven guidelines?

Critical Thinking Questions

Case 1

Mary has been asked to create a database for her company. The database is to track employees and the departments for which the employees work. A department can have between 5 and 15 employees. She has determined that she needs the following tables:

Employee (Social Security Number, Employee Name, Street Address, City, State, Postal                   Code, Date Hired, Salary, Department Code)
Department (Department Code, Department Name)

Which field in the Employee table should be the primary key and why?