Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Access 2013: Introduction and Learning Objectives, Slides of Design

Design

A series of questions and answers about Access 2013, including topics such as relational database concepts, opening and defining Access objects, creating tables, and entering records. The learning objectives cover various aspects of using Access for database management, such as setting the primary key field, identifying Access components, and defining key database terms.

Typology: Slides

2021/2022

Uploaded on 09/27/2022

anandit
anandit 🇺🇸

4.8

(19)

255 documents

1 / 14

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Name:
Class:
Date:
Access 2013 Unit A: Getting Started with Access 2013
Cengage Learning Testing, Powered by Cognero
Page 1
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:
OFIN.BESK.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:
BESK.OFIN.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:
BESK.OFIN.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:
BESK.OFIN.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:
BESK.OFIN.16.005 - Set the primary key field
6. No two records can have the same value in the primary key field.
a.
True
b.
False
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe

Partial preview of the text

Download Access 2013: Introduction and Learning Objectives and more Slides Design in PDF only on Docsity!

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: OFIN.BESK.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: BESK.OFIN.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: BESK.OFIN.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: BESK.OFIN.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: BESK.OFIN.16.005 - Set the primary key field
  6. No two records can have the same value in the primary key field. a. True b. False

Access 2013 Unit A: Getting Started with Access 2013

ANSWER: True POINTS: 1 REFERENCES: Access 10 LEARNING OBJECTIVES: BESK.OFIN.16.005 - Set the primary key field

  1. Field properties change depending on the data type of the field. a. True b. False ANSWER: True POINTS: 1 REFERENCES: Access 11 LEARNING OBJECTIVES: BESK.OFIN.16.005 - Set the primary key field
  2. 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: BESK.OFIN.16.006 - Create one-to-many relationships
  3. 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: BESK.OFIN.16.007 - Define common field and foreign key field
  4. “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: BESK.OFIN.16.008 - Enter records in a datasheet
  5. 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

Access 2013 Unit A: Getting Started with Access 2013

b. It relates lists of information in a relational database. c. Reporting is limited to 20 saved reports. d. Multiple users can simultaneously enter and update data within Access. ANSWER: c POINTS: 1 REFERENCES: Access 3 LEARNING OBJECTIVES: BESK.OFIN.16.002 - Describe relational database concepts

  1. Tables, queries, and forms are examples of Access ____. a. entities b. objects c. values d. controls ANSWER: b POINTS: 1 REFERENCES: Access 4 LEARNING OBJECTIVES: BESK.OFIN.16.003 - Open and define Access objects
  2. Which of the following is NOT available to you as you start Access? a. opening an existing database b. recalibrating an existing database c. creating a new database from a template d. creating a new blank database ANSWER: b POINTS: 1 REFERENCES: Access 4 LEARNING OBJECTIVES: BESK.OFIN.16.011 - Start Access and open a database
  3. Which Access object provides an easy-to-use data entry screen? a. macro b. form c. table d. module ANSWER: b POINTS: 1 REFERENCES: Access 5 LEARNING OBJECTIVES: BESK.OFIN.16.012 - Identify Access components

Access 2013 Unit A: Getting Started with Access 2013

  1. The Forms and Reports at the left side of the Access window in the accompanying figure are contained in the ____. a. Pinned space b. Navigation Pane c. Objects Bar d. Objects Tab ANSWER: b POINTS: 1 REFERENCES: Access 5 LEARNING OBJECTIVES: BESK.OFIN.16.012 - Identify Access components
  2. In the accompanying figure, the rightmost TourSales tab is a ____ tab. a. report b. query c. form d. table ANSWER: a POINTS: 1 REFERENCES: Access 5 LEARNING OBJECTIVES: BESK.OFIN.16.003 - Open and define Access objects
  3. In the accompanying figure, CustomerRoster is a ____ tab. a. report b. query c. form d. table ANSWER: c POINTS: 1 REFERENCES: Access 5 LEARNING OBJECTIVES: BESK.OFIN.16.003 - Open and define Access objects

Access 2013 Unit A: Getting Started with Access 2013

ANSWER: b POINTS: 1 REFERENCES: Access 7 LEARNING OBJECTIVES: BESK.OFIN.16.014 - Define key database terms

  1. Which data type is used for sequential integers controlled by Access? a. Hyperlink b. Web c. Lookup Wizard d. AutoNumber ANSWER: d POINTS: 1 REFERENCES: Access 7 LEARNING OBJECTIVES: BESK.OFIN.16.014 - Define key database terms
  2. Which data type stores only one of two values? a. Attachment b. Hyperlink c. Yes/No d. Null ANSWER: c POINTS: 1 REFERENCES: Access 7 LEARNING OBJECTIVES: BESK.OFIN.16.014 - Define key database terms
  3. Which data type links files created in other programs such as pictures or documents? a. Lookup b. Attachment c. Yes/No d. Link Wizard ANSWER: b POINTS: 1 REFERENCES: Access 7 LEARNING OBJECTIVES: BESK.OFIN.16.014 - Define key database terms
  4. Which data type stores Web addresses? a. Lookup Wizard b. Hyperlink c. URL d. HTML ANSWER: b POINTS: 1 REFERENCES: Access 7 LEARNING OBJECTIVES: BESK.OFIN.16.014 - Define key database terms
  5. A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____. a. object b. record c. field d. table ANSWER: c POINTS: 1 REFERENCES: Access 9

Access 2013 Unit A: Getting Started with Access 2013

LEARNING OBJECTIVES: BESK.OFIN.16.015 - Create a table in Table Design View

  1. A group of related fields, such as all the demographic information for one customer, is called a(n) ____. a. record b. table c. database d. object ANSWER: a POINTS: 1 REFERENCES: Access 9 LEARNING OBJECTIVES: BESK.OFIN.16.015 - Create a table in Table Design View
  2. Which two properties are required for every field? a. Field Name and Data Type b. Field Name and Field Size c. Data Type and Format d. Field Size and Format ANSWER: a POINTS: 1 REFERENCES: Access 11 LEARNING OBJECTIVES: BESK.OFIN.16.016 - Define one-to-many relationships
  3. ____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy. a. Hierarchical b. Network c. Schematic d. Referential ANSWER: d POINTS: 1 REFERENCES: Access 12 LEARNING OBJECTIVES: BESK.OFIN.16.017 - Set referential integrity
  4. In a datasheet, which mode assumes that you are trying to change the value of a particular field? a. Edit mode b. Navigation mode c. Update mode d. Form mode ANSWER: a POINTS: 1 REFERENCES: Access 14 LEARNING OBJECTIVES: BESK.OFIN.16.008 - Enter records in a datasheet
  5. In Navigation mode, press [Tab] or ____ to move to the next field within the same record. a. [End] b. [Page Down] c. [Down Arrow] d. [Enter] ANSWER: d POINTS: 1 REFERENCES: Access 14 LEARNING OBJECTIVES: BESK.OFIN.16.009 - Navigate records in a datasheet
  6. Which shortcut key moves focus to the previous field of the current record? a. [Home] b. [Shift][Tab]

Access 2013 Unit A: Getting Started with Access 2013

ANSWER: d POINTS: 1 REFERENCES: Access 17 LEARNING OBJECTIVES: BESK.OFIN.16.019 - Delete records in a datasheet

  1. Which editing keystroke deletes one character to the right of the insertion point? a. [Backspace] b. [Delete] c. [F2] d. [F7] ANSWER: b POINTS: 1 REFERENCES: Access 17 LEARNING OBJECTIVES: BESK.OFIN.16.019 - Delete records in a datasheet
  2. Relational ____________________ software is used to manage data that can be organized into lists, such as information about customers, products, vendors, employees, projects, or sales. ANSWER: database POINTS: 1 REFERENCES: Access 2 LEARNING OBJECTIVES: BESK.OFIN.16.002 - Describe relational database concepts
  3. A(n) ____________________ is a fundamental building block of a relational database because this object stores all of the data. ANSWER: table POINTS: 1 REFERENCES: Access 4 LEARNING OBJECTIVES: BESK.OFIN.16.012 - Identify Access components
  4. A(n) ____________________ object allows a user to select a subset of data from one or more tables. ANSWER: query POINTS: 1 REFERENCES: Access 4 LEARNING OBJECTIVES: BESK.OFIN.16.012 - Identify Access components
  5. A(n) ____________________ object provides an easy-to-use data entry screen. ANSWER: form POINTS: 1 REFERENCES: Access 5 LEARNING OBJECTIVES: BESK.OFIN.16.012 - Identify Access components
  6. ____________________ View is a spreadsheet-like view of the data in a table. ANSWER: Datasheet POINTS: 1 REFERENCES: Access 6 LEARNING OBJECTIVES: BESK.OFIN.16.020 - Create a database

Access 2013 Unit A: Getting Started with Access 2013

  1. If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors. ANSWER: Design POINTS: 1 REFERENCES: Access 8 LEARNING OBJECTIVES: BESK.OFIN.16.015 - Create a table in Table Design View
  2. A(n) ____________________ key field contains unique data for each record. ANSWER: primary POINTS: 1 REFERENCES: Access 8 LEARNING OBJECTIVES: BESK.OFIN.16.015 - Create a table in Table Design View
  3. A(n) ____________________ relationship describes when a record from one table is related to several records in another table. ANSWER: one to many one-to-many 1 to many 1 - to-many POINTS: 1 REFERENCES: Access 12 LEARNING OBJECTIVES: BESK.OFIN.16.006 - Create one-to-many relationships
  4. The ____________________ refers to which data you would edit if you started typing. ANSWER: focus POINTS: 1 REFERENCES: Access 14 LEARNING OBJECTIVES: BESK.OFIN.16.008 - Enter records in a datasheet
  5. A(n) ____________________ field automatically assigns a new number each time you add a record. ANSWER: AutoNumber POINTS: 1 REFERENCES: Access 14 LEARNING OBJECTIVES: BESK.OFIN.16.008 - Enter records in a datasheet
  6. What are the advantages of using Access for database management? ANSWER: 1. Duplicate data is minimized.
    1. Information is more accurate, reliable, and consistent because duplicate data is minimized.
    2. Data entry is faster and easier using Access forms.
    3. Information can be viewed and sorted in multiple ways using Access queries, forms, and reports.
    4. Information is more secure using Access passwords and security features.
    5. Several users can share and edit information at the same time. POINTS: 1 REFERENCES: Access 2

Access 2013 Unit A: Getting Started with Access 2013

  1. To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator.

ANSWER: False - double-click POINTS: 1 REFERENCES: Access 17 LEARNING OBJECTIVES: BESK.OFIN.16.018 - Preview and print a datasheet Critical Thinking Questions Case 1 - 1 Hannah wants to create a record keeping system to track the inventory needed to efficiently run her lawn and landscape business, such as spare parts, gas cans, string trimmers, etc. Her crew manager will also be using the system.

  1. Hannah is considering whether to use Excel or Access. Which one of the following is NOT a benefit of using Access? a. More data storage c. Easier setup b. Multiuser capability d. Additional reporting features ANSWER: C POINTS: 1 REFERENCES: Access 3 LEARNING OBJECTIVES: BESK.OFIN.16.021 - AB TOPICS: Critical Thinking Critical Thinking Questions Case 1 - 2 Lauren wants to create an Access database of the musical instruments she owns.
  2. A Purchase Price field should be which data type? a. Text c. Monetary b. Number d. Currency ANSWER: D POINTS: 1 REFERENCES: Access 7 LEARNING OBJECTIVES: BESK.OFIN.16.014 - Define key database terms TOPICS: Critical Thinking
  3. Lauren has written a paragraph describing the use for each inventory item. Which data type should she use to define the field that will store this information? a. Paragraph c. Long Text b. Comment d. System ANSWER: C POINTS: 1 REFERENCES: Access 7 LEARNING OBJECTIVES: BESK.OFIN.16.014 - Define key database terms TOPICS: Critical Thinking

Access 2013 Unit A: Getting Started with Access 2013

Match the shortcut keystrokes to the correct action. a. [Left Arrow] b. [Tab] c. [Up Arrow] d. [Ctrl][End] e. [Home] f. [End] g. [Down Arrow] h. [Ctrl][Home] REFERENCES: Access 15 LEARNING OBJECTIVES: BESK.OFIN.16.009 - Navigate records in a datasheet

  1. Last field of the last record ANSWER: d POINTS: 1
  2. Current field of the previous record ANSWER: c POINTS: 1
  3. First field of the first record ANSWER: h POINTS: 1
  4. Current field of the next record ANSWER: g POINTS: 1
  5. First field of the current record ANSWER: e POINTS: 1
  6. Next field of the current record ANSWER: b POINTS: 1
  7. Last field of the current record ANSWER: f POINTS: 1
  8. Previous field of the current record ANSWER: a POINTS: 1