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.
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
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
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
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
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
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
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 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 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
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
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
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
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
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.
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
Log In | Sign Up / Register