Access 2.01 - 2.02 (Part 1) Question Preview (ID: 41962)


Part 1. TEACHERS: click here for quick copy question ID numbers.

When saving a Microsoft Access database as another file type, which ribbon contains an area of centralized tasks that are related to file management known as the backstage?
a) Database Tools ribbon
b) Home ribbon
c) External Data ribbon
d) File tab

You have been asked to develop an address book for the FBLA members. Last name and first name would be examples of:
a) records
b) databases
c) cells
d) fields

Which area appears on the left side of Microsoft Access windows and displays a list of objects available in the database?
a) Text
b) Number
c) Date/Time
d) Memo

Isabel wants to design a database for her FBLA club to include all the members' information. What data type should she use for Last Name?
a) Objects Pane
b) Navigation Pane
c) List Pane
d) Database Pane

Where is the command for creating a new table from Table Design view?
a) Create Ribbon
b) Database Tools Ribbon
c) File tab
d) Home Ribbon

Nick wants to design a database and wants Access to automatically assign an ID number to each record. What is auto numbering an example of?
a) Data Type
b) Description
c) Field Name
d) Properties

Matt needs to add his contacts to the Driver Education database. To do this quickly, what predefined object can he create?
a) Quick Start
b) Application Parts
c) Database Object
d) Sharepoint List

What are three valid methods for saving a database in Microsoft Access?
a) Ctrl + S, File tab Save command, Quick Access Save command
b) Alt + S, Home Ribbon Save command, Quick Access Save command
c) Alt + S, File tab Save command, Shortcut Save command
d) Alt + S, File tab Save command, Quick Access Toolbar Save command

When a database is created, what is defined when names and data types are assigned to all data fields in a table?
a) Definition
b) Theme
c) Structure
d) Design

Which term refers to storing the same field in more than one location in a database?
a) Recurrence
b) Redundancy
c) Replication
d) Repetition

Which type of database consists of a collection of tables, each of which contains information on a specific subject?
a) Collaborative
b) Relational
c) Interactive
d) Independent

Curt needs to exit his database in order to work on another database. What action should he take after saving his work?
a) Open from Existing
b) Save As
c) Create New
d) Close

Which view displays the area used to create a table or to modify the structure of a table?
a) Datasheet
b) File
c) Design
d) Backstage

Johnny has planned his baseball card database and determined a logical arrangement. What is his next step?
a) Gather the information
b) Determine what information to include
c) Input data
d) Discuss the database with users

Curt needs to create a backup to his existing database on an external hard drive. What action should he take?
a) Close
b) Save As
c) Open from Existing
d) Create New

Individual entries in the FBLA address book would be entered into a:
a) records
b) fields
c) cells
d) databases

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 41962 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links