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