In Access, the columns in a table are called records |
False |
A unique identifier is also called a primary key |
True |
In Access, field names cannot contain digits |
False |
The Navigation Pane contains a list of all the objects in the database |
True |
In Datasheet view, a table is represented as a collection of rows and columns called a list |
False |
The maximum number of characters allowed in a field whose data type is Short Text is 225 characters |
True |
Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of memo |
False |
The Currency data type is used for fields that contain only monetary data |
True |
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 225 |
False |
When Access first creates a database, it automatically creates a table |
True |
One way to undo changes to a field is to click the Undo button on the status bar |
False |
Changing the column width in a datasheet changes the structure of a table |
False |
Landscape orientation means the printout is across the length (height) of the page |
True |
To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation |
False |
To preview and then print the contents of a table, use Table Preview |
False |
Form view displays a single record at a time |
True |
Layout view shows a report on the screen and allows the user to make changes to the report |
True |
Standard properties are associated with all Microsoft Office documents and include author, title, and subject |
True |
Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationships |
True |
Redundancy means storing the same fact in more than one place |
True |
Access is a |
Database management system |
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 |
A(n) ___________ contains information about a given person, product, or event |
Record |
_______ words are words that have a special meaning to Access and cannot be used for the names of fields |
Reserved |
In Access, table and field names can be up to __________ characters in lenght |
128 |
A field whose data type is ________ can contain any characters |
Short text |
A(n) _______ data type can store a variable amount of text or combination of text and numbers where the total number characters may exceed 225 |
Long text |
A field with the ______ data type can store a unique sequential number that Access assigns to a record. Access with increment the number by 1 as each new r cord is added |
AutoNumber |
A field with the _______ data type can contain an attached file, such as an image, document, chart, or spreadsheet |
Attachment |
A field whose date type is _______ can store an OLE object, which is an object linked to or embedded in the table |
OLE object |
A field whose date type is _______can store text thAt can be used as a hyperlink address |
Hyperlink |
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 |
Caption |
To define an additional field in Datasheet view, tap or click the _________ column heading |
Click to Add |
To undo the most recent change to a table structure, tap or click the ________ button on the Quick Access Toolbar |
Undo |
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 |
Delete Field |
To change the name of afield, 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 |
To show the symbol for the Euro instead of the dollar sign, change the ________ property for the field whose data type is Currency |
Format |
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 the tap or click ______ on the shortcut menu |
Insert field |
To add a record to a table, tap or click the ______ record button |
New (blank) |
You can place an insertion point by tapping or clicking in the field or by pressing |
F2 |
To delete a record, tap or click the record sector for the record, and then press the ______ key |
Delete |
To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click the _______, and then tap or click Proofing in the dialog box that displays |
Options |
To save the changes to the layout of a table, tap or click the Save button on the |
Quick Access Toolbar |
To import data to a table, tap or click the ________ tab on the ribbon |
EXTERNAL DATA |
To open the Navigation Pane, tap or click the ______ Button |
Shutter Bar Open/Close |
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 |
Open |
To change the design of a query, press and hold or right-click the query in the Navigation Pane and the tap or click _______ on the shortcut menu |
Design View |
To back up the database that is currently open, use the _______ command on the Save As tab in the Backstage view |
Back Up Databsw |
To compact and repair a databse, tap or click the ________ button in the Info gallery in the Backstage view |
Compact and 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 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 |
A(n) _______ is software that can be used to create a database; add, change, and delete data in the database; task and answer questions concerning the data in the database; and create forms and reports using the data |
Database management system |
The rows in the tables are called |
Records |
Contains a specific piece of information switching a record |
Field |
Data type in Access is referred to as Money in SQL Server |
Currency |
View has more functionality for creating a table than Datasheet view |
Design |
To define an additional field in Datasheet view, tap or click the _______ column heading, select the data type, and then type the field name |
Click to add |
To insert a field between existing fields, press and he or she the column heading for the field that will follow the new did, and then tap or click ______ on the shortcut menu |
Insert field |
Society encourage users to contribute to ____ computing, which involves reducing the electricity consumed and environmental waste generate when using computers, mobile devices, and related technologies |
Green |
A hard copy or __________ is information that exists on a physical medium such as paper |
Printout |
Refers to the process of determining the tables and fields that make up the database |
Database design |
The determination of database requirements is part of a process is known as |
Systems analysis |
Designing to omit _______ will help to produce good and valid databse designs |
Rebundancy |