Microsoft Access Exam Review UPDATED
Exam Questions and CORRECT Answers
Backstage View - CORRECT ANSWER - Enables you to create a new database, create a
database from a template, open an existing database, view and edit database properties, manage
user accounts, and perform many database maintenance tasks
Badges - CORRECT ANSWER - Small square labels that contains KeyTips
Change Help Location Menu - CORRECT ANSWER - A menu that enables you to choose
between searching help topics online and help topics offline
Database - CORRECT ANSWER - A tool for collecting and organizing information
Database Management System (DBMS) - CORRECT ANSWER - A system for managing
data that allow the user to store, retrieve, and analyze information
Datasheet - CORRECT ANSWER - A visual representation of the data continued in a table
or of the results returned by a query
Data Type - CORRECT ANSWER - The kind of information a field contains- whether
text, number, date/time, or some other type
Dialogue Box Launcher - CORRECT ANSWER - A small arrow in the lower-right corner
of a group that you click to launch a dialog box
Field - CORRECT ANSWER - A column in a database table
, File Tab - CORRECT ANSWER - A tab that displays the backstage view and contains a
menu of commands that you can use for the common tasks performed with your database files-
such as opening, saving, and printing
Form - CORRECT ANSWER - A database object that simplifies the process of entering,
editing, and displaying data.
Groups - CORRECT ANSWER - Collection of records separated visually and displayed
with its introductory or summary information
KeyTips - CORRECT ANSWER - Small letters and numbers that display on the ribbon
when you press Alt Key; used for executing commands with the keyboard
Normal Forms - CORRECT ANSWER - The standards and guidelines of database design
that can be used to determine if a database is structured correctly
Normalization - CORRECT ANSWER - The process of applying rules to a database
design to ensure that information is divided into the appropriate tables
Objects - CORRECT ANSWER - Database elements, such as tables, queries, forms, and
reports
Primary key - CORRECT ANSWER - The column in a database that uniquely identifies
each record (row)
Query - CORRECT ANSWER - A database object that enables stored data to be searched
and retrieved
Quick Access Toolbar - CORRECT ANSWER - A toolbar at the top left of the screen that
contains the command that you use most often- such as Save, Undo, Redo, and Print
Exam Questions and CORRECT Answers
Backstage View - CORRECT ANSWER - Enables you to create a new database, create a
database from a template, open an existing database, view and edit database properties, manage
user accounts, and perform many database maintenance tasks
Badges - CORRECT ANSWER - Small square labels that contains KeyTips
Change Help Location Menu - CORRECT ANSWER - A menu that enables you to choose
between searching help topics online and help topics offline
Database - CORRECT ANSWER - A tool for collecting and organizing information
Database Management System (DBMS) - CORRECT ANSWER - A system for managing
data that allow the user to store, retrieve, and analyze information
Datasheet - CORRECT ANSWER - A visual representation of the data continued in a table
or of the results returned by a query
Data Type - CORRECT ANSWER - The kind of information a field contains- whether
text, number, date/time, or some other type
Dialogue Box Launcher - CORRECT ANSWER - A small arrow in the lower-right corner
of a group that you click to launch a dialog box
Field - CORRECT ANSWER - A column in a database table
, File Tab - CORRECT ANSWER - A tab that displays the backstage view and contains a
menu of commands that you can use for the common tasks performed with your database files-
such as opening, saving, and printing
Form - CORRECT ANSWER - A database object that simplifies the process of entering,
editing, and displaying data.
Groups - CORRECT ANSWER - Collection of records separated visually and displayed
with its introductory or summary information
KeyTips - CORRECT ANSWER - Small letters and numbers that display on the ribbon
when you press Alt Key; used for executing commands with the keyboard
Normal Forms - CORRECT ANSWER - The standards and guidelines of database design
that can be used to determine if a database is structured correctly
Normalization - CORRECT ANSWER - The process of applying rules to a database
design to ensure that information is divided into the appropriate tables
Objects - CORRECT ANSWER - Database elements, such as tables, queries, forms, and
reports
Primary key - CORRECT ANSWER - The column in a database that uniquely identifies
each record (row)
Query - CORRECT ANSWER - A database object that enables stored data to be searched
and retrieved
Quick Access Toolbar - CORRECT ANSWER - A toolbar at the top left of the screen that
contains the command that you use most often- such as Save, Undo, Redo, and Print
