Simnet Access UPDATED ACTUAL Exam
Questions and CORRECT Answers
Database - CORRECT ANSWER - a collection of data: allowed you to enter, store,
organize, and retrieve large amounts of related data
Tables - CORRECT ANSWER - stores all the database data; essential building blocks of
the database; looks similar to a spreadsheet
Record - CORRECT ANSWER - each row in the table that contains data
field - CORRECT ANSWER - each column in the table that represents a specific data
value
relational database - CORRECT ANSWER - a group of tables related to one another by
common fields
Forms - CORRECT ANSWER - allow users to input data through a friendly interface
queries - CORRECT ANSWER - extract data from a table or related tables; can perform
actions on tables such as updating values or deleting data
reports - CORRECT ANSWER - display database information for printing or viewing on-
screen; do not allow data entry; the are read-only
navigation pane - CORRECT ANSWER - all the database objects are organized in the left
side of the screen
Message bar - CORRECT ANSWER - at the top of the window, below the ribbon
, one-to-many relationship - CORRECT ANSWER - a main table that contains a primary
key field that is included as a field (the foreign key) in the secondary table
Relationship window - CORRECT ANSWER - provides a visual representation of the
relationships in your database
datasheet view - CORRECT ANSWER - tables open where you can enter, sort, and filter
data; can also add new fields and modify some field properties
form view - CORRECT ANSWER - forms open which provides a user-friendly interface
for entering data; if similar to a table, it will open ina special form datasheet view; cannot change
the form layout or formatting from these view
Queries in datasheet view - CORRECT ANSWER - show the record that matches the
query criteria; doesnt allow you to modify fields
report view - CORRECT ANSWER - shows a static view of the report; cannot change the
layout or formatting of the report in this view
design view - CORRECT ANSWER - used to modify the structure of the database object;
you see only the structural elements of the object, not the data
print preview - CORRECT ANSWER - shows how the report will look when printed
deleting records - CORRECT ANSWER - cannot undo
Rich Text Format (RTF) - CORRECT ANSWER - when exporting Access data to word
PDF (Portable Document Format) - CORRECT ANSWER - can be read by anyone who
had the Adobe Reader software installed
Questions and CORRECT Answers
Database - CORRECT ANSWER - a collection of data: allowed you to enter, store,
organize, and retrieve large amounts of related data
Tables - CORRECT ANSWER - stores all the database data; essential building blocks of
the database; looks similar to a spreadsheet
Record - CORRECT ANSWER - each row in the table that contains data
field - CORRECT ANSWER - each column in the table that represents a specific data
value
relational database - CORRECT ANSWER - a group of tables related to one another by
common fields
Forms - CORRECT ANSWER - allow users to input data through a friendly interface
queries - CORRECT ANSWER - extract data from a table or related tables; can perform
actions on tables such as updating values or deleting data
reports - CORRECT ANSWER - display database information for printing or viewing on-
screen; do not allow data entry; the are read-only
navigation pane - CORRECT ANSWER - all the database objects are organized in the left
side of the screen
Message bar - CORRECT ANSWER - at the top of the window, below the ribbon
, one-to-many relationship - CORRECT ANSWER - a main table that contains a primary
key field that is included as a field (the foreign key) in the secondary table
Relationship window - CORRECT ANSWER - provides a visual representation of the
relationships in your database
datasheet view - CORRECT ANSWER - tables open where you can enter, sort, and filter
data; can also add new fields and modify some field properties
form view - CORRECT ANSWER - forms open which provides a user-friendly interface
for entering data; if similar to a table, it will open ina special form datasheet view; cannot change
the form layout or formatting from these view
Queries in datasheet view - CORRECT ANSWER - show the record that matches the
query criteria; doesnt allow you to modify fields
report view - CORRECT ANSWER - shows a static view of the report; cannot change the
layout or formatting of the report in this view
design view - CORRECT ANSWER - used to modify the structure of the database object;
you see only the structural elements of the object, not the data
print preview - CORRECT ANSWER - shows how the report will look when printed
deleting records - CORRECT ANSWER - cannot undo
Rich Text Format (RTF) - CORRECT ANSWER - when exporting Access data to word
PDF (Portable Document Format) - CORRECT ANSWER - can be read by anyone who
had the Adobe Reader software installed
