|
Programming Concepts – DatabasesReview of Syllabus What we will not cover. – Win98 Tutorials 1 & 2 – Use as a reference as Session 1.1 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 Session 1.2 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 |