Access 2.05-2.08 (Part 1) Question Preview (ID: 42315)


Part 1. TEACHERS: click here for quick copy question ID numbers.

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 Design
c) Blank Report
d) Report Wizard

Juan wants to view one record at a time in his database. Which view should he be in?
a) Design View
b) Form View
c) Layout View
d) Navigation Pane

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) Font Size
c) Font Color
d) Format Painter

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) equal
c) not
d) or

Michelle wants to change the color of her form to make it more attractive. Which should she use?
a) Form
b) Filter
c) Controls
d) Theme

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) Blank Form
b) Form Design
c) Form Wizard
d) Form Tool

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 Arrange
c) Report Layout Tools Format
d) Report Layout Tools Page Setup

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) Layout View
c) Design View
d) Navigation Form

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) update query
c) append query
d) make table query

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

Tyler is using Access for a class assignment. Which database object would she use to enter one record at a time?
a) Table
b) Form
c) Macro
d) Report

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) Multiple Query
c) Simple Query
d) Find

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) Format Tab.
c) Arrange tab.
d) Page Setup tab.

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) Form
b) Table
c) Query
d) Report

After a query is created, which action must take place to display the results of the query?
a) Go
b) Run
c) Get
d) Retrieve

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 and rings
b) moons equal rings
c) moons not rings
d) moons or rings

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) Layout View
b) Form View
c) Design View
d) Report View

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

Michelle used the property sheet to customize her form in Access. Which task can she complete?
a) Change the background and add captions.
b) Enter a new record.
c) Move data.
d) Switch from Design View to Print Preview.

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

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 42315 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links