Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Access 2.05-2.08 (Part 1)
Test Description: Part 1
Instructions: Answer all questions to get your test result.
1) Barney would like to create a report in layout view so that he can easily modify contents and formatting. Which option uses layout view and gives the user greater control over the report's appearance while displaying the data?
A
Blank Report
B
Report Design
C
Report Wizard
D
Report
2) Juan wants to view one record at a time in his database. Which view should he be in?
A
Layout View
B
Navigation Pane
C
Design View
D
Form View
3) The report Jamie created has a dark background and the page number is not displaying correctly. Which formatting option would he apply to the page number to add contrast between the background and the page number?
A
Format Painter
B
Font Color
C
Fill Color
D
Font Size
4) Marci is searching a Planet Database. She wants to find out how many moons Saturn has and the names. Which comparison operator would she use?
A
and
B
or
C
equal
D
not
5) Michelle wants to change the color of her form to make it more attractive. Which should she use?
A
Form
B
Theme
C
Filter
D
Controls
6) Jeremy needs to create a quick form based on a single table in his baseball card database. Which option will automatically include all the fields from a single table?
A
Form Wizard
B
Form Design
C
Form Tool
D
Blank Form
7) Which ribbon in layout view contains the commands to insert or delete new rows and columns in a report?
A
Report Layout Tools Arrange
B
Report Layout Tools Format
C
Report Layout Tools Design
D
Report Layout Tools Page Setup
8) Ashton needs to add a footer to the data entry form in his gaming database. Which view will allow Ashton to add a footer?
A
Design View
B
Layout View
C
Navigation Form
D
Form View
9) 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
append query
B
update query
C
make table query
D
delete query
10) Dean needs to add the FBLA logo to the top of his membership form. Which type of control should he use?
A
Calculated
B
Bound
C
Button
D
Unbound
11) Tyler is using Access for a class assignment. Which database object would she use to enter one record at a time?
A
Form
B
Report
C
Table
D
Macro
12) Taylor wants to query the airline database to find out how many seats are open on Flight 33. What type of query would she use?
A
Crosstab Query
B
Find
C
Simple Query
D
Multiple Query
13) Riley is using Access to collect data for a science project. He is creating a form and wants to apply predefined color and font scheme formats. Which Form Layout Tools contextual tabs should he select for the theme group?
A
Format Tab.
B
Design tab.
C
Page Setup tab.
D
Arrange tab.
14) Beth needs to determine the seniors with a GPA of 4.0 or higher. Which object would allow her to create a saved search to find this information in the database?
A
Report
B
Form
C
Table
D
Query
15) After a query is created, which action must take place to display the results of the query?
A
Go
B
Get
C
Retrieve
D
Run
16) Marci has a database of all the planets. She needs to know what planets have moons or rings. Which comparison operator would she use to perform the query?
A
moons equal rings
B
moons not rings
C
moons or rings
D
moons and rings
17) You are employed as an assistant at Doggie Daycare. Your boss has asked you to update the new pet patient information. If you opened the form in Design View, which view should you switch to in order to enter patient information?
A
Design View
B
Layout View
C
Form View
D
Report View
18) Which group on the Form Design Tools Arrange Ribbon allows the user to align to grid?
A
Merge/Split
B
Move
C
Position
D
Sizing Ordering
19) Michelle used the property sheet to customize her form in Access. Which task can she complete?
A
Switch from Design View to Print Preview.
B
Enter a new record.
C
Change the background and add captions.
D
Move data.
20) Delores is doing a search of the bed and breakfasts in Southport, NC. She wants to know which bed and breakfast is less than one mile from the waterfront and allows pets. Which comparison operator would she use?
A
=,and
B
=,and
C
,and
D
,and
*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?