Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Access Excel Final Review 101-120
Test Description: Access excel final review 101-120
Instructions: Answer all questions to get your test result.
1) 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
2) William has created a report. Which view could he use to see exactly how the report will look on paper?
A
Layout View
B
Print Preview
3) Which term refers to storing the same field in more than one location in a database?
A
Redundancy
B
Repetition
4) Curt needs to create a backup to his existing database on an external hard drive. What action should he take?
A
Create New
B
Save As
5) Which view displays the area used to create a table or to modify the structure of a table?
A
Backstage
B
Design
6) An address book containing all FBLA members would be an example of a:
A
databases
B
records
7) Which type of database consists of a collection of tables, each of which contains information on a specific subject?
A
Relational
B
Independent
8) Michelle needs a list of senior National Technical Honor Society members so she can order their tassels for graduation. Which tool would be best to identify only the seniors?
A
Theme
B
Filter
9) Jenny is setting the addresses for each patient. Which data type should she use?
A
Currency
B
Text
10) What is the purpose of a primary key in a database?
A
Unique Identifier
B
Provides a description
11) Amanda wants to ensure there are only two characters for state abbreviation. What should she do?
A
Limit field size
B
Provides database security
12) 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
13) Amanda wants to make it easier for other users to input data. What should she do to help other users understand the fields?
A
Provide a description
B
Unique Identifier
14) Nick wants to design a database and wants Access to automatically assign an ID number to each record. What data type should he
A
Yes/No
B
Auto Number
15) Jenny is entering data to the medication field in the patient database and needs to constantly view patient ID numbers to input medication information. What should she do?
A
Hide Fields
B
Freeze Fields
16) Kori wants to know how many students in FBLA are seniors, but does not want to save the information. Which operation would she perform?
A
Filter
B
Query
17) Mary needs to export the table of FBLA members from the Southeast Region database to a document that does not allow editing. Which format should she use?
A
.txt
B
.pdf
18) In Datasheet view, how does a user delete a record?
A
Select the record and choose Delete from the Create Ribbon
B
Select the record and choose Delete from the Home Ribbon
19) Chad needs to remove a student from the FBLA database. Which option should he choose?
A
Delete Record
B
Edit Record
20) 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
Date/Time
B
Text
*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?