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 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 Succeed. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

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

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

64302 documents were sold in the last 30 days

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

Start selling

Recently viewed by you


Package deal ·

(0)

BLS Quiz Questions and answers correct/verified download red cross/bls cpr/exam/correct answers verified 100% basic life support exam a/BLS CPR exam/verified questions and answers HSI YMCA BLS EXAM -

Exam (elaborations) ·

(0)

NURS 6531 FINAL EXAMS 2024 (3 VERSIONS) WEEK 11 SPRING QTR WITH ALL 300 QUESTIONS AND CORRECT ANSWERS ALREADY GRADED A+ WALDEN UNIVERSITY/ NURS 6531 ADVANCED PRACTICE CARE OF ADULTS LATEST FINAL EXA

Exam (elaborations) ·

(0)

Test Bank For Lehne’s Pharmacotherapeutics for Advanced Practice Nurses and Physician Assistants 2nd Edition by Jacqueline Burchum; Laura D. Rosenthal | 9780323554954 | Chapter 1-92 | Complete Ques

Package deal ·

(0)

2024 Bundle ATSSA ( Flagger Test, TCS Module 5 Positive Protection Devices , Traffic Control Supervisor - The Typical Project Module 7 , Re-certification (missing some basics)) Passed | A+ Rated Gui

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)

Test Bank For Nutritional Foundations and Clinical Applications A Nursing Approach 8th Edition By Michele Grodner; Sylvia Escott-Stump; Suzanne Dorner 9780323810241 / Chapter 1-20 / Complete Questions

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)

2024 LATEST ATLS EXAMS COMPREHENSIVE TEST BANK WITH OVER 500 QUESTIONS AND VERIFIED CORRECT ANSWERS | ACHIEVE A+ WITH CONFIDENCE | ULTIMATE PRE-TEST AND POST-TEST ACTUAL EXAMS FOR GUARANTEED SUCCE

Exam (elaborations) ·

(0)

Maternal Child Nursing Final Exam (TEST BANK Questions- Canadian Maternity and Pediatric Nursing 2nd ed. (Ricci et al) Chapters 30, 31, 32, 33, 34, 35, 36, 37, 38, 40, 41, 42, 43, 44, 46, 48, 49) Ques

$23.49
  • (0)
Add to cart
Added