NEW
Font size
S
M
L
XL
WorksheetsAccess 2.03-2.04 Review
Total questions: 26
Worksheet time: 26mins
Name
Class
Date
1.
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
2.
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
3.
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
4.
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
5.
Dennis needs to format the numbers in his database to three decimal places. Which number format would he use?
a)
Currency
b)
Fixed
c)
General Number
d)
Text
6.
Nick wants to make notes for future users of his database so they will properly use the field names and types. Where would he make these notes?
a)
Data type
b)
Description
c)
Field Name
d)
Properties
7.
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
8.
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
9.
Keisha created a database of her music. She wants to locate only songs by Beyonce. What tool should she use in order to view this information without saving?
a)
Filters
b)
Form
c)
Query
d)
Report
10.
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
11.
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
12.
Chad needs to change a members telephone # in the FBLA database? What step should he take?
a)
Add new record
b)
Delete record
c)
Move field
d)
Edit record
13.
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
14.
Eddie needs to know which employee(s) work in the Southeast District. Which command would he use?
a)
Filter
b)
Find
c)
Sort Ascending
d)
Sort Descending
15.
In Datasheet view, hos 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
16.
Mr. Smith needs to know Jenny's address. Which command would he use?
a)
Find
b)
Select
c)
Sort Ascending
d)
Sort Descending
17.
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
18.
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 Field
19.
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
20.
Michelle needs a list of senior National Technical Honor Society members so she can order their tassels for graduation. Which tool would be best to identify only the seniors?
a)
Form
b)
Filter
c)
Controls
d)
Theme
21.
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
22.
Eddie works for ABC finance. He needs to view which employee(s) has the highest sales for the month. Which command should use?
a)
Filter
b)
Find
c)
Sort Ascending
d)
Sort Descending
23.
What are the rules that a user should follow when entering data into a table?
a)
Text
b)
Validation
c)
Criterion
d)
Properties
24.
Amanda wants to ensure there are only two characters for state abbreviation. What should she do?
a)
Unique Identifier
b)
Limit Field Size
c)
Provide a description
d)
provides database security
25.
Dillano wants to ensure social security are entered in a proper format. Which field property will be used?
a)
Input mask
b)
Format
c)
Default Value
d)
Field Size
26.
Curt needs to format the numbers in his database to two decimal places. Which number format would he use?
a)
Currency
b)
Fixed
c)
General Number
d)
Text
Reset
