WorksheetsAccess
Total questions: 30
Worksheet time: 32mins
Name
Class
Date
1.
What Query view is shown in this image?
a)
Datasheet View
b)
Design View
2.
Where do you configure the field properties of a Table?
a)
Design View
b)
Datasheet View
c)
Access View
d)
Window View
3.
Where do you see the results of a Query?
a)
Query Design View
b)
Query Datasheet View
c)
Query DataSet Review
d)
Table Design View
4.
Data type where the field can contain any character is "_____".
a)
text
b)
autonumber
c)
currency
d)
decimal
5.
If you want to put your data into alphabetical order by last name, you could use the __________ command.
a)
Shift
b)
Font
c)
autofill
d)
Sort
6.
To rename a table or other database object, first
a)
save it.
b)
close it.
c)
edit it.
d)
open it.
7.
A complete list of field properties is available in
a)
the Navigation Pane.
b)
Datasheet view.
c)
Design view.
d)
all of the above.
8.
Which field property requires users to enter data in a specific format such as a telephone number or social security?
a)
Validation Text
b)
Default Value
c)
Required
d)
Input Mask
9.
The Default Value property can be used for which field?
a)
Short Text
b)
Number
c)
Currency
d)
All of the above
10.
When you create a new blank database, Access opens a database that contains
a)
one of each type of database object.
b)
a table.
c)
sample data.
d)
a template.
11.
A unique identifier used in creating a table that assures there will be no duplicate data.
a)
Primary Key
b)
Query
c)
Data Type
d)
Object
12.
.accdb means
a)
Abracadabra
b)
Access
c)
Amazing
d)
Animal
13.
A query is a cell in the database.
a)
True
b)
False
14.
What is design view?
a)
The function we use to set up a table in a database.
b)
The place where we type in all the information.
15.
What is the grid containing columns (fields) and rows (records) where you add, edit, and delete records in an Access database table.
a)
Design View
b)
Window View
c)
Ocean View
d)
Datasheet view
16.
What Automatically adds a unique number to the primary key field for each record in the table?
a)
AutoFit
b)
AutoNumber
c)
BestFit
d)
FitNow
17.
Which of the following is NOT a valid database object?
a)
Table
b)
Form
c)
Report
d)
File
18.
What database object is a series of rows and columns that organize data effectively?
a)
Table
b)
Query
c)
Form
d)
Report
19.
What is a database object that enables you to ask questions about the data stored in a database and returns the answers in the order from the records that match your instructions?
a)
Table
b)
Form
c)
Report
d)
Query
20.
Columns in the table
a)
field columns
b)
fields
c)
columns
d)
none of the answers
21.
Which of the following is NOT data type?
a)
Date/Time
b)
Short Text
c)
Long Text
d)
Formula
22.
The wildcard character is a(n) _____ sign.
a)
&
b)
=
c)
#
d)
*
23.
This icon shows a____.
a)
Table
b)
Query
c)
Form
d)
Report
24.
The circled command_______
a)
Sorts records in descending order
b)
Sorts records in ascending order
c)
helps you select a single record or all records in a datasheet
d)
removes the current sort order
25.
__________ are small squares that allow you to resize a photo or object
a)
Label Handles
b)
Combo Boxes
c)
Resizers
d)
Sizing Handles
26.
Which data type will be used if I am wanting to list a start date?
a)
Long Text
b)
Short Text
c)
AutoNumber
d)
Date/Time
27.
The tab shows a ____ is open.
a)
Table
b)
Query
c)
Form
d)
Report
28.
The ____ button filters records that equal or do not equal.
a)
Comparative
b)
Selection
c)
Comparison
d)
Advanced
29.
Hospitals uses database
a)
TRUE
b)
false
30.
Which type of query has brackets in the question?
a)
Specific Criteria
b)
Wildcard Query
c)
Parameter Query
d)
Query using comparison operative operators
100 %
