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
Report
B
Report Wizard
C
Report Design
D
Blank Report
2) Juan wants to view one record at a time in his database. Which view should he be in?
A
Design View
B
Layout View
C
Form View
D
Navigation Pane
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
Fill Color
B
Format Painter
C
Font 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
or
B
and
C
equal
D
not
5) Michelle wants to change the color of her form to make it more attractive. Which should she use?
A
Controls
B
Form
C
Theme
D
Filter
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 Tool
B
Form Design
C
Blank Form
D
Form Wizard
7) Which ribbon in layout view contains the commands to insert or delete new rows and columns in a report?
A
Report Layout Tools Design
B
Report Layout Tools Page Setup
C
Report Layout Tools Format
D
Report Layout Tools Arrange
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
Form View
B
Navigation Form
C
Layout View
D
Design 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
delete query
B
append query
C
make table query
D
update query
10) Dean needs to add the FBLA logo to the top of his membership form. Which type of control should he use?
A
Bound
B
Unbound
C
Button
D
Calculated
11) Tyler is using Access for a class assignment. Which database object would she use to enter one record at a time?
A
Report
B
Table
C
Macro
D
Form
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
Simple Query
B
Multiple Query
C
Find
D
Crosstab 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
Design tab.
B
Arrange tab.
C
Page Setup tab.
D
Format 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
Table
B
Form
C
Report
D
Query
15) After a query is created, which action must take place to display the results of the query?
A
Retrieve
B
Run
C
Get
D
Go
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 or rings
C
moons not 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
Report View
B
Layout View
C
Form View
D
Design View
18) Which group on the Form Design Tools Arrange Ribbon allows the user to align to grid?
A
Move
B
Sizing Ordering
C
Position
D
Merge/Split
19) Michelle used the property sheet to customize her form in Access. Which task can she complete?
A
Move data.
B
Enter a new record.
C
Switch from Design View to Print Preview.
D
Change the background and add captions.
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?