Access 2010 - Beginning
Last revised: July 28, 2011
| Instructor's Notes | |||
|
Tutorial 1 - Database Basics |
|
Instructor's notes for Tutorial 1 |
|
|
Tutorial 2 - Building a Database |
|
Instructor's notes for Tutorial 2 |
|
|
Tutorial 3 - Querying a Database |
|
Instructor's notes for Tutorial 3 |
|
|
Tutorial 4 - Creating Forms & Reports |
|
Instructor's notes for Tutorial 4 |
| Recorded Lectures | |||
|
|
Unit 1 - Database Concepts | ||
Part 1
|
Databases, tables, records, fields, queries, forms and reports; Creating a new table in datasheet view; Adding data to a table; Saving a table and its data | ||
|
Part 2
|
Database concepts review; Importing data from Excel and text files; Navigating in datasheet view; Creating a simple query; Creating a form; Navigating using form view; Creating a report; Compacting a database | ||
|
|
Unit 2 - Building Databases | ||
|
Part 1
|
Database design concepts; Defining a table's structure (fields); Field types; Text field sizes; Field captions; Simple input masks; Default values | ||
|
Part 2
|
Text fields review; Defining a primary key; Defining a linking field to another table; Defining an Autonumber linking field; Numeric fields and field sizes; Currency fields; Yes/No fields; Date fields | ||
|
Part 3
|
tblProducts; Linking tables; Referential Integrity | ||
|
|
Unit 3 - Creating Database Queries | ||
|
Part 1
|
Edit vs Navigation Mode; Deleting records; Finding records; Query concepts; Selecting query tables and fields; Sorting and filtering using datasheet view; Sorting using the QBE grid; Arranging fields for a primary/secondary sort; Adding fields and sorting using multiple tables | ||
|
Part 2
|
Query criteria: exact match, range checking, Between, In, wildcards, compound criteria - AND, compound criteria - OR, mixing AND and OR | ||
|
Part 3
|
Calculated fields; Concatenating text; Aggregate queries; Aggregate fields in datasheet view | ||
| Assignments | |||
|
|
Tutorial 1 Assignment |
|
Assignment sheet for Tutorial 1 |
|
|
Tutorial 2 Assignment |
|
Assignment sheet for Tutorial 2 |
|
|
Tutorial 3 Assignment Answer Keys for Tutorial 3 |
|
Assignment sheet for Tutorial 3 |
|
|
Tutorial 4 Assignment |
|
Assignment sheet for Tutorial 4 |
| Handouts & Data Files | |||
|
|
Competency Checklist |
|
List of competencies (skills) gained in this course, presented by tutorials |
|
|
Student Files
How to Download Student Files |
|
Data files for all four tutorials, stored in zip files. How to download and extract (unzip) student files. |
