Access Chapter 1 Study Guide
In Access, table and field names can be up to ____ characters in length.
64
Field names cannot contain ____. a. square brackets ([ ]) b. hyphens (-) c. accent graves (') d. periods (.)
A,C,D
A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.
Attachment
To exit Access, tap or click the ____ button on the right side of the title bar.
CLOSE
To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.
Compact & Repair
To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.
Delete
To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.
Design View
To open a table in Design view, press and hold or right-click the table in the Navigation Pane and then tap or click ____ on the shortcut menu
Design View
In the accompanying figure, the Book Rep table displays in ____.
Design view
A field that has the Calculated data type can store a unique sequential number that Access assigns to a record. ____________________
F
As shown in the accompanying figure, you can move to the end of a table to a position for entering a new record by clicking the Insert record Navigation button.
F
As shown in the accompanying figure, you can move to the first record in a table by clicking the Start record Navigation button.
F
Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.
F
In Access, field names cannot contain digits.
F
In Datasheet view, a table is represented as a collection of rows and columns called a list.
F
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.
F
The DATABASE TOOLS tab provides commands to save a database with another name.
F
The term list database describes a database that consists of a collection of tables, each of which contains information on a specific subject. ____________________
F
To delete a field, press and hold or right-click the column heading for the field, and then tap or click Remove Field on the shortcut menu. ____________________
F
To preview and then print the contents of a table, use Table Preview.
F
You can place an insertion point by tapping or clicking in the field or by pressing ____.
F2
To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.
Format
A field whose data type is ____ can store text that can be used as a hyperlink address.
Hyperlink
When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.
ID
To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu.
Insert Field
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.
LONG TEXT
To add a record to a table, tap or click the ____ record button.
New (blank)
A(n) ____ contains information about a given person, product, or event.
RECORD
To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.
Rename
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.
Rename Field
____ words are words that have a special meaning to Access and cannot be used for the names of fields.
Reserved
A field whose data type is ____ can contain any characters.
Short Text
As shown in the accompanying figure, you can use the Last record button to move to the last record in the table.
T
Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.
T
Form view displays a single record at a time.
T
Landscape orientation means the printout is across the length (height) of the page.
T
Layout view shows a report on the screen and allows the user to make changes to the report.
T
Redundancy means storing the same fact in more than one place.
T
Standard properties are associated with all Microsoft Office documents and include author, title, and subject.
T
The Currency data type is used for fields that contain only monetary data.
T
The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.
T
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. ____________________
T
When Access first creates a database, it automatically creates a table.
T
To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar.
UNDO
A field with a Yes/No data type can store only one of two values. The choices are ____. a. True/False b. One/Zero c. On/Off d. Yes/No
a,c,d
The Access window consists of a variety of components. These include the ____. a. Content pane b. Navigation Pane c. Object tabs d. Quick Access Toolbar
b,c,d
In Datasheet view, a table is represented as a collection of rows and columns called a list.
f
In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.
relational
To create an initial report that can be modified in Layout view, tap or click ____ on the CREATE tab.
report
In the accompanying figure, the small box or bar to the left of each field is called the ____.
row selector
