Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
27 Cards in this Set
- Front
- Back
fields
|
a single characteristic or attribute of a person place object event or idea (the titles to define categories as well as the boxes below and after them)
|
|
field value
|
The specific value, or content, of a field
|
|
record
|
A set of field values
|
|
tables
|
a collection of fields that describe a person place object event or idea
|
|
a database, or a relational database
|
A collection of related tables
|
|
common field
|
is what connects the records in the separate tables to make them related
|
|
primary key
|
field, or a collection of fields, whose values uniquely identify each record in a table
|
|
foreign key
|
When you include the primary key from one table as a field in a second table to form a relationship between the two tables, it is called this
|
|
A database management system (DBMS)
|
software program that lets you create databases and then manipulate data in them
|
|
relational database management system
|
data is organized as a collection of tables
|
|
query
|
is a question you ask about the data stored in a database
|
|
Simple Query Wizard
|
allows you to select records and fields quickly
|
|
form
|
is an object you use to enter, edit, and view records in a database
|
|
Form tool
|
tool to create a simple form with one mouse click
|
|
report
|
a formatted printout (or screen display) of the contents of one or more tables in a database
|
|
Report tool
|
places all the fields from a selected table (or query) on a report, making it the quickest way to create a report
|
|
Compacting a db
|
rearranges the data and objects in a database to decrease its file size
|
|
Backing up
|
process of making a copy of the database file to protect your database against loss or damage
|
|
The Back Up Database command
|
enables you to back up your database file from within the Access program, while you are working on your database
|
|
access
|
a computer program used to enter maintain and retrieve related data in a format known as a database
|
|
template
|
predesigned db including professionally designed tables, reports and other objects making it quick and easy to create your database
|
|
access window
|
the program window when you create a new db or open an existing one
|
|
datasheet view
|
what a new blank table is showed in, showing tables as a datasheet in rows and columns similar to a table in excel or word. reach row is a seperate record in a table and each column will contain the field values for one field in the table
|
|
navigation pane
|
area on left side of the window that lists all the objects like tables reports etc in the db. is the main control center for opening and working with database objects
|
|
ID column
|
primary key field for all new tables
|
|
data type
|
determines what field values you can enter in the field
|
|
text
|
data type allowing digits and other chars and letters, as well as numbers never used in calculations
|