BCIS FINAL EXAM UPDATED
QUESTIONS AND CORRECT ANSWERS
Access is a - CORRECT ANSWER -database management system.
A _____ contains information about a given person, product, or event. - CORRECT ANSWER -
record
Database _____ refers to the arrangement of data into tables and fields - CORRECT ANSWER -
design
_____ words are words that have a special meaning to Access and cannot be used for the names of fields.
- CORRECT ANSWER -reserved
In Access, table and field names can be up to ____ characters in length. - CORRECT ANSWER -64
A field whose data type is ____ characters in length. - CORRECT ANSWER -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. - CORRECT ANSWER -Memo
A field with the ____ data type can store a unique sequential number that Access assigns to a recored.
Access will increment the number by 1 as each new record is added. - CORRECT ANSWER -
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. - CORRECT ANSWER -
Attachment
A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the
table. - CORRECT ANSWER -OLE Object
,In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a -
CORRECT ANSWER -database
One way to create a table, is to click ___ on the Ribbon and then click the Table button. - CORRECT
ANSWER -Create
When you create a table in Datasheet view, Access automatically adds a field called ___ as the first field
in the table. - CORRECT ANSWER -ID
To define an additional field in Datasheet view, click the ___ column heading. - CORRECT
ANSWER -Click to Add
To undo the most recent change to a table structure, click the ___ button on the Quick Access Toolbar. -
CORRECT ANSWER -Undo
To delete a field in a table, right-click the column heading for the field, and then click ___ on the shortcut
menu, and then type the desired field name. - CORRECT ANSWER -Delete Field
To change the name of a field, right-click the column heading for the field, click ___ on the shortcut
menu, and then type the desired field name. - CORRECT ANSWER -Rename Field
To show the symbol for the Euro instead of the dollra sign, change the ___ property for the field whose
data type is Currency. - CORRECT ANSWER -Format
To insert a field between existing fields, right-click the column heading for the field that will follow the
field, and then click ___ on the shortcut menu. - CORRECT ANSWER -Insert Field
To open a table in Design view, right-click the table in the Navigation Pane and then click ___ on the
shortcut menu. - CORRECT ANSWER -Design View
To add a record to a table, click the ___ record button. - CORRECT ANSWER -New (blank)
, You can place an insertion point by clicking in the field or by pressing - CORRECT ANSWER -F2
To delete a record, click the record selector for the record, and then press the ___ key(s). - CORRECT
ANSWER -DELETE
To change the print orientation from portrait to landscape, click the ___ button on the Print Preview tab. -
CORRECT ANSWER -Landscape
To specify AutoCorrect rules and exceptions to the rules, click File to open the Backstage view, click ___,
and then click Proofing in the dialog box that displays. - CORRECT ANSWER -Options
To import data to a table, click the ___ tab on the Ribbon. - CORRECT ANSWER -External Data
To save the changes to the layout of a table, click the Save button on the - CORRECT ANSWER -
Quick Access Toolbar
To open the Navigation Pane, click the ___ Button. - CORRECT ANSWER -Shutter Bar
Open/Close
To create a query using the Query Wizard, click ___ on the Ribbon and then click the Query Wizard
button. - CORRECT ANSWER -Create
To view the results of a saved query, right-click the query in the Navigation Pane and click ___ on the
shortcut menu. - CORRECT ANSWER -Open
To change the design of a query, right-click the query in the Navigation Pane and then click ___ on the
shortcut menu. - CORRECT ANSWER -Design View
To create an initial report that can be modified in Layout view, click ___ on the Create tab. - CORRECT
ANSWER -Report
To quit Access, click the ___ button on the right side of the title bar. - CORRECT ANSWER -Close
QUESTIONS AND CORRECT ANSWERS
Access is a - CORRECT ANSWER -database management system.
A _____ contains information about a given person, product, or event. - CORRECT ANSWER -
record
Database _____ refers to the arrangement of data into tables and fields - CORRECT ANSWER -
design
_____ words are words that have a special meaning to Access and cannot be used for the names of fields.
- CORRECT ANSWER -reserved
In Access, table and field names can be up to ____ characters in length. - CORRECT ANSWER -64
A field whose data type is ____ characters in length. - CORRECT ANSWER -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. - CORRECT ANSWER -Memo
A field with the ____ data type can store a unique sequential number that Access assigns to a recored.
Access will increment the number by 1 as each new record is added. - CORRECT ANSWER -
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. - CORRECT ANSWER -
Attachment
A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the
table. - CORRECT ANSWER -OLE Object
,In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a -
CORRECT ANSWER -database
One way to create a table, is to click ___ on the Ribbon and then click the Table button. - CORRECT
ANSWER -Create
When you create a table in Datasheet view, Access automatically adds a field called ___ as the first field
in the table. - CORRECT ANSWER -ID
To define an additional field in Datasheet view, click the ___ column heading. - CORRECT
ANSWER -Click to Add
To undo the most recent change to a table structure, click the ___ button on the Quick Access Toolbar. -
CORRECT ANSWER -Undo
To delete a field in a table, right-click the column heading for the field, and then click ___ on the shortcut
menu, and then type the desired field name. - CORRECT ANSWER -Delete Field
To change the name of a field, right-click the column heading for the field, click ___ on the shortcut
menu, and then type the desired field name. - CORRECT ANSWER -Rename Field
To show the symbol for the Euro instead of the dollra sign, change the ___ property for the field whose
data type is Currency. - CORRECT ANSWER -Format
To insert a field between existing fields, right-click the column heading for the field that will follow the
field, and then click ___ on the shortcut menu. - CORRECT ANSWER -Insert Field
To open a table in Design view, right-click the table in the Navigation Pane and then click ___ on the
shortcut menu. - CORRECT ANSWER -Design View
To add a record to a table, click the ___ record button. - CORRECT ANSWER -New (blank)
, You can place an insertion point by clicking in the field or by pressing - CORRECT ANSWER -F2
To delete a record, click the record selector for the record, and then press the ___ key(s). - CORRECT
ANSWER -DELETE
To change the print orientation from portrait to landscape, click the ___ button on the Print Preview tab. -
CORRECT ANSWER -Landscape
To specify AutoCorrect rules and exceptions to the rules, click File to open the Backstage view, click ___,
and then click Proofing in the dialog box that displays. - CORRECT ANSWER -Options
To import data to a table, click the ___ tab on the Ribbon. - CORRECT ANSWER -External Data
To save the changes to the layout of a table, click the Save button on the - CORRECT ANSWER -
Quick Access Toolbar
To open the Navigation Pane, click the ___ Button. - CORRECT ANSWER -Shutter Bar
Open/Close
To create a query using the Query Wizard, click ___ on the Ribbon and then click the Query Wizard
button. - CORRECT ANSWER -Create
To view the results of a saved query, right-click the query in the Navigation Pane and click ___ on the
shortcut menu. - CORRECT ANSWER -Open
To change the design of a query, right-click the query in the Navigation Pane and then click ___ on the
shortcut menu. - CORRECT ANSWER -Design View
To create an initial report that can be modified in Layout view, click ___ on the Create tab. - CORRECT
ANSWER -Report
To quit Access, click the ___ button on the right side of the title bar. - CORRECT ANSWER -Close
