100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
TEST BANK for; New Perspectives Microsoft Office 365 & Access 2016: Introductory 1st Edition. by Mark Shellman and Sasha Vodnik. Contains Questions and Answers on: Access Module 01: Creating a Database, Access Module 02: Building a Database and Defining T $23.49
Add to cart

Exam (elaborations)

TEST BANK for; New Perspectives Microsoft Office 365 & Access 2016: Introductory 1st Edition. by Mark Shellman and Sasha Vodnik. Contains Questions and Answers on: Access Module 01: Creating a Database, Access Module 02: Building a Database and Defining T

 0 purchase

TEST BANK for; New Perspectives Microsoft Office 365 & Access 2016: Introductory 1st Edition. by Mark Shellman and Sasha Vodnik. Contains Questions and Answers on: Access Module 01: Creating a Datab a se, Access Module 02: Building a Database and Defining Table Relationships, Access Module 03: Main...

[Show more]

Preview 4 out of 50  pages

  • August 4, 2021
  • 50
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
All documents for this subject (95)
avatar-seller
Succeed
,Name: Class: Date:

Access Module 01: Creating a Database

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:

Access Module 01: Creating a Database
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:

Access Module 01: Creating a Database
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

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 EFT, 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 this summary from?

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

Will I be stuck with a subscription?

No, you only buy this summary for $23.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

65352 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy summaries for 15 years now

Start selling

Recently viewed by you


Package deal ·

(0)

Exam 1, Exam 2, Exam 3, Exam 4 & HESI Final: NSG121 / NSG 121 (Latest 2024 / 2025 Updates BUNDLED TOGETHER WITH COMPLETE SOLUTIONS) Health Assessment | Reviews with Questions and Verified Answers | 10

Exam (elaborations) ·

(0)

BRANCH 3 STRUCTURAL PEST CONTROL EXAM 2024 WITH ACTUAL CORRECT QUESTUINS AND VERIFIED DETAILED ANSWERS BT EXPERTS |FREQUENTLY TESTED QUESTIONS AND SOLUTIONS |ALREADY GRADED A+ |NEWEST|GUARANTEED

Exam (elaborations) ·

(0)

Introduction to Personal Finance: Beginning Your Financial Journey 2nd Edition by Palmer and Grable | All 10 Chapters | SOLUTIONS MANUAL

Exam (elaborations) ·

(0)

PGA Professional Golfers' Association PGM Professional Golf Management. 2024-2025 Professional Golf Management PGA PGM Associate Qualifying Level - 5 Course Prep Exam Questions and Answers | 100% Pass

Package deal ·

(0)

NRNP 6670/NRNP6670 Midterm Exam Questions With Answers | NRNP 6670 Final Exam Practice Questions Latest 2023/2024 & NRNP 6670/NRNP6670 Midterm Exam Questions With 100% Correct Answers Latest Updated (

Package deal ·

(0)

Legal Issues in Sport SPM 4723 Exam 1 Review|SPM4723 Legal Issues in Sports Exam II|SPM4723 - Legal Issues in Sport Exam III |SPM4723- Legal Issue in Sports FINAL EXAM | (All Answered With Complete Ve

Package deal ·

(0)

Weeks 5 - 8 Final Exam: NR568 / NR 568 Advanced Pharmacology for the Adult-Gerontology Primary Care Nurse Practitioner Exam (Latest 2024 / 2025 Updates STUDY BUNDLE WITH COMPLETE SOLUTIONS) | 100% Cor

Exam (elaborations) ·

(0)

EXTENSIVE; (MOST RECENT) RN FUNDAMENTALS| ATI RN FUNDAMENTALS |HESI RN FUNDAMENTALS | ATI LEARNING SYSTEM RN 3.0 FUNDAMENTALS | RN VATI FUNDAMENTALS |QUESTIONS ALL WITH CORRECT ANSWERS|VERIFIED AND 10

Exam (elaborations) ·

(0)

NURS-6521N Week 1 Quiz, NURS-6521N Week 2 Quiz, NURS-6521N Week 3 Quiz, NURS-6521N Week 4 Quiz, NURS-6521N Week 5 Quiz, NURS-6521N Week 6 Quiz, NURS-6521N Week 7 Quiz, NURS-6521N Week 8, 9, 10, 11 Qui

$23.49
  • (0)
Add to cart
Added