CIT 105: INTRO TO COMPUTERS: ACCESS
database - Answers -a collection of date; allows you to enter, store, organize, and
retrieve large amounts of related date
table - Answers -stores all the database date; are the basic building blocks of the
database
record - Answers -each row in a table in a database
field - Answers -each column in a table in a database
relational database - Answers -a database that allows you to relate tables and
databases to one another through common fields
form - Answers -allows database users to input data through a friendly interface
query - Answers -extracts data from a table or multiple related tables
report - Answers -displays database information for printing or viewing on-screen
navigation pane - Answers -pane that organizes all the objects for a database; docked
at the left side of the screen
macro - Answers -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 - Answers -security warning that displays at the top of the window, below
the ribbon
one-to-many relationship - Answers -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 - Answers -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 - Answers -in a one-to-many relationship, the field in the secondary table
that relates to the primary key in the primary table
, relationships window - Answers -window that provides a visual representation of the
relationships in your database
datasheet view - Answers -view to use when entering data in a table or to sort and filter
data; by default. tables open in datasheet view
form view - Answers -provides a user-friendly interface for entering data in a database;
you cannot change the form layout or formatting
report view - Answers -shows a static view of the database report; cannot change the
layout or formatting of the report from report view
design view - Answers -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 - Answers -shows the code used to build the query
layout view - Answers -view where you can modify some (but not all) structural
elements in a form or report
print preview - Answers -a specific report view that shows how the database report will
appear when printed
datasheet - Answers -table data and query results displayed in datasheet view
outermost sort - Answers -in a multilevel sort, the first field the data are sorted on
innermost sort - Answers -in a multilevel sort, the last field the data are sorted on
undo - Answers -reverses the last action performed
redo - Answers -reverses the undo command and restores the file to its previous state
template - Answers -a file with predefined settings that you can use as a base to create
a new database of your own
access web app - Answers -online database that requires a SharePoint server
desktop database - Answers -a database that does not require a SharePoint server
quick start application parts - Answers -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
database - Answers -a collection of date; allows you to enter, store, organize, and
retrieve large amounts of related date
table - Answers -stores all the database date; are the basic building blocks of the
database
record - Answers -each row in a table in a database
field - Answers -each column in a table in a database
relational database - Answers -a database that allows you to relate tables and
databases to one another through common fields
form - Answers -allows database users to input data through a friendly interface
query - Answers -extracts data from a table or multiple related tables
report - Answers -displays database information for printing or viewing on-screen
navigation pane - Answers -pane that organizes all the objects for a database; docked
at the left side of the screen
macro - Answers -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 - Answers -security warning that displays at the top of the window, below
the ribbon
one-to-many relationship - Answers -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 - Answers -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 - Answers -in a one-to-many relationship, the field in the secondary table
that relates to the primary key in the primary table
, relationships window - Answers -window that provides a visual representation of the
relationships in your database
datasheet view - Answers -view to use when entering data in a table or to sort and filter
data; by default. tables open in datasheet view
form view - Answers -provides a user-friendly interface for entering data in a database;
you cannot change the form layout or formatting
report view - Answers -shows a static view of the database report; cannot change the
layout or formatting of the report from report view
design view - Answers -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 - Answers -shows the code used to build the query
layout view - Answers -view where you can modify some (but not all) structural
elements in a form or report
print preview - Answers -a specific report view that shows how the database report will
appear when printed
datasheet - Answers -table data and query results displayed in datasheet view
outermost sort - Answers -in a multilevel sort, the first field the data are sorted on
innermost sort - Answers -in a multilevel sort, the last field the data are sorted on
undo - Answers -reverses the last action performed
redo - Answers -reverses the undo command and restores the file to its previous state
template - Answers -a file with predefined settings that you can use as a base to create
a new database of your own
access web app - Answers -online database that requires a SharePoint server
desktop database - Answers -a database that does not require a SharePoint server
quick start application parts - Answers -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
