Exam (elaborations) BCIS

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