Database Processing, 15e (Kroenke)
Appendix A: Getting Started with Microsoft Access 2016
1) Microsoft Access is a personal database that combines a DBMS with an application generator.
2) The Microsoft Access application generator provides the ability to create and store forms,
reports, and queries.
3) Microsoft Access 2016 databases are stored using the file extension .accdb.
4) Microsoft Access 2016 uses the Access 2003 .mdb file format as the default file format for
database files.
5) Microsoft Access uses the AutoNumber data type to create surrogate keys.
6) To start Microsoft Access 2016 in Windows 10, use the Start | All Programs | Microsoft
Office | Microsoft Access 2016 command.
7) Microsoft Access 2016 uses the Microsoft Office Fluent User Interface.
8) Most Microsoft Access 2016 commands and tools are available on the tabbed Ribbon.
9) The Microsoft Access 2016 tabbed Ribbon contains a set of control tabs.
10) Each Microsoft Access 2016 command tab contains a set of tools grouped into sets of related
commands.
11) The default Microsoft Access 2016 command tabs are HOME, CREATE, INTERNAL
DATA and DATABASE TOOLS.
12) In addition to the basic command tabs, Microsoft Access 2016 also has additional contextual
command tabs.
13) Microsoft uses the term object as a general name for various parts of a Microsoft Access
2016 database.
14) Microsoft Access database objects are displayed in the Browser Pane.
15) The Microsoft Access window Close button is actually a close-and-exit button.
16) In Microsoft Access, relationships between tables are created in the Relationships window.
17) In Microsoft Access, foreign keys are designated by using the Foreign Key button in the
toolbar.
18) In Microsoft Access, a relationship is created by dragging a foreign key column and
dropping it on top of the corresponding primary key.
4
19) Microsoft Access SQL commands are run within the SQL View of a Query window.
20) Microsoft Access can run QBE queries, but not SQL queries.
21) To open a new Microsoft Access Query window, click the Query Design button on the
Create command.
22) In Microsoft Access, the primary key must be set as a field property while the table is in
Design View.
23) Microsoft Access wizards allow easy building of forms and reports.
24) An SQL view involves saved SQL query.
25) When an SQL view is created it is based on ______.
A) a Report
B) an SQL query
C) a QBE query
D) both B and C are correct
26) Microsoft Access is a personal database system, and a personal database system is
characterized by ________.
A) the DBMS removing the metadata from the database
B) the DBMS product taking the role of the DBMS and the database application generator
C) the DBMS not supporting indexes
D) the DBMS product being limited to a maximum of ten tables in any given database
27) The Microsoft Access application generator is not responsible for ________.
A) creating forms
B) creating reports
C) creating queries
D) creating tables
28) Microsoft Access 2016 database files are stored using the file extension of ________.
A) .adb
B) .asp
C) .accdb
D) .mdb
29) The Microsoft Access data type of AutoNumber is used when there is a specific need for a
________.
A) foreign key
B) primary key
C) surrogate key
D) secondary key
30) To start Microsoft Access 2016 in Windows 10, use the command ________.
A) Start | Microsoft Access 2016
B) Start | Microsoft Office | Microsoft Access 2016
C) Start | All Programs | Microsoft Access 2016
D) No command—use the Microsoft Access 2016 app tile
31) The Microsoft Access 2016 Ribbon contains all of the following command tabs except
________.
A) HOME
B) SQL
C) EXTERNAL DATA
D) DATABASE TOOLS
32) In addition to the standard Ribbon command tabs, Microsoft Access 2016 also includes
________.
A) optional command tabs
B) contextual command tabs
C) quick access tabs
D) gallery tabs
33) Microsoft Access database objects are displayed in the ________.
A) Navigation Pane
B) Browser Pane
C) Object Browser Pane
D) Gallery Pane
34) The Microsoft Access 2016 Close button is actually a ________.
A) Save and Close button
B) Save and Exit button
C) Close and Exit button
D) Print and Close button
35) In Microsoft Access, relationships between tables are created ________.
A) by the Relationships button on the Create command tab
B) by the Relationships button on the Home command tab
C) in the Relationships window
D) in the Table window of the table containing the primary key
36) In Microsoft Access, any relationship between two tables is created ________.
A) by entering the name of the foreign key in the appropriate table in Design View
B) by dragging the primary key column of one table onto the primary key column of the other
table in the Relationships window
C) by dragging the primary key column of one table onto the foreign key column of the other
table in the Relationships window
D) by dragging the foreign key column of one table onto the primary key column of the other
table in the Relationships window
37) In Microsoft Access, referential integrity constraints are created ________.
A) by checking the Enforce Referential Integrity check box in the Edit Relationships dialog box
B) by setting a property value on the foreign key in the table which contains it
C) by setting a property value on the primary key in the Relationships window
D) by setting a property value on the foreign key in the Relationships window.
38) In Microsoft Access, the relationship between two tables is not actually created until
________.
A) the OK button in the Create Relationships dialog box is clicked
B) the Create button in the Create Relationships dialog box is clicked
C) the OK button in the Edit Relationships dialog box is clicked
D) the Create button in the Edit Relationships dialog box is clicked
39) Microsoft Access SQL commands are run in ________.
A) the SQL window
B) the QBE window
C) the SQL View of a Query window
D) the Design View of a Query window
40) To open a new Microsoft Access Query window ________.
A) click the New button on the Home command tab
B) click the New Query button on the Home command tab
C) click the Create Query button on the Create command tab
D) click the Query Design button on the Command tab
41) In Microsoft Access, tables are added to a Query window by ________.
A) selecting the tables from the Use Table dialog box
B) selecting the tables from the Show Table dialog box
C) selecting the tables from the Tables section of the Navigation Pane
D) selecting the tables from the Queries section of the Navigation Pane
42) Microsoft Access is a useful tool for forms and reports because ________.
A) the form and report generators do not exist within Access itself
B) Access forms and reports are very simplistic
C) Access wizards make it easy to create the forms and reports
D) Access has a version of Microsoft PowerPoint built into it to allow easy creation of
PowerPoint slide shows
43) Tables are created in Microsoft Access using the ________ button.
A) Table Design
B) Table Wizard
C) Create Table
D) Create Relation
44) In Microsoft Access 2016, the maximum length in characters of a “Short Text” data type
column is ________.
A) 25
B) 255
C) 65535
D) unlimited
45) Data in columns defined using which of the following data types in Microsoft Access cannot
be changed by the user?
A) Long Text
B) Date/Time
C) Number
D) AutoNumber
46) Each of the following is a way of inserting data into a Microsoft Access table except
________.
A) Datasheet view
B) a data entry form
C) QBE
D) SQL
47) Microsoft Access Datasheet view can be used for all of the following tasks except ________.
A) writing join queries
B) inserting new rows
C) updating existing rows
D) deleting rows
48) Microsoft Access is considered a “personal database” product. What is a personal database?
49) What Microsoft Access file format is used by default in Microsoft Access 2016? When was
it introduced, and what was the previous format?
50) What is the Microsoft Office Fluent User Interface?
51) Describe the tabbed Ribbon.
52) Describe the Microsoft Access 2016 Navigation Pane.
53) What is a surrogate key and how does Microsoft Access 2016 create surrogate keys?
54) Explain how to create a relationship in Microsoft Access. Include an example.
55) Explain how to run an SQL query in Microsoft Access.
56) Explain how to create an SQL view in Access 2016.