ACCESS CH1 Flashcards
Objects
Tables, Queries, Forms and Reports
Navigation Pane
Found in the top left corners of the page; holds objects
Table
where all the data is stored in your database; foundation of each data base
field
intersection of columns and rows
record
a complete set of all the fields of one person, place, concept or event
primary key
a key in which uniquely identifies each record on a table
query
a question asked about the information in the database
form
simplified entry and modification of data
report
professional looking formatted information from underlying forms of queries
macro
stored series of commands that carry out actions. used to automate tasks
Datasheet view
where you enter information. grid containing c&r
Design view
to add fields to enter information as well as modify the tables design by specifying information entered in fields
field property
defines the characteristics of a field in more detail
relationship
connection b/w 2 tables with a common field
Back up Database
creates a duplicate copy of the entire data base to protect from loss or damage
