Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Access Excel Final Review 141-160
Test Description: Access excel final review 141-160
Instructions: Answer all questions to get your test result.
1) What ensures that a query result appears in a specific order?
A
Filtering
B
Sorting
2) Which type of operator enables a user to compare two values in a query criterion?
A
Comparison
B
Evaluation
3) Which ribbon displays report printing options?
A
Report Design Tools Page Setup Ribbon
B
Report Design Tools Arrange Ribbon
4) Which ribbon in layout view contains the commands to insert or delete new rows and columns in a report?
A
Report Layout Tools Page Setup
B
Report Layout Tools Arrange
5) Tanya created a report to show people signed up for a 5K race. She needs to increase the size of the report header so she can add the race logo control. Which view will allow her to resize the header?
A
Design View
B
Report View
6) Dean needs to add the FBLA logo to the top of his membership form. Which type of control should he use?
A
Unbound
B
Bound
7) Which type of operation performs mathematical functions, such as MAX, MIN, or COUNT, on a group of records?
A
Aggregate
B
Statistical
8) Wendy wants to be able to see what her database report will look like without producing a hard copy. Which option would she choose?
A
Print Preview
B
Selected Records
9) Keisha wants to print her completed music databases. Which tool would she use?
A
Form
B
Report
10) Mr. Brown's report needs to be arranged by last name and first name. What tool can he use to ensure that students appear in alphabetical order on his report?
A
Conditional Formatting
B
Sort
11) Other than creating a new blank database, which is one of the primary methods for starting a new database?
A
Database template
B
Table template
12) Data that is organized in a useful manner is called?
A
Fields
B
Records
13) Which is the process of arranging data in a designated order based on the value of a specific field?
A
Order
B
Sort
14) Which describes a database consisting of two files; one containing tables with data and the other containing database objects?
A
Two-part database
B
Split database
15) In which view does a newly created table appear in Microsoft Access
A
Datasheet
B
Pivot chart
16) An association established between two or more tables based on a common field that enables the creation of queries, forms, or reports based upon multiple objects is called a:
A
Connection.
B
Relationship.
17) Which of the following field properties should you use to restrict the number that can be entered in a table field?
A
Field size
B
Input Mask
18) Which term refers to the set of rules Microsoft Access uses to ensure that data between related fields are valid?
A
Code enforcement
B
Referential integrity
19) A PivotTable will be empty until the user selects:
A
fields.
B
rows.
20) What are the conditions set forth in a query to identify specific records in a table or tables?
A
Criteria
B
Procedures
*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?