Access Test UPDATED ACTUAL Exam
Questions and CORRECT Answers
Copy - CORRECT ANSWER - Ctrl + C
Paste - CORRECT ANSWER - Ctrl + V
Undo - CORRECT ANSWER - Ctrl + Z
Redo - CORRECT ANSWER - Ctrl + Y
Select all - CORRECT ANSWER - Ctrl + A
.accdb - CORRECT ANSWER - Extension of Access
Table - CORRECT ANSWER - Contains all the raw data within the database and are
linked with a common field to create a relational database which minimized the redundant data.
Field - CORRECT ANSWER - Piece of data in a record (first name, last name)
Query - CORRECT ANSWER - Allows you to select a subset of fields or records from one
or more tables are created when you have a question about the date
Record - CORRECT ANSWER - A collection of information for a single subject
Report - CORRECT ANSWER - Provides a professional printout of data that can contain
enhancements such as headers, footers, graphics, and calculations of group records
, Form - CORRECT ANSWER - provides an easy to use data entry screen
Primary Key - CORRECT ANSWER - The field that uniquely identifies each record in a
table
Data sheet - CORRECT ANSWER - A spreadsheet in which each record is a row and each
field is a column
Design View - CORRECT ANSWER - Allows you to design the table (set criteria, set the
length of a field, and set how date will appear.)
Required Field - CORRECT ANSWER - A field for which each record must contain an
entry
Unique Field - CORRECT ANSWER - Field in which each record must contain a unique
entry (lunch pin, social)
Database Management System - CORRECT ANSWER - A computer program that
includes both the stored database and the tools required to use the database
Access - CORRECT ANSWER - What is an example of a database management system?
Comparison Operator - CORRECT ANSWER - Represent comparisons between two
values (< less than, <= less than or equal to, <> not equal to, > greater than, >= greater than or
equal to)
Null - CORRECT ANSWER - Lack of an entry
Sort - CORRECT ANSWER - to arrange records alphabetically, or numerically in a
specific field
Questions and CORRECT Answers
Copy - CORRECT ANSWER - Ctrl + C
Paste - CORRECT ANSWER - Ctrl + V
Undo - CORRECT ANSWER - Ctrl + Z
Redo - CORRECT ANSWER - Ctrl + Y
Select all - CORRECT ANSWER - Ctrl + A
.accdb - CORRECT ANSWER - Extension of Access
Table - CORRECT ANSWER - Contains all the raw data within the database and are
linked with a common field to create a relational database which minimized the redundant data.
Field - CORRECT ANSWER - Piece of data in a record (first name, last name)
Query - CORRECT ANSWER - Allows you to select a subset of fields or records from one
or more tables are created when you have a question about the date
Record - CORRECT ANSWER - A collection of information for a single subject
Report - CORRECT ANSWER - Provides a professional printout of data that can contain
enhancements such as headers, footers, graphics, and calculations of group records
, Form - CORRECT ANSWER - provides an easy to use data entry screen
Primary Key - CORRECT ANSWER - The field that uniquely identifies each record in a
table
Data sheet - CORRECT ANSWER - A spreadsheet in which each record is a row and each
field is a column
Design View - CORRECT ANSWER - Allows you to design the table (set criteria, set the
length of a field, and set how date will appear.)
Required Field - CORRECT ANSWER - A field for which each record must contain an
entry
Unique Field - CORRECT ANSWER - Field in which each record must contain a unique
entry (lunch pin, social)
Database Management System - CORRECT ANSWER - A computer program that
includes both the stored database and the tools required to use the database
Access - CORRECT ANSWER - What is an example of a database management system?
Comparison Operator - CORRECT ANSWER - Represent comparisons between two
values (< less than, <= less than or equal to, <> not equal to, > greater than, >= greater than or
equal to)
Null - CORRECT ANSWER - Lack of an entry
Sort - CORRECT ANSWER - to arrange records alphabetically, or numerically in a
specific field
