Database Unit

We will be using Microsoft Access to learn about databases. Most of the lessons and video will come from www.gcflearnfree.org so be sure to study and review at any time.

Test are in RED

Extras

Downloads

More

Lessons / Assignments

Access Basics

  1. Lesson - Introduction to Databases
  2. Assignment - Introduction to Databases Crossword - 2 points
  3. Lesson -Introduction to Objects
  4. Assignment - Introduction to Objects Quiz Creation - 2 points
  5. Quiz - Student Created Objects Quiz - (on hold ... for now)
  6. Lesson -Getting Started in Access
  7. Lesson - Managing Databases and Objects
  8. Assignment - Access Print Screen - 2 Points
  9. TEST - Access Basic Test (study above lessons & THIS) - 20 Points

Working With Data

  1. Lesson - Working with Tables
  2. Simple Database - 2 points
  3. Lesson - Working with Forms
  4. Disney Form - 2 points
  5. Lesson - Sorting and Filtering Records
  6. Music Database Sorting and Filtering Assignment - 5 points
  7. TEST - Working with Data (study the above lessons) - 20 Points

Running Queries and Reports

  1. Lesson - Designing a Query
  2. Lesson - More Query Design Options
  3. Access Query Worksheet Assignment - 2 points
  4. Music Database Query Assignment - 5 Points
  5. Lesson - Creating Reports
  6. Lesson - Advanced Report Options
  7. Group Report Assignment - 2 Points
  8. TEST- Running Querries and Reports (study the above lessons) - 20 Points

Database Design Tips

  1. Lesson - Modifying Tables
  2. Lesson - Creating Forms
  3. Lesson - Formatting Forms
  4. Lesson - Designing Your Own Database
  5. TEST - Database Design Tips (study the above lessons) - 10 Points