Access 2.03 - 2.04 (Part 1) Question Preview (ID: 40125)


Access 2.03 2.04. TEACHERS: click here for quick copy question ID numbers.

The athletic director is looking for swim team purchase orders that are more than $200. What criteria would give her this information?
a) =200 AND swimming
b) 200 OR swimming
c) =200 OR swimming
d) 200 AND swimming

Jenny is entering data to the medication field in the patient database and needs to constantly view patient ID numbers to input medication information. What should she do?
a) Format
b) Freeze Fields
c) Hide Fields
d) Sort

Keisha created a database of her music. She wants to locate only the songs by Beyoncé. What tool should she use in order to view this information without saving?
a) Filters
b) Form
c) Query
d) Report

Dennis needs to format his sales amount column to show dollar signs. Which format would he use?
a) Currency
b) Fixed
c) General Number
d) Text

Eddie needs to search for the specific employee that lives on 225 Mayberry Lane. What command would he use?
a) Filter
b) Find
c) Sort Ascending
d) Sort Descending

Chad needs to change a members telephone number in the FBLA database. What step should he take?
a) Add New Record
b) Delete Record
c) Move Field
d) Edit Record

Which type of field enables a user to select from a list of values when updating the contents of a field?
a) Calculated
b) Attachment
c) Lookup
d) Hyperlink

Amanda wants to make it easier for other users to input data. What should she do to help other users understand the fields?
a) Unique Identifier
b) Limit field size
c) Provide a caption
d) Provide database security

Chad needs to remove a student from the FBLA database. Which option should he choose?
a) Add New Record
b) Delete Record
c) Move Field
d) Edit Record

Which type of relationship means that a record in the first table is related or matches more than one record in the second table?
a) One to one
b) Many to many
c) One to many
d) One to any

In a table, which is a way of exclusively identifying each record in the database?
a) Unique marker
b) Primary Key
c) Primary marker
d) Primary category

Eddie works for ABC Finance. He needs to view which employee(s) has the lowest sales for the month. Which command should he use?
a) Filter
b) Find
c) Sort Ascending
d) Sort Descending

Linda wants to ensure birthdates are entered as MM/DD/YYYY. Which field property will be used?
a) Look up
b) Format
c) Default Value
d) Field Size

Kori wants to know how many students in FBLA are seniors, but does not want to save the information. Which operation would she perform?
a) Filter
b) Find
c) Query
d) Sort

What are the rules that a user should follow when entering data into a table?
a) Text
b) Validation
c) Criterion
d) Properties

In Datasheet view, how does a user delete a record?
a) Double-click the record
b) Select the record and choose Delete from the Create Ribbon
c) Double-click the record and choose Delete from the Database Tools Ribbon
d) Select the record and choose Delete from the Home Ribbon

Nick needs to specify two characters for the student ID field. What area of design view would he access to specify this?
a) Data Type
b) Description
c) Field Name
d) Properties

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: 40125 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register