Exam 3: Databases and Database Objects: an Introduction

To change the name of a field, press and hold or right-click the column heading for the field, and then tap or click Rename Field on the shortcut menu.

In the accompanying figure, the small box or bar to the left of each field is called the ____.

A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

In Access, field names cannot contain digits.

To create a query using the Query Wizard, tap or click ____ on the ribbon and then click the Query Wizard button.

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

Designing to omit ____________________ will help to produce good and valid database designs.

In the accompanying figure, book rep names appear more than once in the table. Storing this data on multiple records is an example of redundancy which can cause several problems. What are these problems? What is the solution to the problem?

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

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

To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

To import data to a table, tap or click the ____ tab on the ribbon.

____________________ view has more functionality for creating a table than Datasheet view.

To define an additional field in Datasheet view, tap or click the ____ column heading.

Critical Thinking Questions Case 1-1 Joe has been asked to create a Special Projects database for his company. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. He has determined that he needs the following tables: Employee (Social Security Number, Last Name, First Name, Street Address, City, State, Postal Code, Hourly Pay Rate, Project Code) Project (Project Code, Project Name, Total Hours, Completion Date) Which field in the Employee table should be the primary key and why?

The Navigation Pane contains a list of all the objects in the database.

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

Layout view shows a report on the screen and allows the user to make changes to the report.