Compact & Repair |
To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view. |
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 |
True |
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/F |
False |
The AutoError Correction feature of Access corrects common data entry errors. T/F |
True |
Form view displays a single record at a time. T/F |
Rename Field |
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. |
Click to Add |
To define an additional field in Datasheet view, tap or click the ____ column heading. |
Delete |
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. |
True |
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/F |
False |
As shown in the accompanying figure, you can move to the first record in a table by clicking the Start record Navigation button. T/F |
True |
When Access first creates a database, it automatically creates a table. T/F |
Landscape |
To change the print orientation from portrait to landscape, tap or click the ____ button on the PRINT PREVIEW tab. |
Create |
To create a query using the Query Wizard, tap or click ____ on the ribbon and then click the Query Wizard button |
Options |
To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays. |
External Data |
To import data to a table, tap or click the ____ tab on the ribbon. |
True |
A unique identifier also is called a primary key. T/F |
Record |
A(n) ____ contains information about a given person, product, or event. |
True |
The Navigation Pane contains a list of all the objects in the database. T/F |
False |
To preview and then print the contents of a table, use Table Preview. T/F |
False |
Changing the column width in a datasheet changes the structure of a table. T/F |
True |
Layout view shows a report on the screen and allows the user to make changes to the report. T/F |
False |
To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation. T/F |
True |
The Currency data type is used for fields that contain only monetary data. |
Row Selector |
In the accompanying figure, the small box or bar to the left of each field is called the ____. |
True |
The maximum number of characters allowed in a field whose data type is Short Text is 255 characters. |
Access |
What is a database management system. |
False |
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 Insert Column on the shortcut menu. T/F |
F2 |
You can place an insertion point by tapping or clicking in the field or by pressing ____. |
64 |
In Access, table and field names can be up to ____ characters in length. |
Long Text |
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. |
Caption |
When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms. |
Quick Access Toolbar |
To save the changes to the layout of a table, tap or click the Save button on the ____. |
ID |
When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table. |
False |
In Access, field names cannot contain digits. |
Shutter Bar Open/Close |
To open the Navigation Pane, tap or click the ____ Button. |
Undo |
To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar. |
Attachment |
A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet. |
Close |
To exit Access, tap or click the ____ button on the right side of the title bar. |
Design View |
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. |
AutoNumber |
A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added. |
Rename |
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. |
Insert Field |
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. |
New (blank) |
To add a record to a table, tap or click the ____ record button. |
False |
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. |
True |
As shown in the accompanying figure, you can use the Last record button to move to the last record in the table. T/F |
True |
Redundancy means storing the same fact in more than one place. |
False |
In Access, the columns in a table are called records. T/F |
False |
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. T/F |
Delete |
To delete a record, tap or click the record selector for the record, and then press the ____ key(s). |
Open |
To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu. |
Report |
To create an initial report that can be modified in Layout view, tap or click ____ on the CREATE tab. |
False |
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 Insert Column on the shortcut menu. |
Delete Field |
To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click ____ on the shortcut menu. |
False |
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. |
Back Up Database |
To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view. |
False |
The DATABASE TOOLS tab provides commands to save a database with another name. |
Primary Key |
In the accompanying figure, the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table. |
False |
A field that has the Calculated data type can store a unique sequential number that Access assigns to a record. |
Short Text |
A field whose data type is ____ can contain any characters. |
Relational |
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. |
OLE Object |
A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table. |
Attachment |
A field whose data type is ____ can store text that can be used as a hyperlink address. |
True |
Standard properties are associated with all Microsoft Office documents and include author, title, and subject. |
False |
In Datasheet view, a table is represented as a collection of rows and columns called a list. |
Access Chapter 1
Share This
Unfinished tasks keep piling up?
Let us complete them for you. Quickly and professionally.
Check Price