WorksheetsMS Access Terminology
Total questions: 20
Worksheet time: 8mins
Name
Class
Date
1.
Which of the following is NOT condered a database object in Microsoft Access?
a)
Record
b)
Table
c)
Query
d)
Form
2.
This database object is a primary container used to hold data in MS Access
a)
Query
b)
Form
c)
Table
d)
Report
3.
Designed to show only one record at a time, this object is useful for editing and data input.
a)
Table
b)
Form
c)
Query
d)
Report
4.
A ___________ is designed to "ask" a question of the database and returns only a subset of data
a)
Query
b)
Form
c)
Table
d)
Record
5.
This object is used for "output" only and cannot edit or add information to the database
a)
Table
b)
Query
c)
Form
d)
Report
6.
A _________ ___ is a unique identifier for the table.
a)
line item
b)
data type
c)
primary key
d)
property field
7.
The table view that displays data in rows and columns is called the
a)
datasheet view
b)
design view
c)
form view
d)
report view
8.
The ___________ displays all objects in a database
a)
object view
b)
property sheet
c)
navigation pane
d)
home tab
9.
The ________ _____ defines the type of data stored in a field.
a)
query grid
b)
field name
c)
record type
d)
data type
10.
The default data type assigned to a primary key is ________________.
a)
autonumber
b)
text
c)
number
d)
integer
11.
Which of the following best describes the results of the query shown?
a)
Returns the school names of the athletes in the competetion
b)
Returns the AthleteNumbers from Bogtown College
c)
Returns the names of the athletes from Bogtown College
d)
Return the names of the Athletes from each school
12.
An alternative term for Table
a)
Entity
b)
Attribute
c)
Relation
d)
Object
13.
An alternative term for Field
a)
Record
b)
Attribute
c)
Key
d)
Object
14.
File extension for Access 2013
a)
.accdb
b)
.acdb
c)
.accd
d)
.access
15.
To run a query, click which of the following?
a)
File menu
b)
The Σ button
c)
Red exclamation mark
d)
The design button
16.
An alternative name for Record
a)
Tuple
b)
Tiple
c)
Topple
d)
Tapple
17.
The Σ button is used to...
a)
Add a total row in a query
b)
Find the sum of all the value
c)
Allow fields to be sorted
d)
Add criteria to a search
18.
A query can be based on...
a)
Tables
b)
Queries
c)
Forms
d)
Reports
19.
What is required to save records using a form, checking that all the fields are complete?
a)
Micras
b)
Macaroni
c)
Mickey Mouse
d)
Macros
20.
MS Access is an example of a RDBMS. What do these letters stand for?
a)
Relational Database Management System
b)
Rational Data Based on Management Sytem
c)
Reports Data Based on Making Sums
d)
Real Data Beautifully Made Splendid
100 %
