CIT 105: Intro to Computers: Access ACTUAL UPDATED QUESTIONS AND
CORRECT ANSWERS
database a collection of date; allows you to enter, store, organize, and retrieve large
amounts of related date
table stores all the database date; are the basic building blocks of the database
record each row in a table in a database
field each column in a table in a database
relational database a database that allows you to relate tables and databases to one another through
common fields
form allows database users to input data through a friendly interface
query extracts data from a table or multiple related tables
report displays database information for printing or viewing on-screen
navigation pane pane that organizes all the objects for a database; docked at the left side of the
screen
macro programming instruction that can be run from within a file; used to automate data
entry and formatting processes and to execute commands from buttons in
database forms and reports
message bar security warning that displays at the top of the window, below the ribbon
one-to-many relationship a relationship between two databases tables where the primary table contains a
primary key field that is included as a field (the foreign key) in the secondary
table; one record in the first table can relate to many records in the second table
primary key the field that contains data unique to each record in a table; in a one-to-many
relationship, the field in the main table that is also included in the secondary table
foreign key in a one-to-many relationship, the field in the secondary table that relates to the
primary key in the primary table
relationships window window that provides a visual representation of the relationships in your database
, datasheet view view to use when entering data in a table or to sort and filter data; by default.
tables open in datasheet view
form view provides a user-friendly interface for entering data in a database; you cannot
change the form layout or formatting
report view shows a static view of the database report; cannot change the layout or
formatting of the report from report view
design view view where you establish the table primary key and table properties as well as
specific properties or formatting for individual fields; use when you want to
change the structure or properties of the table
SQL view shows the code used to build the query
layout view view where you can modify some (but not all) structural elements in a form or
report
print preview a specific report view that shows how the database report will appear when
printed
datasheet table data and query results displayed in datasheet view
outermost sort in a multilevel sort, the first field the data are sorted on
innermost sort in a multilevel sort, the last field the data are sorted on
undo reverses the last action performed
redo reverses the undo command and restores the file to its previous state
template a file with predefined settings that you can use as a base to create a new
database of your own
access web app online database that requires a SharePoint server
desktop database a database that does not require a SharePoint server
quick start application parts a table template that you can use to start building a database; five quick start
application parts to choose from: comments, contacts, issues, tasks, and users;
most also include form for data entry
CORRECT ANSWERS
database a collection of date; allows you to enter, store, organize, and retrieve large
amounts of related date
table stores all the database date; are the basic building blocks of the database
record each row in a table in a database
field each column in a table in a database
relational database a database that allows you to relate tables and databases to one another through
common fields
form allows database users to input data through a friendly interface
query extracts data from a table or multiple related tables
report displays database information for printing or viewing on-screen
navigation pane pane that organizes all the objects for a database; docked at the left side of the
screen
macro programming instruction that can be run from within a file; used to automate data
entry and formatting processes and to execute commands from buttons in
database forms and reports
message bar security warning that displays at the top of the window, below the ribbon
one-to-many relationship a relationship between two databases tables where the primary table contains a
primary key field that is included as a field (the foreign key) in the secondary
table; one record in the first table can relate to many records in the second table
primary key the field that contains data unique to each record in a table; in a one-to-many
relationship, the field in the main table that is also included in the secondary table
foreign key in a one-to-many relationship, the field in the secondary table that relates to the
primary key in the primary table
relationships window window that provides a visual representation of the relationships in your database
, datasheet view view to use when entering data in a table or to sort and filter data; by default.
tables open in datasheet view
form view provides a user-friendly interface for entering data in a database; you cannot
change the form layout or formatting
report view shows a static view of the database report; cannot change the layout or
formatting of the report from report view
design view view where you establish the table primary key and table properties as well as
specific properties or formatting for individual fields; use when you want to
change the structure or properties of the table
SQL view shows the code used to build the query
layout view view where you can modify some (but not all) structural elements in a form or
report
print preview a specific report view that shows how the database report will appear when
printed
datasheet table data and query results displayed in datasheet view
outermost sort in a multilevel sort, the first field the data are sorted on
innermost sort in a multilevel sort, the last field the data are sorted on
undo reverses the last action performed
redo reverses the undo command and restores the file to its previous state
template a file with predefined settings that you can use as a base to create a new
database of your own
access web app online database that requires a SharePoint server
desktop database a database that does not require a SharePoint server
quick start application parts a table template that you can use to start building a database; five quick start
application parts to choose from: comments, contacts, issues, tasks, and users;
most also include form for data entry
