Access 2016 - Module 1: Getting Started with Access

Access 2016 - Module 1: Getting Started with Access

Copyright Cengage Learning. Powered by Cognero. Page 1

• More than one person can enter, update, and analyze data in an Access database at the same time.
• True
• False

ANSWER: True

POINTS: 1

REFERENCES: Access 2

Understand Relational Databases

QUESTION TYPE: True / False

HAS VARIABLES: False

LEARNING OBJECTIVES: ENHA.FRIE.16.001 - Explain when to use a database

DATE CREATED: 2/26/2016 8:13 PM

DATE MODIFIED: 4/9/2016 1:25 PM

• Access databases cannot be password protected.
• True
• False

ANSWER: False

POINTS: 1

REFERENCES: Access 2

Understand Relational Databases

QUESTION TYPE: True / False

HAS VARIABLES: False

DATE CREATED: 4/9/2016 1:29 PM

DATE MODIFIED: 4/9/2016 1:30 PM

• An Access database is limited to a size of 1 gigabyte.
• True
• False

ANSWER: False

POINTS: 1

REFERENCES: Access 3

Understand Relational Databases

QUESTION TYPE: True / False

HAS VARIABLES: False

LEARNING OBJECTIVES: ENHA.FRIE.16.002 - Describe relational database concepts

DATE CREATED: 2/26/2016 8:13 PM

DATE MODIFIED: 2/26/2016 8:13 PM

• Tables contain all of the data in the database.
• True
• False

ANSWER: True

POINTS: 1

(Illustrated Microsoft® Office 365 & Office 2016, Introductory, 1e David Beskeen, Carol M. Cram, Jennifer Duffy) (Test Bank all Chapters) 1 / 4

Name:

Class:

Date:

Access 2016 - Module 1: Getting Started with Access

Copyright Cengage Learning. Powered by Cognero. Page 2

REFERENCES: Access 5

Explore a Database

QUESTION TYPE: True / False

HAS VARIABLES: False

LEARNING OBJECTIVES: ENHA.FRIE.16.003 - Open and define Access objects

DATE CREATED: 2/26/2016 8:13 PM

DATE MODIFIED: 2/26/2016 8:13 PM

• If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the

AutoNumber data type can no longer work as intended.

• True
• False

ANSWER: False

POINTS: 1

REFERENCES: Access 8

Create a Table

QUESTION TYPE: True / False

HAS VARIABLES: False

LEARNING OBJECTIVES: ENHA.FRIE.16.004 - Set appropriate data types for fields

DATE CREATED: 2/26/2016 8:13 PM

DATE MODIFIED: 2/26/2016 8:13 PM

• A primary key field uniquely identifies each record.
• True
• False

ANSWER: True

POINTS: 1

REFERENCES: Access 10

Create Primary Keys

QUESTION TYPE: True / False

HAS VARIABLES: False

LEARNING OBJECTIVES: ENHA.FRIE.16.005 - Set the primary key field

DATE CREATED: 2/26/2016 8:13 PM

DATE MODIFIED: 2/26/2016 8:13 PM

• No two records can have the same value in the primary key field.
• True
• False

ANSWER: True

POINTS: 1

REFERENCES: Access 10

Create Primary Keys

QUESTION TYPE: True / False 2 / 4

Name:

Class:

Date:

Access 2016 - Module 1: Getting Started with Access

Copyright Cengage Learning. Powered by Cognero. Page 3

HAS VARIABLES: False

LEARNING OBJECTIVES: ENHA.FRIE.16.005 - Set the primary key field

DATE CREATED: 2/26/2016 8:13 PM

DATE MODIFIED: 2/26/2016 8:13 PM

• Field properties change depending on the data type of the field.
• True
• False

ANSWER: True

POINTS: 1

REFERENCES: Access 11

Create Primary Keys

QUESTION TYPE: True / False

HAS VARIABLES: False

LEARNING OBJECTIVES: ENHA.FRIE.16.005 - Set the primary key field

DATE CREATED: 2/26/2016 8:13 PM

DATE MODIFIED: 2/26/2016 8:13 PM

• The linking field on the “many” side of a one-to-many relationship is called the foreign key field.
• True
• False

ANSWER: True

POINTS: 1

REFERENCES: Access 12

Relate Two Tables

QUESTION TYPE: True / False

HAS VARIABLES: False

LEARNING OBJECTIVES: ENHA.FRIE.16.006 - Create one-to-many relationships

DATE CREATED: 2/26/2016 8:13 PM

DATE MODIFIED: 2/26/2016 8:13 PM

• A subdatasheet shows the records on the “many” side of a one-to-many relationship.
• True
• False

ANSWER: True

POINTS: 1

REFERENCES: Access 12

Relate Two Tables

QUESTION TYPE: True / False

HAS VARIABLES: False

LEARNING OBJECTIVES: ENHA.FRIE.16.007 - Define common field and foreign key field

DATE CREATED: 2/26/2016 8:13 PM

DATE MODIFIED: 2/26/2016 8:13 PM

• / 4

Name:

Class:

Date:

Access 2016 - Module 1: Getting Started with Access

Copyright Cengage Learning. Powered by Cognero. Page 4

• “Focus” refers to which data you would edit if you started typing.
• True
• False

ANSWER: True

POINTS: 1

REFERENCES: Access 14

Enter Data

QUESTION TYPE: True / False

HAS VARIABLES: False

LEARNING OBJECTIVES: ENHA.FRIE.16.008 - Enter records in a datasheet

DATE CREATED: 2/26/2016 8:13 PM

DATE MODIFIED: 2/26/2016 8:13 PM

• The navigation buttons on a datasheet display the total number of fields in the datasheet.
• True
• False

ANSWER: False

POINTS: 1

REFERENCES: Access 14

Enter Data

QUESTION TYPE: True / False

HAS VARIABLES: False

LEARNING OBJECTIVES: ENHA.FRIE.16.009 - Navigate records in a datasheet

DATE CREATED: 2/26/2016 8:13 PM

DATE MODIFIED: 2/26/2016 8:13 PM

• Values in an AutoNumber field are automatically created by Access.
• True
• False

ANSWER: True

POINTS: 1

REFERENCES: Access 14

Enter Data

QUESTION TYPE: True / False

HAS VARIABLES: False

LEARNING OBJECTIVES: ENHA.FRIE.16.008 - Enter records in a datasheet

DATE CREATED: 2/26/2016 8:13 PM

DATE MODIFIED: 2/26/2016 8:13 PM

• The [F2] key switches between Edit and Navigation modes.
• True
• False

ANSWER: True

• / 4