MS ACCESS 2007: Chapter 1, Creating and Using a Database
Creating and Using a Database
Database Terminology:
Database
Table
Record
Field
Unique Identifier (primary key)
Form
Report
Objectives:
Databases and Management Systems
Design a Database: determine main objects to know what tables are needed, determine primary keys, determine additional fields, determine relationships among the tables–most common is the one-to-many (identify the one table, the many table, and include the primary key from the one table as a field in the many table), determine data types, identify and remove redundancy
DO TOGETHER AT OWN MACHINES:
Start Access and describe Access Window
Create a Class Database Together (Note difference between Blank and Template)
Name and Location VERY IMPORTANT so auto save knows where to place information
Create a Table
Datasheet and design views, data types, close to save, initials at end of file name
Field Ideas for class demo:
leave id/autonumber for primary key, lname, fname, bday, career choice, avg salary for career, favorite food type, pets, sports, etc.
Add Records (watch for correct info and data type errors)
Close a Table and Open saved table from Navigation Pane
(better to keep closed when not using)
Check table for accuracy and edit as necessary, add teacher record info, add gender and update all records
DEMO ONLY using class database:
Print Table Contents
Create and Print Custom Reports
Create and Use a Split Form
Use Access Help
Lab Assignment: Chapter tutorial and Lab 1: JMS
Reading Assignment for next class:
Access Chapter 2–we will review Chapter 3 info in class
Learn it Online when you finish: Access, Chapter 1
