Worksheets8G3A Microsoft Access
Total questions: 30
Worksheet time: 16mins
Name
Class
Date
1.
In your database, information is stored in the...
a)
Table
b)
Query
c)
Report
d)
Form
2.
In a TABLE, a column is known as a...
a)
Record
b)
Field
c)
Garden
d)
Stage
3.
Access offers different views of objects. Which view do you use to edit data in a table?
a)
Design View
b)
Datasheet View
c)
Layout View
d)
Table View
4.
Records in a table can be updated any time.
a)
True
b)
False
5.
Which object would you create to share the data from your database with others?
a)
Form
b)
Report
c)
Query
d)
Table
6.
A Drop-Down List you can add to your form is called a...
a)
dialog box
b)
command box
c)
combo box
d)
jack in the box
7.
In a TABLE, a row is known as a...
a)
Record
b)
Field
c)
File
d)
Stage
8.
The best way to edit & update your data is in a...
a)
Table
b)
Form
c)
Query
d)
Report
9.
The collection of all of the fields of data for one item are contained in a _____________.
a)
form
b)
field
c)
row
d)
record
10.
Forms are used to . . .
a)
organize data
b)
store data
c)
display data
d)
print data
11.
Reports are used to _____________.
a)
organize data
b)
display data on the screen
c)
print out data
d)
store data
12.
Queries are used to ____________.
a)
organize data
b)
store data
c)
print out data
d)
display data on the screen
13.
Tables are used to ____________.
a)
organize data
b)
store data
c)
print out data
d)
display data on the screen
14.
a)
table
b)
form
c)
menu bar
15.
a)
table
b)
menu bar
c)
form
16.
a)
menu bar
b)
table
c)
form
17.
What are first two steps in creating a new database?
a)
To create a new database, click the blank database icon
b)
Type the desired database name and select its disk location path, click the Create button
c)
Type the desired table name on the Save As dialog box the click ok
18.
What are found in the table?(Select 3 answers)
a)
field name
b)
data type
c)
field description
d)
form
e)
design view
19.
What is the appropriate data type if your field name is birthdate?
a)
number
b)
data/time
c)
text
d)
autonumber
20.
Hank wants to add color to the header section of his form. Which formatting option would he use?
a)
Fill Color
b)
Font Size
c)
Font Color
d)
Format Painter
21.
The owner of Ima Graphic Animator, Inc., a graphic design company, wants to quickly create a new blank database object, one which includes one record at a time and a more detailed view of the structure. Which design should be used?
a)
Table Design
b)
Report Design
c)
Query Design
d)
Form Design
22.
Riley is using Microsoft Access to collect data for a science project. He is creating a form and wants to apply predefined color and font scheme formats. Which Form Layout Tools contextual tabs should he select for the theme group?
a)
Design tab
b)
Format tab
c)
Arrange tab
d)
Page Setup tab
23.
Ashton needs to add a footer to the data entry form in his gaming database. Which view will allow Ashton to add a footer?
a)
Form View
b)
Layout View
c)
Design View
d)
Navigation Form
24.
Juan wants to view one record at a time in his database. Which view should he use?
a)
Design View
b)
Form View
c)
Layout View
d)
Navigation Pane
25.
Jeremy needs to create a quick form based on a single table in his baseball card database. Which option will automatically include all the fields from a single table?
a)
Blank Form
b)
Form Design
c)
Form Wizard
d)
Form Tool
26.
Tyler is using Microsoft Access for a class assignment. Which database object would she use to enter one record at a time?
a)
Table
b)
Form
c)
Macro
d)
Report
27.
Michelle wants to change the color of her form to make it more attractive. Which should she use?
a)
Form
b)
Filter
c)
Controls
d)
Theme
28.
Avery is the president of her FBLA chapter. She is asked to pull a detailed summary of all competition participation for scholarship applications. Which report creation toll will pull the fields?
a)
Report
b)
Report Design
c)
Blank Report
d)
Report Wizard
29.
The report cards needs to be arrange by last name and first name. What tool can be used to ensure that students appear in alphabetical order on the report cards?
a)
Sort
b)
Filter
c)
Conditional Formatting
d)
Grouping
30.
The report Jamie created has a dark background and the page number us not displaying correctly. Which formatting option would he apply to contrast between the background and the page number?
a)
Fill Color
b)
Font Size
c)
Font Color
d)
Format Painter
100 %
