Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Access Excel Final Review 121-140
Test Description: Access excel final review 121-140
Instructions: Answer all questions to get your test result.
1) 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
Sharepoint List
2) Isabel needs to include a brief biography of each member in her database. The average length of each biography is 300 characters. What data type should she use to include these characters?
A
Memo
B
Date/Time
3) Eddie needs to know which employee(s) work in the Southeast District. Which command would he use?
A
Sort Ascending
B
Filter
4) Eddie works for ABC Finance. He needs to view which employee(s) has the highest sales for the month. Which command should he use?
A
Sort Descending
B
Filter
5) In a table, which is a way of exclusively identifying each record in the database?
A
Primary category
B
Primary Key
6) Mr. Smith needs to know Jenny's address. Which command would he use?
A
Find
B
Sort Ascending
7) Sally is the Honor Society president. She is creating a database to manage her membership information. What form tool could she use to quickly create a set of tabs a user could click to access forms and reports in the database?
A
Layout View
B
Navigation Form
8) You are the owner of Ima Graphic Animator, Inc., a graphic design company. You want to quickly create a new blank database object, one which includes one record at a time and a more detailed view of the structure. Which would you use?
A
Form Design
B
Table Design
9) Tyler is using Access for a class assignment. Which database object would she use to enter one record at a time?
A
Form
B
Table
10) Cathy needs to duplicate a column that is used in her spring sports table in the athletic database for a new form she is creating for fall sports. Which item from the tools group would enable her to perform this operation?
A
Add Existing Fields
B
Property Sheet
11) Michelle needs each National Technical Honor Society member to complete an information sheet. Which tool would be best?
A
Form
B
Controls
12) Helen is creating a form to gather important information about graduation requirements from her senior homeroom students. What tool would she use to ensure that the sequence in navigating the form fields solicits the correct data?
A
Tab Order
B
Property Sheet
13) Michelle wants to change the color of her form to make it more attractive. Which should she use?
A
Theme
B
Filter
14) Sam enters a numeric criterion in a query to find out which UNC school(s) have an enrollment that equals 5,000 or greater. What would he enter?
A
=5000
B
=5000
15) Sam needs to search information from the UNC schools database to find which school(s) have at least 10,000 students enrolled and an animal for a mascot. Which command would he use?
A
Simple Query
B
Multiple Query
16) What do you use to locate records that meet certain criteria?
A
Reports
B
Queries
17) The manager of Doggie Donuts needs to group inventory by types of dog food in stock. He needs a subtotal for each group. Which query type will display this information?
A
crosstab query
B
select query
18) The athletic director is looking for swim or softball team purchase orders that are more than $200. What criteria would give her this information?
A
200 AND swimming OR softball
B
200 AND swimming AND softball
19) Donna's Bakery lost a customer named Doggie Donuts. What action should be taken to remove all records from her database for Doggie Donuts?
A
make table query
B
delete query
20) Susi works at the local hospital and she needs to know the first names of the patients with the last name Jones. What wildcard operator would she use?
A
+
B
*
*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?