Access 2013 Unit A: Getting Started with Access 2013
1. More than one person can be entering, updating, and using an Access database at the same time.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 2
LEARNING OBJECTIVES: ENHC.PARS.16.001 - Explain when to use a database
2. An Access database is limited to a size of 1 gigabyte.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: Access 3
LEARNING OBJECTIVES: ENHC.PARS.16.002 - Describe relational database concepts
3. Tables contain all of the data in the database.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 5
LEARNING OBJECTIVES: ENHC.PARS.16.003 - Open and define Access objects
4. 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
LEARNING OBJECTIVES: ENHC.PARS.16.004 - Set appropriate data types for fields
5. A primary key field uniquely identifies each record.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 10
LEARNING OBJECTIVES: ENHC.PARS.16.005 - Set the primary key field
6. No two records can have the same value in the primary key field.
a. True
Cengage Learning Testing, Powered by Cognero Page 1
,Name Clas Dat
: s: e:
Access 2013 Unit A: Getting Started with Access 2013
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 10
LEARNING OBJECTIVES: ENHC.PARS.16.005 - Set the primary key field
7. Field properties change depending on the data type of the field.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 11
LEARNING OBJECTIVES: ENHC.PARS.16.005 - Set the primary key field
8. 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
LEARNING OBJECTIVES: ENHC.PARS.16.006 - Create one-to-many relationships
9. 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
LEARNING OBJECTIVES: ENHC.PARS.16.007 - Define common field and foreign key field
10. “Focus” refers to which data you would edit if you started typing.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 14
LEARNING OBJECTIVES: ENHC.PARS.16.008 - Enter records in a datasheet
11. The navigation buttons on a datasheet display the total number of fields in the datasheet.
a. True
b. False
ANSWER: False
Cengage Learning Testing, Powered by Cognero Page 2
, Name Clas Dat
: s: e:
Access 2013 Unit A: Getting Started with Access 2013
POINTS: 1
REFERENCES: Access 14
LEARNING OBJECTIVES: ENHC.PARS.16.009 - Navigate records in a datasheet
12. Values in an AutoNumber field are automatically created by Access.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 14
LEARNING OBJECTIVES: ENHC.PARS.16.008 - Enter records in a datasheet
13. The [F2] key switches between Edit and Navigation modes.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 17
LEARNING OBJECTIVES: ENHC.PARS.16.010 - Edit data in a datasheet
14. Press [Esc] once to undo a change to the current field.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 17
LEARNING OBJECTIVES: ENHC.PARS.16.010 - Edit data in a datasheet
15. Pressing [Ctrl][;] will insert the current date in a Date field.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 17
LEARNING OBJECTIVES: ENHC.PARS.16.010 - Edit data in a datasheet
16. Microsoft Access can best be described as ____ software.
a. spreadsheet b. presentation
c. database d. systems
ANSWER: c
POINTS: 1
REFERENCES: Access 2
Cengage Learning Testing, Powered by Cognero Page 3
The benefits of buying summaries with Stuvia:
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
You can quickly pay through credit card for the summaries. There is no membership needed.
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 premiumbiz379. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £20.49. You're not tied to anything after your purchase.