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
Properties
C
Validation
D
Text
2) In Datasheet view, how does a user delete a record?
A
Select the record and choose Delete from the Create Ribbon
B
Select the record and choose Delete from the Home Ribbon
C
Double-click the record and choose Delete from the Database Tools Ribbon
D
Double-click the record
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
Query
B
Filter
C
Sort
D
Find
4) Linda wants to ensure birthdates are entered as MM/DD/YYYY. Which field property will be used?
A
Look up
B
Field Size
C
Default Value
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
Sort Ascending
B
Sort Descending
C
Find
D
Filter
6) In a table, which is a way of exclusively identifying each record in the database?
A
Primary Key
B
Primary marker
C
Primary category
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
Many to many
D
One to any
8) Chad needs to remove a student from the FBLA database. Which option should he choose?
A
Delete Record
B
Add New Record
C
Move Field
D
Edit Record
9) Which type of field enables a user to select from a list of values when updating the contents of a field?
A
Hyperlink
B
Calculated
C
Lookup
D
Attachment
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
Unique Identifier
B
Provide database security
C
Provide a caption
D
Limit field size
11) Chad needs to change a members telephone number in the FBLA database. What step should he take?
A
Delete Record
B
Add New Record
C
Edit Record
D
Move Field
12) Eddie needs to search for the specific employee that lives on 225 Mayberry Lane. What command would he use?
A
Sort Descending
B
Filter
C
Sort Ascending
D
Find
13) Dennis needs to format his sales amount column to show dollar signs. Which format would he use?
A
Text
B
General Number
C
Currency
D
Fixed
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
Sort
B
Hide Fields
C
Format
D
Freeze Fields
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
Query
B
Report
C
Filters
D
Form
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 AND swimming
B
=200 AND swimming
C
=200 OR swimming
D
200 OR 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
Data Type
C
Field Name
D
Description
*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?