 | Term | Definition |
| |
entity integrity |
the rule that no field that is part of the primary key may accept null values |
| |
referential integrity |
the rule that if table A contains a foreign key that matches the primary key of table B, the value of this foreign key must either match the value of the primary key from some row in table B or be null. |
| |
null value |
used when a value is unknown or inapplicable. not the same as a blank or zero value |
| |
foreign key |
its value is required to match the value of the primary key for a second table |
| |
view |
an application program's or an individual user's picture of the database |
| |
create a report, examine table data, simplification, provide security by omitting sensitive data |
uses of a view |
| |
data dictionary |
serves as a super catalog containing metadata beyond what's been previously described |
| |
locking |
denies acess by other users to use data while DBMS process one user's updates to the database |
| |
deadlock |
when two users are locked out by the DBMS, but waiting on each other |
| |
encryption |
converts the data in a database to a format that's indecipherable to a word processor or other program and stores it in an encrypted format |
| |
archive |
a place where a record of certain corporate data is kept |
| |
denormalization |
converts a table that is in third normal form to a table that is no longer in third normal form |
| |
repeating groups |
multiple entries for a single record |
| |
partial dependencies |
dependencies on only a portion of the primary key |
| |
switchboard |
a form that might be displayed when you open a database and provides a controlled method for users to open the objects in a database |
| |
data access page |
a Web page that lets you view and interact with data stored in an Access database |
| |
VBA (Visual Basic for Applications) |
the pogramming language for Microsoft Office programs |
| |
module |
a database object that contains instructions to automate a database task |
| |
macro |
a set of instructions that you specify to automate certain database tasks |
| |
query |
a database object that is essentially a question that you ask about the data stored in a database |
| |
form |
a database object that is used to view, add, delete, update, and print records in the database |
| |
report |
a database object that is a formatted presentation of data from a table or query that is created as a printout or to be viewed on screen |
| |
by using the database design, by entering data, by working in table design view |
3 ways to create a table |
| |
input mask |
a predefined format that you can apply to a field so that its values are displayed using the format you specified |
| |
validation text |
a predefined message that explains the valid values |
| |
validation rule |
compares the data entered by the user against one or more valid values that the database developer specified using the Validation Rule property for the field |
| |
lookup field |
lets the user select a field value from a list of exisiting field values stored in the database or from a list of specified value |
| |
sorting |
organizing records in a particular order or sequence |
| |
filter |
restricts data in a single table to create a temporary subset of records |
| |
Filter By Selection |
selects a particular field in a database and then displays only data that matches the contents of that field |
| |
Filter By Form |
allows more than one selection criteria in a filter, and allows for comparative data |
| |
by using the simple query wizard, in design view |
ways to create a query |
| |
Find Duplicates query |
locates duplicate records in a table or query |
| |
Find Unmatched |
locates records with no related records in a second table or query |
| |
paramater value |
used when you need to run a query multiple times wih changes to the criteria (opens a sure prompt box) |
| |
Crosstab query |
a special type of Totals query that performs aggregate function calculations on the value of one database field and allows you to determine exactly how your summary data appears in the results |
| |
by using an AutoForm Wizard, by using FormWizard, in design view |
ways to create a form |
| |
text box |
displays a label attached to a text box that is bound to a field in a inderlying table or query or contains a calculated value |
| |
unbound forms |
do not have a record source; they are usually designed to help a user navigate through a database |
| |
unbound control |
displays data from sources other than a table or query |
| |
bound control |
displays the field names and data from a table or query |
