Access 2016 2.02 Question Preview (ID: 42270)


Creating Database Tables. TEACHERS: click here for quick copy question ID numbers.

Jenny is setting the addresses for each patient. Which data type should she use?
a) text
b) number
c) currency
d)

Johnny has planned his baseball card database and determined a logical arrangement. What is his next step?
a) input data
b) gather the information
c) Discuss the database with users
d)

Matt needs to add his contacts to the Driver Education database. To do this quickly, what predefined object can he create?
a) database object
b) quick start
c) application parts
d)

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) create new
d)

Erin needs to prepare a custom table for her recipe collection. She has to include the ingredient portions. Which is the correct tool to use?
a) design view
b) template
c) application parts
d)

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) number
b) text
c) memo
d)

Juan is creating a new database. He wants to assign field names. Which view is BEST to create the new database?
a) design view
b) form view
c) layout view
d)

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) field name
b) description
c) data type
d)

Nick wants to immediately open an employees' email from his database . What data type should be used for the email address?
a) hyperlink
b) currency
c) yes/no
d)

Susie wants to locate the file name of her current document. Where she should look?
a) status bar
b) title bar
c) rename
d)

Which view displays the area used to create a table or to modify the structure of a table?
a) datasheet
b) design
c) file
d)

Where is the command for creating a new table from Table Design view?
a) file tab
b) create ribbon
c) home ribbon
d)

Nick wants to design a database and wants Access to automatically assign an ID number to each record. What data type should he use?
a) hyperlink
b) currency
c) auto number
d)

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, File tab Save command, Shortcut Save command
c) Alt + S, Home Ribbon Save command, Quick Access Save command
d)

Curt needs to exit his database in order to work on another database. What action should he take after saving his work?
a) save as
b) close
c) create new
d)

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: 42270 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register