100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Illustrated Microsoft® Office 365 & Office 2016 Introductory 1st Edition By David Beskeen, Carol M. Cram, Jennifer Duffy, (Test Bank) $22.49   Add to cart

Exam (elaborations)

Illustrated Microsoft® Office 365 & Office 2016 Introductory 1st Edition By David Beskeen, Carol M. Cram, Jennifer Duffy, (Test Bank)

 6 views  0 purchase
  • Course
  • Illustrated Microsoft® Office 365 & Office 2016, I
  • Institution
  • Illustrated Microsoft® Office 365 & Office 2016, I

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

Preview 4 out of 583  pages

  • July 6, 2023
  • 583
  • 2022/2023
  • Exam (elaborations)
  • Questions & answers
  • Illustrated Microsoft® Office 365 & Office 2016, I
  • Illustrated Microsoft® Office 365 & Office 2016, I
avatar-seller
tutorsection
(Illustrated Microsoft® Office 365 & Office 2016, Introductory, 1e David Beskeen, Carol M. Cram, Jennifer Duffy

(Test Bank all Chapters)

Access 2016 - Module 1: Getting Started with Access
1. More than one person can enter, update, and analyze data in an Access database at the same time.
a. True
b. 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

2. Access databases cannot be password protected.
a. True
b. 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

3. An Access database is limited to a size of 1 gigabyte.
a. True
b. 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

4. Tables contain all of the data in the database.
a. True
b. False
ANSWER: True
POINTS: 1

Copyright Cengage Learning. Powered by Cognero. Page 1

,Name: Class: Date:

Access 2016 - Module 1: Getting Started with Access
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

5. 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.
a. True
b. 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

6. A primary key field uniquely identifies each record.
a. True
b. 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

7. No two records can have the same value in the primary key field.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 10
Create Primary Keys
QUESTION TYPE: True / False

Copyright Cengage Learning. Powered by Cognero. Page 2

,Name: Class: Date:

Access 2016 - Module 1: Getting Started with Access
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

8. Field properties change depending on the data type of the field.
a. True
b. 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

9. The linking field on the “many” side of a one-to-many relationship is called the foreign key field.
a. True
b. 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

10. A subdatasheet shows the records on the “many” side of a one-to-many relationship.
a. True
b. 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
Copyright Cengage Learning. Powered by Cognero. Page 3

, Name: Class: Date:

Access 2016 - Module 1: Getting Started with Access
11. “Focus” refers to which data you would edit if you started typing.
a. True
b. 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

12. The navigation buttons on a datasheet display the total number of fields in the datasheet.
a. True
b. 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

13. Values in an AutoNumber field are automatically created by Access.
a. True
b. 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

14. The [F2] key switches between Edit and Navigation modes.
a. True
b. False
ANSWER: True

Copyright Cengage Learning. Powered by Cognero. Page 4

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller tutorsection. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $22.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

75323 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$22.49
  • (0)
  Add to cart