College Computing
template
. A(n) _______ is a file with predefined settings that you can use as a base to create a new database of your own.
255
A Short Text field can hold up to _______ characters.
relational
A(n) _______ database is a group of tables related to one another by common fields.
attachment
A(n) _______ field can include images, Word documents, or almost any other type of data file.
AutoNumber
A(n) _______ field is automatically assigned its value by Access. Database users cannot edit or enter data in this field.
currency
A(n) _______ field stores a numerical value with a high degree of accuracy (up to four decimal places to the right of the decimal). Access will not round these fields.
Yes/No
A(n) _______ field stores a true/false value as a ¿1 or 0.
tables
Access _______ are the essential building blocks of the database.
fields
Access is a relational database¿objects in your database are related to one another through relationships defined by common _______ between tables.
Navigation
All of the database objects are organized in the _______ Pane, which is docked at the left side of the screen.
objects
Although you create and work with a single Access database file, inside the file, there are multiple _______.
field
Each column in a table represents a specific data value called a(n) _______.
record
Each row in a table contains all the data for a single _______.
data
Fields can be inserted at the end of the field list in Design View by typing a new field name, and selecting a ________ type.
layout view
Forms and Reports also offer _______ where you can modify some (but not all) structural elements.
form view
Forms open in _______, which provides a user-friendly interface for entering data.
left
If you right-click any field name and select Insert Field to insert a new blank text field, it is inserted to the _______ of the field you selected.
Print Preview
Reports include _______, which shows how the report will look when printed.
input mask
Some fields require a specific input format called a(n) _______.
errors
Storing each unique piece of data in a single table helps prevent data entry _______.
two
The Design view window is divided into _______ panes.
tables
The database ________ store all the data.
report
The easiest way to create a new report is to use the _______ button.
create the database file
To begin a new Access database from scratch, you must first _______.
Navigation Pane
To create a Single Record form based on a table or query, you must first select the table or query in the _______.
Table Tools Fields
To delete a field in Datasheet view, one method is to click anywhere in the field you want to delete and, on the _______ tab in the Add & Delete group, click the Delete button.
row selector
To delete a field in Design view, select the field you want to delete by right-clicking the ______ to the left of the field name, and select Delete Rows.
double-click
To rename a field in Datasheet view, one method is to _______ the column header and type the new field name.
home
To switch to another view, click the _______ tab and then select your view from the View button arrow.
Print Preview view
Use the _______ to adjust margins and page orientation for your reports.
underlying table design will not be changed
When rearranging fields in Datasheet view, the _______.
move to
When you enter data in a table, Access saves it each time you _______ a new field or begin a new record.
field
You can change a field name by modifying the _______ properties.
sort
You can control the order in which records appear in a table, query, or form by using the _______ feature.
arrow
You can use the _______ key(s) on your keyboard to navigate through fields in a record or between records.
forms
_______ allow users to input data through a friendly interface.
primary key
The _______ is the field that contains data unique to that record.
65,535
A Long Text field can hold up to _______ characters.
table
When you use a form to enter data, you are actually adding data to the underlying _______.
Relationship Tools Design
You can display all the database relationships at once by clicking the All Relationships button on the _______ tab.
database
Microsoft Access is a powerful _______ program that allows you to enter, store, and organize large amounts of data.
Datasheet view
Tables open in _______ where you can enter, sort, and filter data.
content
The Input Mask Wizard offers a variety of common input masks including all the following except:
Field Size
The _______ property is used to limit the number of characters that can be entered in a text field.
three
There are _______ types of relationships that can be established in Access.
Click to add
To add a new field to a table in Datasheet view, click the arrow in the _______ column to expand the list of available field types.
field properties
You can modify specific _______ to control the appearance of data in the field or the way in which users enter data.
Primary key
_______ fields are identified with a key icon next to the field name.
totals
_______ in a report display a calculation such as the sum or average of the values in a field or group.
Design View
_______ is used to modify the structure of the database object.