Name:     ID: 
 
Email: 

BUAD 1305 Access Tutorial 1 Quiz 1

True/False
Indicate whether the statement is true or false.
 

 1. 
A collection of fields describing a person, place, object, event, or idea is a table.
 

 2. 
A single set of field values within a table is a record.
 

 3. 
A database is a collection of related tables.
 

 4. 
A collection of related tables is called a relational database.
 

 5. 
When two tables are related by a common field, users can tie together facts from the two tables.
 

 6. 
A primary key in one table cannot be used as a foreign key in a different table.
 

 7. 
A DBMS controls the storage of databases on disk by carrying out data creation and manipulation requests.
 

 8. 
Although a field has unique values in the table in which it is the primary key, it does not have to have unique values in the table in which it is the foreign key.
 

 9. 
Like spreadsheets, a DBMS can handle massive amounts of data and can easily form relationships among multiple tables.
 

 10. 
More than one user can enter data into a database.
 

 11. 
Only one user can retrieve and analyze data that was entered into a database by others.
 

 12. 
A database defined in Access can be as large as you want it to be.
 

 13. 
The navigation buttons allow you to step through a table record by record, or to quickly go to the first or last record in the table.
 

 14. 
Query results automatically are stored in the database.
 

 15. 
The fastest way to display all fields from an open table on a form is to use the Form Wizard.
 

 16. 
Records in a database can be displayed in a custom format by creating a form.
 

 17. 
A form allows you to view and maintain your data in a customized format.
 

 18. 
By defining a report, you can create a formatted printout or display of the data contained in one or more tables.
 

Matching
 
 
Identify the letter of the choice that best matches the phrase or definition.
a.
field
g.
foreign key
b.
table
h.
DBMS
c.
field value
i.
report
d.
relational database
j.
backing up
e.
common field
k.
compact
f.
primary key
l.
query
 

 19. 

 Organizes data as a collection of tables
 

 20. 

 A collection of related tables
 

 21. 

 The specific content of a field
 

 22. 

 Connects the records in separate tables
 

 23. 

 A single characteristic or attribute of a person, place, object, event, or idea
 

 24. 

 A primary key from one table that is used to form a relationship with a second table
 

 25. 

 A collection of fields that describe a person, place, object, event, or idea
 

 26. 

 A field or collection of fields whose values uniquely identify each record in a table
 

 27. 

 A question you ask about data stored in a database
 

 28. 

 A formatted printout (or screen display) of the contents of one or more tables
 

 29. 

 To rearrange the data and objects in a database file, to decrease its file size
 

 30. 

 The process of making a copy of the database file to protect your data against loss or damage
 

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 31. 
The Save button on the Quick Access Toolbar is used to ____.
a.
save the database file to your disk
b.
save the database file with a new name
c.
save the design of an Access object
d.
none of the above; this is a setting determined by the user.
 

 32. 
A ____ is a question you ask about data stored in a database.
a.
report
c.
query
b.
form
d.
macro
 

 33. 
You can click the ____ button on the Query Datasheet toolbar to sort records in ascending alphabetical order by the values in a selected field.
a.
Ascending
c.
Ascending Order
b.
Alpha Sort
d.
Select Sort
 

 34. 
In Datasheet view, clicking a row selector selects an entire ____.
a.
field
c.
array
b.
record
d.
attribute
 

 35. 
In Datasheet view, the star symbol that appears in the record selector area always identifies the ____ in the database.
a.
first field
c.
first record
b.
current field
d.
next available row for a new record
 

 36. 
The first step in organizing data into a database is to define the ____.
a.
records
c.
fields
b.
formats
d.
reports
 

 37. 
The three basic steps to creating a database, in order, are: ____.
a.
group fields in a table, identify individual fields, enter field values for each record
b.
identify the individual fields, group fields in a table, enter field values for each record
c.
enter field values for each record, group fields in a table, identify individual fields
d.
group fields in a table, identify the individual fields, enter field values for each record
 

 38. 
All fields for a specific individual or place can be grouped together as a(n) ____.
a.
table
c.
element
b.
database
d.
object
 

 39. 
Which of the following could be defined as a field in a database?
a.
customer name
c.
phone number
b.
order number
d.
all of the above
 

 40. 
A field, or a combination of fields, that has a unique value is a ____.
a.
foreign key
c.
table
b.
primary key
d.
relation
 

 41. 
Data from two or more tables can be connected by specifying a ____.
a.
common field
c.
field value
b.
hyperlink
d.
primary key
 

 42. 
A relational database is a collection of ____.
a.
field values
c.
related tables
b.
records
d.
common fields
 

 43. 
A primary key ____.
a.
consists of only one field
b.
has the same value for all records
c.
must contain a unique value for each record within the table
d.
is not usually necessary
 

 44. 
A relational DBMS allows you to create database structures containing ____.
a.
fields
c.
table relationships
b.
tables
d.
all of the above
 

 45. 
Every foreign key must ____.
a.
be unique
b.
be numeric
c.
match the field value of a primary key in a related table
d.
be defined in all tables within the database
 

 46. 
A field that is defined in a table and that is also defined as a primary key in a different table is a(n) ____.
a.
invalid definition
c.
relational database
b.
primary key
d.
foreign key
 

 47. 
Access allows you to ask questions and obtain information about your data through use of a built-in ____.
a.
inquisitor
c.
table generator
b.
query language
d.
report generator
 

 48. 
Which of the following is NOT an example of an Access object?
a.
report
c.
form
b.
query
d.
Report tool
 

 49. 
You open a table, or any Access object by double-clicking the object name in the ____.
a.
Views group on the Ribbon
c.
Navigation Pane
b.
Home tab
d.
Office Button
 

 50. 
The total number of records in an opened table is displayed ____.
a.
in the menu bar
b.
in the row selector
c.
in the Specific Record box
d.
between the two sets of navigation buttons
 

 51. 
A form is used to ____.
a.
select records that meet specific criteria
b.
enter, edit, and view records in a database
c.
automate the retrieval and update process
d.
none of the above
 

 52. 
The fastest way to create a form is to use the ____.
a.
Form tool
c.
Create form tab
b.
Form Wizard
d.
Form Design view
 

 53. 
After saving a query, you can recreate its results when you ____.
a.
reenter the query
c.
click the Print button
b.
start the Query Wizard
d.
open the query again
 
 
nar001-1.jpg
 

 54. 
In the figure above, each column represents a ____.
a.
record
c.
table
b.
field
d.
primary key
 

 55. 
In the figure above, Owen is a ____.
a.
field
c.
record
b.
field value
d.
key
 

 56. 
In the figure above, the last row of data shown (11053, Hwan, Tang, etc.) is a ____.
a.
table
c.
record
b.
field
d.
key
 

 57. 
In the figure above, there are ____ fields shown.
a.
3
c.
5
b.
4
d.
6
 

 58. 
You can make a(n) ____ copy of a database file to protect your database against loss or damage.
a.
master
c.
restore
b.
backup
d.
secure
 

 59. 
When you delete records, the space that had been occupied on the disk by the deleted records does not become available until you ____ the database.
a.
initialize
c.
compact
b.
format
d.
integrate
 

 60. 
If you want to see how many pages are likely to print in a report, you must use ____.
a.
Report view
c.
Design view
b.
Layout view
d.
Print Preview
 



 
         Start Over