Full file at
Your Office: Microsoft Office 2013, Volume 1 (Kinser et al.)
Access Module 1 Workshop 1
1) Which of the following is NOT true regarding businesses and databases?
A) Records are collected and used for decision making, for sales and marketing, and for reporting purposes.
B) Businesses keep records about everything they do.
C) The purpose of a database is to store, manage, and provide access to the business records.
D) Today's businesses use automated databases to store their records and have completely eliminated paper-based systems.
Answer: D
Diff: 2 Page Ref: 588
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
2) Which of the following is NOT true about databases?
A) Databases are used for two major purposes: for operational processing and for analytical purposes.
B) The information in databases is summarized and classified to make data available to the decision makers.
C) In operational or transaction-based databases, each sale or transaction that a business makes is tracked.
D) Analytical databases are used for extracting data for decision making.
Answer: B
Diff: 2 Page Ref: 588
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
3) Which of the following is NOT an advantage that automated databases have over paper databases?
A) Without paper databases, a business cannot compete.
B) The information in databases is much easier to find in automated form.
C) The information in automated databasescan be manipulated and processed more rapidly.
D) Automated databases can be used to enforce accuracy and other quality standards.
Answer: A
Diff: 2 Page Ref: 588
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
4) You are reading a report that shows Company A generated $2,000 last week. This would be ______.
A) knowledge
B) a competitive advantage
C) data
D) information
Answer: D
Diff: 2 Page Ref: 588
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
5) ______is/are facts about people, events, things, or ideas.
A) Knowledge
B) A competitive advantage
C) Data
D) Information
Answer: C
Diff: 2 Page Ref: 588
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
6) Access is a(n) ______DBMS.
A) automated
B) linked
C) relational
D) form-based
Answer: C
Diff: 1 Page Ref: 588
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
7) A DBMS is a ______.
A) database Microsoft system
B) database management system
C) data manipulation system
D) database management service
Answer: B
Diff: 1 Page Ref: 588
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
8) Which of the following is NOT a reason to use Access?
A) Access is an easily available DBMS.
B) Access is often used by multiple users at the same time.
C) Access allows for easy interaction with other products in the Office suite.
D) Access allows you to create an app database and either give it to others or put it on the Windows App Store.
Answer: B
Diff: 2 Page Ref: 589
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
9) Which of the following is NOT a main object in an Access database?
A) table
B) script
C) query
D) report
Answer: B
Diff: 1 Page Ref: 589
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
10) Which of the following is NOT true about creating new databases?
A) When you create a new database, you can design it yourself starting with an empty database.
B) You can use a template; however, you need to create your own forms and reports.
C) If you design your own database, you develop the tables, fields, and the relationships between the tables.
D) If you build your own database, you need to decide what information you want to keep in your database, how this information should be grouped into tables, what relationships you need, and what queries and reports you need.
Answer: B
Diff: 2 Page Ref: 591
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
11) A ______is a structure of a database with tables, fields, forms, queries, and reports.
A) template
B) view
C) pattern
D) sample
Answer: A
Diff: 1 Page Ref: 591
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
12) Which of the following is NOT true about database templates?
A) You can download a wide variety of templates from Microsoft's website Office.com.
B) Templates are professionally designed databases that you can either use as is or adapt to suit your needs.
C) Microsoft provides sample database templates used for managing assets, contacts, issues, projects, and tasks.
D) A template is a sample database that has presupplied data
Answer: D
Diff: 2 Page Ref: 591
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
13) Which of the following should NOT be done if Access give you a security warning about your database?
A) Run a virus scan on any file before you say it should be trusted.
B) If you know the database is safe, you can trust a database permanently by storing it in a trusted location.
C) Do not click Enable Content in the security warning if you are not sure if the database is safe.
D) Enable the content. Nothing bad will happen, even if there is a virus embedded in the file.
Answer: D
Diff: 1 Page Ref: 592
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
14) When you open a database, Access displays the ______on the left side.
A) Navigation Pane
B) Property Sheet
C) Forms Pane
D) Shutter Bar Pane
Answer: A
Diff: 1 Page Ref: 592
Objective: Maneuver in the Navigation Pane
Text: Your Office: Microsoft Office 2013 Volume 1
15) The ______Bar Open/Close button at the top of the pane opens and closes the pane.
A) Navigation
B) Property
C) Forms
D) Shutter
Answer: D
Diff: 1 Page Ref: 592
Objective: Maneuver in the Navigation Pane
Text: Your Office: Microsoft Office 2013 Volume 1
16) The Navigation Pane allows for all of the following views except ______.
A) Custom
B) Object Type
C) Queries and Related Views
D) Created Date
Answer: C
Diff: 2 Page Ref: 593
Objective: Maneuver in the Navigation Pane
Text: Your Office: Microsoft Office 2013 Volume 1
17) To help you find ______, Access provides a Search box.
A) objects
B) Object Type
C) data
D) file extensions
Answer: A
Diff: 1 Page Ref: 593
Objective: Maneuver in the Navigation Pane
Text: Your Office: Microsoft Office 2013 Volume 1
18) Which of the following is NOT an Access file extension?
A) ACCDB
B) ACCDE
C) ACCDT
D) ACCTM
Answer: D
Diff: 1 Page Ref: 594
Objective: Maneuver in the Navigation Pane
Text: Your Office: Microsoft Office 2013 Volume 1
19) A(n) ______is the file extension for an Access 2002-2003 database file.
A) ACCDB
B) MDB
C) MDE
D) ACCDT
Answer: B
Diff: 1 Page Ref: 594
Objective: Maneuver in the Navigation Pane
Text: Your Office: Microsoft Office 2013 Volume 1
20) A(n) ______is the file extension for an Access 2007-2013 database template.
A) ACCDB
B) MDB
C) MDE
D) ACCDT
Answer: D
Diff: 1 Page Ref: 594
Objective: Maneuver in the Navigation Pane
Text: Your Office: Microsoft Office 2013 Volume 1
21) Which of the following is NOT true regarding tables and relational databases?
A) Tables store data organized in an arrangement of columns and rows.
B) Do not use special characters, such as an underscore, in table names.
C) The power of a relational database comes when you link tables.
D) A relational database is a database where data is stored in tables with relationships between the tables.
Answer: B
Diff: 1 Page Ref: 595-597
Objective: Understand What a Table Is
Text: Your Office: Microsoft Office 2013 Volume 1
22) How is Access different from Excel?
A) Access has numbered rows of data.
B) Access allows you to manage data, perform calculations, and report on the data.
C) Access allows multiple tables with relationships between the tables.
D) Access has columns with labels.
Answer: C
Diff: 1 Page Ref: 600
Objective: Understand What a Table Is
Text: Your Office: Microsoft Office 2013 Volume 1
23) Which of the following is NOT a problem that can be caused by using Excel to store data?
A) Loss of data
B) Errors in the data
C) Lack of functionality
D) Data redundancy
Answer: C
Diff: 1 Page Ref: 600
Objective: Manually Navigate a Database
Text: Your Office: Microsoft Office 2013 Volume 1
24) While Access allows you to leave several tables open at the same time, it is a good idea to get into the habit of ______a table when you are finished with it.
A) saving
B) closing
C) exporting
D) renaming
Answer: B
Diff: 1 Page Ref: 603
Objective: Manually Navigate a Database
Text: Your Office: Microsoft Office 2013 Volume 1
25) A ______is used to ask questions about your data.
A) table
B) query
C) form
D) report
Answer: B
Diff: 1 Page Ref: 603
Objective: Understand What a Query Is
Text: Your Office: Microsoft Office 2013 Volume 1
26) A(n) ______is a step-by-step guide that walks you through tasks by asking you questions to help you decide what you want to do.
A) AutoReport
B) form
C) AutoForm
D) wizard
Answer: D
Diff: 1 Page Ref: 604
Objective: Understand What a Query Is
Text: Your Office: Microsoft Office 2013 Volume 1
27) The ______row of the query design grid is the Field name.
A) top
B) second
C) third
D) bottom
Answer: A
Diff: 1 Page Ref: 607
Objective: Understand What a Query Is
Text: Your Office: Microsoft Office 2013 Volume 1
28) A ______provides another interface beyond the table in Datasheet view.
A) wizard
B) macro
C) form
D) report
Answer: C
Diff: 1 Page Ref: 611
Objective: Understand What a Form Is
Text: Your Office: Microsoft Office 2013 Volume 1
29) A ______provides an easy-to-read format suitable for printing.
A) wizard
B) macro
C) form
D) report
Answer: D
Diff: 1 Page Ref: 613
Objective: Understand What a Report Is
Text: Your Office: Microsoft Office 2013 Volume 1
30) ______shows how the report would look on the printed page and allows you to change the page layout.
A) Report view
B) Print Preview
C) Layout view
D) Design view
Answer: B
Diff: 1 Page Ref: 614
Objective: Understand What a Report Is
Text: Your Office: Microsoft Office 2013 Volume 1
31) ______shows how the report would look in a continuous page layout.
A) Report view
B) Print Preview
C) Layout view
D) Design view
Answer: A
Diff: 1 Page Ref: 614
Objective: Understand What a Report Is
Text: Your Office: Microsoft Office 2013 Volume 1
32) ______shows the report and the data; some report design such as field lengths and fonts can be changed in this view.
A) Report view
B) Print Preview
C) Layout view
D) Design view
Answer: C
Diff: 1 Page Ref: 614
Objective: Understand What a Report Is
Text: Your Office: Microsoft Office 2013 Volume 1
33) ______shows the report design but not the data.
A) Report view
B) Print Preview
C) Layout view
D) Design view
Answer: D
Diff: 1 Page Ref: 614
Objective: Understand What a Report Is
Text: Your Office: Microsoft Office 2013 Volume 1
34) The ______Wizard starts similarly to the Query Wizard in selecting fields for the report.
A) Table
B) Report
C) Form
D) Design
Answer: B
Diff: 1 Page Ref: 614
Objective: Understand What a Report Is
Text: Your Office: Microsoft Office 2013 Volume 1
35) Which of the following is NOT true regarding a backup database?
A) The backup copy is as current as your real database, and saves you from having to recreate your database.
B) A backup database is an extra copy of your database that you can use to protect yourself from the accidental loss of your database.
C) Backups can help in cases of accidental deletion of data.
D) You can return to the backup copy if you accidentally delete the real database.
Answer: A
Diff: 2 Page Ref: 617
Objective: Back Up a Database
Text: Your Office: Microsoft Office 2013 Volume 1
36) Which of the following is NOT true when creating a backup database?
A) In Access, you make backups by using the Back Up Database command.
B) The Back Up Database command is available on Backstage view under Export.
C) If you make multiple backup copies, you should give them different names.
D) If you ever need a backup, simply return to the most recent copy that you have and start working with that file.
Answer: B
Diff: 2 Page Ref: 617
Objective: Back Up a Database
Text: Your Office: Microsoft Office 2013 Volume 1
37) ______rearranges objects to use disk space more efficiently, thus releasing the now unused space to be used again.
A) Backups
B) Reports
C) Queries
D) Compacting
Answer: D
Diff: 1 Page Ref: 618
Objective: Compact a Database
Text: Your Office: Microsoft Office 2013 Volume 1
38) There are ______options for compacting a database.
A) two
B) three
C) four
D) five
Answer: A
Diff: 1 Page Ref: 618
Objective: Compact a Database
Text: Your Office: Microsoft Office 2013 Volume 1
39) You can perform ______Compact and Repair Database action at any time.
A) one
B) two
C) three
D) four
Answer: A
Diff: 1 Page Ref: 618
Objective: Compact a Database
Text: Your Office: Microsoft Office 2013 Volume 1
40) If you select ______, Access automatically compacts your database anytime you close it.
A) Compact Now
B) Compact on Exit
C) Compact on Close
D) Compact and Repair Database
Answer: C
Diff: 1 Page Ref: 618
Objective: Compact a Database
Text: Your Office: Microsoft Office 2013 Volume 1
41) A database is a collection of records that are used for decision making, for sales and marketing, and for reporting purposes.
Answer: TRUE
Diff: 1 Page Ref: 588
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
42) Information includes facts about people, events, things, or ideas, and they are an important asset to any organization as information allows companies to make better business decisions.
Answer: FALSE
Diff: 1 Page Ref: 588
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
43) Data is information that has been manipulated and processed to make it meaningful.
Answer: FALSE
Diff: 1 Page Ref: 588
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
44) Access is a relational DBMS program created by Microsoft.
Answer: TRUE
Diff: 1 Page Ref: 588
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
45) The power of a database system comes with the ability to link tables together.
Answer: TRUE
Diff: 1 Page Ref: 588
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
46) What you learn about Access is transferable to other relational DBMSs.
Answer: TRUE
Diff: 1 Page Ref: 589
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
47) Access is often used as a stand-alone DBMS, meaning a DBMS used by multiple users.
Answer: FALSE
Diff: 1 Page Ref: 589
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
48) Access allows you to create an app database and either give it to others or put it on the Windows App Store.
Answer: TRUE
Diff: 1 Page Ref: 589
Objective: Understand What Access Is
Text: Your Office: Microsoft Office 2013 Volume 1
49) Design view of a table shows the data contents within a table.
Answer: FALSE
Diff: 1 Page Ref: 589
Objective: Understand What a Table Is
Text: Your Office: Microsoft Office 2013 Volume 1
50) Design view shows how fields are defined and structured.
Answer: FALSE
Diff: 1 Page Ref: 589
Objective: Understand What a Table Is
Text: Your Office: Microsoft Office 2013 Volume 1
51) Each row in an Access table is called a record.
Answer: TRUE
Diff: 1 Page Ref: 590
Objective: Understand What a Table Is
Text: Your Office: Microsoft Office 2013 Volume 1
52) A record is all of the data pertaining to one person, place, thing, or event.
Answer: TRUE
Diff: 1 Page Ref: 590
Objective: Understand What a Table Is
Text: Your Office: Microsoft Office 2013 Volume 1
53) Each column in Access is called a field.
Answer: TRUE
Diff: 1 Page Ref: 591
Objective: Understand What a Table Is
Text: Your Office: Microsoft Office 2013 Volume 1
54) When you open a database, Access displays the Navigation Pane on the right side.
Answer: FALSE
Diff: 1 Page Ref: 592
Objective: Manually Navigate a Database
Text: Your Office: Microsoft Office 2013 Volume 1
55) The Shutter Bar Open/Close button at the top of the Navigation Pane and opens and closes the pane.
Answer: TRUE
Diff: 1 Page Ref: 592
Objective: Manually Navigate a Database
Text: Your Office: Microsoft Office 2013 Volume 1
56) A file extension is the suffix on all file names that helps Windows understand what information is in a file and what program should open the file.
Answer: TRUE
Diff: 1 Page Ref: 594
Objective: Manually Navigate a Database
Text: Your Office: Microsoft Office 2013 Volume 1
57) Importing is the process of copying data from another file, such as a Word file or Excel workbook, into a separate file, such as an Access database.
Answer: TRUE
Diff: 1 Page Ref: 595
Objective: Understand What a Table Is
Text: Your Office: Microsoft Office 2013 Volume 1
58) At the top of the table, Access provides a Navigation bar that allows you to move through the table.
Answer: FALSE
Diff: 1 Page Ref: 598
Objective: Understand What a Table Is
Text: Your Office: Microsoft Office 2013 Volume 1
59) A wizard is a step-by-step guide that walks you through tasks by asking you questions to help you decide what you want to do.
Answer: TRUE
Diff: 1 Page Ref: 604
Objective: Understand What a Query Is
Text: Your Office: Microsoft Office 2013 Volume 1
60) Query results are a recordset that provide an answer to a question posed in a query.
Answer: TRUE
Diff: 1 Page Ref: 606
Objective: Understand What a Query Is
Text: Your Office: Microsoft Office 2013 Volume 1
61) Query results show records and fields created at recordset time, which means that the results are created each time you run the query.
Answer: FALSE
Diff: 1 Page Ref: 606
Objective: Understand What a Query Is
Text: Your Office: Microsoft Office 2013 Volume 1
62) The Query Wizard uses a question-and-answer dialog box to create a query.
Answer: TRUE
Diff: 1 Page Ref: 607
Objective: Understand What a Query Is
Text: Your Office: Microsoft Office 2013 Volume 1
63) You can use Backstage view to modify an existing query.
Answer: FALSE
Diff: 2 Page Ref: 607
Objective: Understand What a Query Is
Text: Your Office: Microsoft Office 2013 Volume 1