| Access Overview |
Short description of the major parts of an Access database |
| Creating Tables |
Reference sheet of the properties and requirements for creating tables |
| Introduction to Systems Analysis |
Chapter 1 from Palgrave Macmillan: Systems Analysis by Kevin Bowman |
| Lab - import Excel |
Creating an Access database by Importing an Excel file
Use your Excel addressbook file (or use this sample file)
Your final database file should look like this |
| Planning Your Database |
Key rule in Information Management: Plan your project before you open any software! |
| Defining Relationships Overview |
What is an entity? What is an attribute? |
| Data Normalization |
What normalization is and why you should care. |
| Keys: Primary, Foreign and Candidate |
A summary of key types and selection criteria |
| Lab - CD store database |
Directions for planning a cd store database exercise |
| |
|
| |
|
cdstore.mdb (file produced in this exercise) |
| Creating Forms in Access |
Forms using AutoForm, Form Wizard or Design View |
| Modifying Forms |
Modifying form formatting and properites |
| Lab: forms |
Using your addresses database (or download addresses.mdb),create forms to input data.
- Modify the background of one form to include a photo
- Modify the color and formatting of the form titles.
- Try adding and deleting records
|
| Creating Queries |
Overview of what queries are and how to create some of the basic types using the wizard |
| Creating a Query in Design View |
More advanced queries, created in design view |
| Parameter Queries |
Create a query based on a condition input by the user
example: "find all customers who live in Chapel Hill" |
| Query Operators |
Reference chart of common operators used in queries; includes math, relational, string boolean and other operators. |