NEW
Font size
S
M
L
XL
WorksheetsAccess 2016
Total questions: 40
Worksheet time: 39mins
Name
Class
Date
1.
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
2.
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
3.
To rename a table or other database object, first
a)
save it.
b)
close it.
c)
edit it.
d)
open it.
4.
A complete list of field properties is available in
a)
the Navigation Pane.
b)
Datasheet view.
c)
Design view.
d)
all of the above.
5.
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
6.
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.
7.
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
8.
.accdb means
a)
Abracadabra
b)
Access
c)
Amazing
d)
Animal
9.
A query is a cell in the database.
a)
True
b)
False
10.
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.
11.
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
12.
Which of the following is NOT data type?
a)
Date/Time
b)
Short Text
c)
Long Text
d)
Formula
13.
__________ are small squares that allow you to resize a photo or object
a)
Label Handles
b)
Combo Boxes
c)
Resizers
d)
Sizing Handles
14.
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
15.
The tab shows a ____ is open.
a)
Table
b)
Query
c)
Form
d)
Report
16.
The ____ button filters records that equal or do not equal.
a)
Comparative
b)
Selection
c)
Comparison
d)
Advanced
17.
Hospitals uses database
a)
TRUE
b)
false
18.
Which type of query has brackets in the question?
a)
Specific Criteria
b)
Wildcard Query
c)
Parameter Query
d)
Query using comparison operative operators
19.
What Query view is shown in this image?
a)
Datasheet View
b)
Design View
20.
Where do you configure the field properties of a Table?
a)
Design View
b)
Datasheet View
c)
Access View
d)
Window View
21.
Data type where the field can contain any character is "_____".
a)
text
b)
autonumber
c)
currency
d)
decimal
22.
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
23.
Which of the following is NOT a valid database object?
a)
Table
b)
Form
c)
Report
d)
File
24.
What database object is a series of rows and columns that organize data effectively?
a)
Table
b)
Query
c)
Form
d)
Report
25.
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
26.
Columns in the table
a)
field columns
b)
fields
c)
columns
d)
none of the answers
27.
The wildcard character is a(n) _____ sign.
a)
&
b)
=
c)
#
d)
*
28.
This icon shows a____.
a)
Table
b)
Query
c)
Form
d)
Report
29.
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
30.
A Primary Key is a code that uniquely identifies a _____________ in a Database.
a)
Record
b)
Field
c)
Text
d)
Number
31.
A _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.
a)
Query
b)
Report
c)
Database
d)
Spreadsheet
32.
Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.
a)
Cell
b)
Field
c)
Column
d)
Record
33.
In a database table, rows are called __________
a)
Field
b)
Record
c)
Primary Key
34.
Forms, queries, and reports are created based on the information in the _________
a)
Form
b)
Table
c)
Report
35.
In a database form, the blanks in which information is entered are called ________.
a)
Fields
b)
Record
c)
Query
d)
Database
36.
When the blanks are filled in, the form becomes a _________.
a)
Fields
b)
Record
c)
Database
d)
Query
37.
The sort feature is responsible for controlling the sequence, or order, of the records.
a)
True
b)
False
38.
A database and a table is the same thing.
a)
True
b)
False
39.
The _________ is used to identify each record in the table with a number.Correct answer:
a)
Field
b)
Primary key
40.
Database forms are computerized versions of paper forms, such as a patient record, job application or a class registration form.
a)
True
b)
False
Reset
