Programming Concepts – Databases
Review of Syllabus
What we will not cover. – Win98 Tutorials 1 & 2 – Use as a reference as
What is a database? – a collection of related information
Access is often referred to as a disk based DB – results in only about 10 to
Field – a single characteristic or attribute of a person, place, object,
Table – a collection of fields that describe a similar object.
Record – a set of all fields relating to one object.
Database is a collection a related tables – Pg. AC 1.05
Multiple tables can be linked together through a common field Figure 1-2
A primary key is a key unique to the table from all other records.
A primary key used from another table to link to one is a foreign key.
DBMS – Database Management System – Pg. AC 1.06 Common features
Access Limits – Pg. AC 1.07
How to start Access
Opening an Existing DB – Pg. AC 1.09
The Access and DB window. (Objects Bar) – Pg. AC 1.10
Opening an Access Table – Pg. AC 1.11
Parts of the datasheet view Pg. AC 1.12
Navigating an Access datasheet
Query – A Question you ask about a set of data stored in a database.
Note: Queries for DBs are built upon a language called SQL
You can custom design your own queries, or you can use a query wizard.
Forms – an object used to maintain, view, and print records (although
Maneuvering though records in a form. – note only one record is shown at a
Getting Help – Not always helpful…sometimes you have to rely on other
Reports – a formatted printout of the contents of one or more tables. Pg.
Compacting a DB. – Pg. AC 125 (rearranges data and objects to make them
Copyright ©2001-2002, Walter Wimberly – Instructor and all