Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Access 2.03 - 2.04 (Part 1)
Test Description: Access 2.03 2.04
Instructions: Answer all questions to get your test result.
1) What are the rules that a user should follow when entering data into a table?
A
Criterion
B
Text
C
Properties
D
Validation
2) In Datasheet view, how does a user delete a record?
A
Double-click the record and choose Delete from the Database Tools Ribbon
B
Double-click the record
C
Select the record and choose Delete from the Home Ribbon
D
Select the record and choose Delete from the Create Ribbon
3) 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
Sort
D
Query
4) Linda wants to ensure birthdates are entered as MM/DD/YYYY. Which field property will be used?
A
Default Value
B
Look up
C
Field Size
D
Format
5) 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 Descending
D
Sort Ascending
6) In a table, which is a way of exclusively identifying each record in the database?
A
Primary category
B
Primary marker
C
Primary Key
D
Unique marker
7) 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 many
B
One to one
C
One to any
D
Many to many
8) Chad needs to remove a student from the FBLA database. Which option should he choose?
A
Delete Record
B
Add New Record
C
Edit Record
D
Move Field
9) Which type of field enables a user to select from a list of values when updating the contents of a field?
A
Lookup
B
Calculated
C
Attachment
D
Hyperlink
10) Amanda wants to make it easier for other users to input data. What should she do to help other users understand the fields?
A
Provide a caption
B
Provide database security
C
Unique Identifier
D
Limit field size
11) Chad needs to change a members telephone number in the FBLA database. What step should he take?
A
Move Field
B
Edit Record
C
Add New Record
D
Delete Record
12) 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 Descending
D
Sort Ascending
13) Dennis needs to format his sales amount column to show dollar signs. Which format would he use?
A
Fixed
B
Text
C
Currency
D
General Number
14) 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
Hide Fields
C
Freeze Fields
D
Sort
15) 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
Form
B
Report
C
Filters
D
Query
16) The athletic director is looking for swim team purchase orders that are more than $200. What criteria would give her this information?
A
200 OR swimming
B
200 AND swimming
C
=200 OR swimming
D
=200 AND swimming
17) Nick needs to specify two characters for the student ID field. What area of design view would he access to specify this?
A
Properties
B
Description
C
Data Type
D
Field Name
*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?