COMPSCI 1BA3 Chapter Notes -Foreign Key, Unique Key, Logical Connective
27 Nov 2012
School
Department
Course
Professor
Document Summary
A collection of related tables is called a database, or a relational database. Common field connects records in separate tables. Data type determines what field values you can enter for the field. Auto number data type automatically inserts a unique number in this field for every record. Clicking a field selector or a record selector selects that entire column or row which you can manipulate. The navigation pane currently displays the default category, all access. Objects, which lists all the database objects in the pane: each object type (tables, queries, forms, and reports) appears in its own groups, and has a unique icon. Compacting a database rearranges the data and objects in a database to decrease its file size makes more space on disk, can open and close database more quickly. Backing up a data base is the process of making a copy of the database file to protect your database against loss or damage.
