New Perspectives Microsoft®Office 365 & Office 2016 Introductory, Spiral bound Version 1st Edition by Patrick Carey Carol DesJardins Ann Shaffer Mark Shellman Sasha Vodnik

New Perspectives Microsoft®Office 365 & Office 2016: Introductory, Spiral bound Version | 1st Edition by Patrick Carey/Carol
DesJardins/Ann Shaffer/Mark Shellman/Sasha Vodnik




New Perspectives Microsoft®Office 365 & Office 2016: Introductory, Spiral bound Version | 1st Edition by Patrick Carey/Carol
DesJardins/Ann Shaffer/Mark Shellman/Sasha Vodnik

,Name: Class: Date:




Access Module 01: Creating a Database
1. A database or a relational database is a collection of related tables.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Introduction to Database Concepts

2. Each record in a table is uniquely identified by a foreign key.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: Introduction to Database Concepts

3. A software program that lets the user create databases and then manipulate the data in the databases is called a database
management system (DBMS).
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Managing a Database

4. A table is a predesigned database that includes professionally designed database
objects.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: Starting Access and Creating a Database

5. The only option available for creating tables in Access is to use the datasheet view.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: Creating a Table in Datasheet View

6. The number of the currently selected record in a table and the total number of records in the table are displayed in the
Current Record box which appears between the two sets of navigation buttons on a data
sheet.
a. True
b. False

Copyright Cengage Learning. Powered by Cognero. Page 1

,Name: Class: Date:



ANSWER: True
POINTS: 1
REFERENCES: Creating a Table in Datasheet View

7. A question asked about the data stored in a database is called a primary key.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: Creating a Table in Datasheet View

8. A query is used to enter, edit, and view records in a database.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: Session 1.2 Visual Overview

9. When creating a form in Access, the Layout view allows the user to make design changes to the form while it is
displaying data.

a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Creating a Simple Form

10. Compacting a database rearranges the data and objects in a database to decrease its file
size.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Managing a Database

11. A single characteristic or attribute of a person, place, object, event, or idea is a table.
ANSWER: False - field
POINTS: 1
REFERENCES: Introduction to Database Concepts

12. A relationship between two tables in a database is formed using a Backstage field.
ANSWER: False - common
POINTS: 1
REFERENCES: Introduction to Database Concepts

Copyright Cengage Learning. Powered by Cognero. Page 2

, Name: Class: Date:



13. Each Access database may be as large as two gigabytes in size and may have up to 255 people using the database at
the same time.

ANSWER: True
POINTS: 1
REFERENCES: Introduction to Database Concepts

14. The default primary key for an Access database is the ID field.
ANSWER: True
POINTS: 1
REFERENCES: Introduction to Database Concepts

15. Field values that may be entered into a field are determined by the data type of the
field.
ANSWER: True
POINTS: 1
REFERENCES: Creating a Table in Datasheet View

16. The query results are stored in the database in which the query has been created.
ANSWER: False - are not, aren’t
POINTS: 1
REFERENCES: Creating a Table in Datasheet View

17. A formatted printout (or screen display) of the contents of one or more tables or queries is
a form.
ANSWER: False - report
POINTS: 1
REFERENCES: The CREATE Tab Options

18. It is possible to view all Access objects in the Navigation Pane.
ANSWER: True
POINTS: 1
REFERENCES: Viewing Objects in the Navigation Pane

19. The default sort order for records in an Access table is based on the values in the primary key field.

ANSWER: True
POINTS: 1
REFERENCES: Introduction to Database Concepts

20. Access report printing options may be changed using the Navigation dialog box.
ANSWER: False - Print
POINTS: 1
REFERENCES: Creating a Simple Report


Copyright Cengage Learning. Powered by Cognero. Page 3