Microsoft® Office 2013 Illustrated Introductory, First Course, Beskeen - Exam Preparation Test Bank (Downloadable Doc)

Access 2013 Unit A: Getting Started with Access 2013




TRUE/FALSE



1. More than one person can be entering, updating, and using an Access database at the same time.


ANS: T PTS: 1 REF: Access 2

OBJ: Explain when to use a database



2. An Access database is limited to a size of 1 gigabyte.


ANS: F PTS: 1 REF: Access 3

OBJ: Describe relational database concepts



3. Tables contain all of the data in the database.


ANS: T PTS: 1 REF: Access 5

OBJ: Open and define Access objects



4. If a number has already been incremented beyond 1 for a first record in a field of the
AutoNumber data type, the AutoNumber data type can no longer work as intended.


ANS: F PTS: 1 REF: Access 8

OBJ: Set appropriate data types for fields



5. A primary key field uniquely identifies each record.


ANS: T PTS: 1 REF: Access 10 OBJ: Set the primary key
field

, 6. No two records can have the same value in the primary key field.


ANS: T PTS: 1 REF: Access 10 OBJ: Set the primary key
field



7. Field properties change depending on the data type of the field.


ANS: T PTS: 1 REF: Access 11 OBJ: Set the primary key
field



8. The linking field on the “many” side of a one-to-many relationship is called the foreign key field.


ANS: T PTS: 1 REF: Access 12

OBJ: Create one-to-many relationships



9. A subdatasheet shows the records on the “many” side of a one-to-many relationship.


ANS: T PTS: 1 REF: Access 12

OBJ: Define common field and foreign key field



10. “Focus” refers to which data you would edit if you started typing.


ANS: T PTS: 1 REF: Access 14 OBJ: Enter records in a
datasheet



11. The navigation buttons on a datasheet display the total number of fields in the datasheet.


ANS: F PTS: 1 REF: Access 14

OBJ: Navigate records in a datasheet

, 12. Values in an AutoNumber field are automatically created by Access.


ANS: T PTS: 1 REF: Access 14 OBJ: Enter records in a
datasheet



13. The [F2] key switches between Edit and Navigation modes.


ANS: T PTS: 1 REF: Access 17 OBJ: Edit data in a datasheet



14. Press [Esc] once to undo a change to the current field.


ANS: T PTS: 1 REF: Access 17 OBJ: Edit data in a datasheet



15. Pressing [Ctrl][;] will insert the current date in a Date field.


ANS: T PTS: 1 REF: Access 17 OBJ: Edit data in a datasheet




MULTIPLE CHOICE



1. Microsoft Access can best be described as ____ software.

a. spreadsheet c. database

b. presentation d. systems


ANS: C PTS: 1 REF: Access 2

OBJ: Describe relational database concepts



2. Which is NOT true about Access?

, a. It can be used to create forms

b. It relates lists of information in a relational database.

c. Reporting is limited to 20 saved reports.

d. Multiple users can simultaneously enter and update data within Access.


ANS: C PTS: 1 REF: Access 3

OBJ: Describe relational database concepts



3. Tables, queries, and forms are examples of Access ____.

a. entities c. values

b. objects d. controls


ANS: B PTS: 1 REF: Access 4

OBJ: Open and define Access objects



4. Which of the following is NOT available to you as you start Access?

a. opening an existing database c. creating a new database from a template

b. recalibrating an existing database d. creating a new blank database


ANS: B PTS: 1 REF: Access 4

OBJ: Start Access and open a database



5. Which Access object provides an easy-to-use data entry screen?

a. macro c. table

b. form d. module


ANS: B PTS: 1 REF: Access 5 OBJ: Identify Access
components