Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Access 2016 2.02
Test Description: Creating Database Tables
Instructions: Answer all questions to get your test result.
1) Jenny is setting the addresses for each patient. Which data type should she use?
A
text
B
number
C
currency
2) Johnny has planned his baseball card database and determined a logical arrangement. What is his next step?
A
gather the information
B
input data
C
Discuss the database with users
3) Matt needs to add his contacts to the Driver Education database. To do this quickly, what predefined object can he create?
A
application parts
B
quick start
C
database object
4) Curt needs to create a backup to his existing database on an external hard drive. What action should he take?
A
close
B
create new
C
save as
5) 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
application parts
B
template
C
design view
6) 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
memo
B
number
C
text
7) 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
layout view
C
form view
8) 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
9) Nick wants to immediately open an employees' email from his database . What data type should be used for the email address?
A
yes/no
B
currency
C
hyperlink
10) Susie wants to locate the file name of her current document. Where she should look?
A
status bar
B
rename
C
title bar
11) Which view displays the area used to create a table or to modify the structure of a table?
A
file
B
datasheet
C
design
12) Where is the command for creating a new table from Table Design view?
A
home ribbon
B
file tab
C
create ribbon
13) 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
currency
B
hyperlink
C
auto number
14) What are three valid methods for saving a database in Microsoft Access?
A
Alt + S, File tab Save command, Shortcut Save command
B
Alt + S, Home Ribbon Save command, Quick Access Save command
C
Ctrl + S, File tab Save command, Quick Access Save command
15) 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
create new
C
close
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?