NEW
Font size
S
M
L
XL
WorksheetsAccess
Total questions: 51
Worksheet time: 26mins
Name
Class
Date
1.
What uniquely identifies each record?
a)
Primary Field
b)
Field Name
c)
Primary Key
d)
Field Key
2.
Microsoft Office is a _______ software in Microsoft.
a)
Database
b)
Spreadsheet
c)
Word Processing
d)
Presentation
3.
Calculated expressions always start with a(n)____ sign.
a)
+
b)
=
c)
(
d)
[
4.
Field properties do not change when the data type of changed.
a)
True
b)
False
5.
You can only add one grouping level to a report.
a)
True
b)
False
6.
To search for a pattern (3/*/2014), use a __________.
a)
Wildcard
b)
Filter
c)
AND criteria
d)
OR critiera
7.
Which tab allows you to change the tab stop order on the Property Sheet?
a)
Layout
b)
Other
c)
Format
d)
Data
8.
Where is the record selector button found?
a)
To the right of the record
b)
On the top ribbon under the Home tab
c)
Under the Arrange tab
d)
To the left of the record
9.
By filtering more data, you are increasing the number of results you will receive.
a)
True
b)
False
10.
Which of the following is NOT data type?
a)
Date/Time
b)
Short Text
c)
Long Text
d)
Formula
11.
______ are category names, such as Name, Phone Number, and Price.
a)
Names
b)
Files
c)
Fields
d)
Tables
12.
___________ is putting records in ascending or descending order.
a)
Filtering
b)
Sorting
c)
Toggle
d)
Criteria
13.
The wildcard character is a(n) _____ sign.
a)
&
b)
=
c)
#
d)
*
14.
The greater than sign is _______.
a)
<
b)
>
c)
<=
d)
=>
15.
The following is the less than or equal to sign_____.
a)
>
b)
<
c)
=>
d)
<=
16.
Which symbols go around a field name within an expression?
a)
()
b)
[]
c)
{}
d)
=
17.
A(n) ________ relationship describes when a record from one table is related to several records in another table.
a)
One-to-One
b)
One-to-Many
c)
Many-to-One
d)
One-to-All
18.
An AutoNumber is automatically created by Access.
a)
True
b)
False
19.
This icon shows a____.
a)
Table
b)
Query
c)
Form
d)
Report
20.
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
21.
__________ are small squares that allow you to resize a photo or object
a)
Label Handles
b)
Combo Boxes
c)
Resizers
d)
Sizing Handles
22.
A 8.5 x 11" is _______ orientation.
a)
Portrait
b)
Landscape
23.
A 11x8.5" is ___________ orientation.
a)
Portrait
b)
Landscape
24.
The lower pane in Query Design View is a __________
a)
Datasheet
b)
Query
c)
Query Grid
d)
Form
25.
a)
Font Color
b)
Bold
c)
Italics
d)
Underline
26.
a)
Center Alignment
b)
Right Alignment
c)
Left Alignment
d)
Justify
27.
a)
Left Alignment
b)
Right Alignment
c)
Center Alignment
d)
Justify
28.
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
29.
To delete a record from a query datasheet, I need to select the record and choose backspace.
a)
True
b)
False
30.
Data is a type of form view.
a)
True
b)
False
31.
A(n) ____________ is a built-in formula, such as Sum or Count
a)
Expression
b)
Calculation
c)
Formula
d)
Equation
32.
The lower pane of a split form displays a datasheet view.
a)
True
b)
False
33.
Creates a temporary subset of records
a)
Sorting
b)
Filter
c)
Criteria
d)
Query
34.
Creates a datasheet of selected fields and records from one or more tables.
a)
Table
b)
Query
c)
Form
d)
Report
35.
If a field shows the amount you have paid on an account, what would the data type be?
a)
Text
b)
Number
c)
Monetary
d)
Currency
36.
A query is created with one or more forms, then is presented in a single datasheet.
a)
True
b)
False
37.
The tab shows a ____ is open.
a)
Table
b)
Query
c)
Form
d)
Report
38.
Used to provide a list of options for a field, plus the availability to enter a new value
a)
List Box
b)
Combo Box
c)
Label
d)
Textbox
39.
a)
Table
b)
Query
c)
Form
d)
Report
40.
a)
Table
b)
Query
c)
Form
d)
Report
41.
The ____ button filters records that equal or do not equal.
a)
Comparative
b)
Selection
c)
Comparison
d)
Advanced
42.
_________ accesses Multiple Items, Datasheet, or Split Form
a)
Form Design
b)
Blank Form
c)
Form Wizard
d)
More Forms
43.
The Align button is found on the ______ tab.
a)
Arrange
b)
Options
c)
Home
d)
Format
44.
______ view is used to enter, edit, and delete data
a)
Form
b)
Layout
c)
Design
45.
_____ view is used to modify controls (add headers and footers)
a)
Form
b)
Design
c)
Layout
46.
______ view can be used to move and modify controls (formatting)
a)
Form
b)
Design
c)
Layout
47.
Provides descriptive text for records
a)
List Box
b)
Combo Box
c)
Command Button
d)
Label
48.
Used to visually separate information on a form
a)
Label
b)
Spacing
c)
Line
d)
Toggle
49.
Used to run a macro (select options on ribbons)
a)
Toggle
b)
Tab Control
c)
Combo Box
d)
Command Button
50.
Used to provide a list of possible data entries
a)
Combo Box
b)
List Box
c)
Toggle
d)
Tab Control
51.
Displays choices for a field
a)
Option Button
b)
Combo Box
c)
Command Button
d)
List box
Reset
