NEW
Font size
S
M
L
XL
WorksheetsAccess Unit Review Part 1
Total questions: 30
Worksheet time: 15mins
Name
Class
Date
1.
Calculated field is a field that can be computed from other fields.
a)
TRUE
b)
FALSE
2.
The message that will appear if a user violates the validation rule is called a validation text.
a)
TRUE
b)
FALSE
3.
Update query allows you to add the results of a query to an existing table.
a)
TRUE
b)
FALSE
4.
< is an example of a format symbol.
a)
TRUE
b)
FALSE
5.
The default query allows you to delete all the records satisfying some criterion.
a)
TRUE
b)
FALES
6.
Validation text are rules that a user must follow when entering data.
a)
FALSE
b)
TRUE
7.
Required fields are fields in which the user actually must enter data.
a)
TRUE
b)
FALSE
8.
Make-up table fields allows you to add the records to a new table.
a)
TRUE
b)
FALSE
9.
Default value presents in Access a value that will display on the screen in a particular field before the user begins adding a record.
a)
TRUE
b)
FALSE
10.
Update query allows you to make the same change to all records.
a)
TRUE
b)
FALSE
11.
Access is a ____.
a)
word processing software tool
b)
workbook management system
c)
file management system
d)
database management system
12.
A(n) ____ contains information about a given person, product, or event.
a)
attribute
b)
record
c)
field
d)
column
13.
Database ____ refers to the arrangement of data into tables and fields.
a)
language
b)
relations
c)
design
d)
management
14.
____ words are words that have a special meaning to Access and cannot be used for the names of fields.
a)
Restricted
b)
Reserved
c)
Significant
d)
Special
15.
In Access, table and field names can be up to ____ characters in length.
a)
32
b)
128
c)
64
d)
255
16.
A field whose data type is ____ can contain any characters.
a)
Alpha
b)
Text
c)
Normal
d)
Lookup
17.
A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.
a)
Unlimited
b)
Memo
c)
Variable
d)
Character
18.
A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.
a)
Sequential
b)
AutoNumber
c)
Incremental
d)
AutoSequence
19.
A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.
a)
File
b)
Document
c)
Attachment
d)
Extend
20.
A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.
a)
Picture
b)
Image
c)
OLE Object
d)
Bitmap
21.
In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a ____ .
a)
container
b)
repository
c)
placeholder
d)
database
22.
One way to create a table, is to click ____ on the Ribbon and then click the Table button.
a)
New
b)
Create
c)
Add
d)
Insert Table
23.
When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.
a)
Field 1
b)
ID
c)
AutoCode
d)
TableCode
24.
To define an additional field in Datasheet view, click the ____ column heading.
a)
New Field
b)
Blank Field
c)
Insert Field
d)
Click to Add
25.
To undo the most recent change to a table structure, click the ____ button on the Quick Access Toolbar.
a)
Cancel
b)
Escape
c)
Back
d)
Undo
26.
To delete a field in a table, right-click the column heading for the field, and then click ____ on the shortcut menu.
a)
Delete Field
b)
Remove Field
c)
Delete Column
d)
Remove Column
27.
To change the name of a field, right-click the column heading for the field, click ____ on the shortcut menu, and then type the desired field name.
a)
Rename Field
b)
Rename Column
c)
Change Field
d)
Change Column
28.
To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.
a)
Field Size
b)
Caption
c)
Format
d)
Description
29.
To insert a field between existing fields, right-click the column heading for the field that will follow the new field, and then click ____ on the shortcut menu.
a)
Insert Field
b)
Insert Column
c)
Add Field
d)
Add Column
30.
In the accompanying figure, the key symbol that appears in the row selector for the Business Analyst Number field indicates that Business Analyst Number is the ____ for the table.
a)
principal key
b)
foreign key
c)
primary key
d)
main key
Reset
