WO.5 Understand Databases

Understanding and using databases

In My Life

I can use the filtering tools on shopping websites to specify the type of products I'm interested in buying.

In My Work

I can locate my patients' health information in the database to review and verify their medical history.

In My Education

I can use my library's database subscriptions to find information on a variety of topics.

As a Teacher/Trainer

I can use my school's student database to look at a student's assessment history.

Explore Learning Activities

image

Microsoft Access: Query Criteria Quick Reference Guide

GCFLearnFree.org

Use this quick reference guide for 20 of the most common criteria used in Access queries.

  • Lesson
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://edu.gcfglobal.org/en/access/query-criteria-quick-reference-guide/1/
Goodwill Community Foundation
Copyright
image

Microsoft Access Quiz

GCFLearnFree.org

Test your knowledge of Access by taking our quiz.

  • Quiz/Assessment
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://edu.gcfglobal.org/en/access/access-quiz/1/
Goodwill Community Foundation
Copyright
image

Microsoft Access: Creating a Parameter Query

GCFLearnFree.org

Learn how to run an Access parameter query to find the data you need using variable criteria in your search terms.

  • Lesson
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://edu.gcfglobal.org/en/access/creating-a-parameter-query/1/
Goodwill Community Foundation
Copyright
image

Microsoft Access: How to Create Calculated Fields and Totals Rows

GCFLearnFree.org

Learn how to create calculated fields and totals rows.

  • Lesson
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://edu.gcfglobal.org/en/access/how-to-create-calculated-fields-and-totals-rows/1/
Goodwill Community Foundation
Copyright
image

Microsoft Access: Designing Your Own Database

GCFLearnFree.org

Learn how to create a database from an existing template and find resources to learn more about database design.

  • Lesson
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://edu.gcfglobal.org/en/access/designing-your-own-database/1/
Goodwill Community Foundation
Copyright
image

Microsoft Access: How to Create a Find Duplicates Query

GCFLearnFree.org

Learn how to run an Access duplicates query to erase duplicates and strengthen your database.

  • Lesson
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://edu.gcfglobal.org/en/access/how-to-create-a-find-duplicates-query/1/
Goodwill Community Foundation
Copyright
image

Microsoft Access: Creating Forms

GCFLearnFree.org

Learn how to create and modify forms using options like design controls and form properties.

  • Video
  • Lesson
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://youtu.be/dEaQIrw3CZY
https://edu.gcfglobal.org/en/access/creating-forms/1/
Goodwill Community Foundation
Copyright
image

Microsoft Access: Modifying Tables

GCFLearnFree.org

Learn how to create and rearrange table fields, as well as set validation rules, character limits, and data types.

  • Video
  • Lesson
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://youtu.be/mtX2QLrJv1U
https://edu.gcfglobal.org/en/access/modifying-tables/1/
Goodwill Community Foundation
Copyright
image

Microsoft Access: Formatting Forms

GCFLearnFree.org

Learn how to add command buttons, modify form layouts, add logos and other images, and change form colors and fonts.

  • Video
  • Lesson
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://youtu.be/5MMLzgfNSlU
https://edu.gcfglobal.org/en/access/formatting-forms/1/
Goodwill Community Foundation
Copyright
image

Microsoft Access: More Query Design Options

GCFLearnFree.org

Learn how to modify and sort queries, and discover different query-building options.

  • Video
  • Lesson
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://youtu.be/-JWLgNqtfaw
https://edu.gcfglobal.org/en/access/more-query-design-options/1/
Goodwill Community Foundation
Copyright
image

Microsoft Access: Creating Reports

GCFLearnFree.org

Learn learn how to create, modify, and print reports.

  • Video
  • Lesson
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://youtu.be/1XUeGq80R5Q
https://edu.gcfglobal.org/en/access/creating-reports/1/
Goodwill Community Foundation
Copyright
image

Microsoft Access: Advanced Report Options

GCFLearnFree.org

Learn how to use the Report Wizard to create complex reports and use Access formatting options to change the look of your report.

  • Lesson
  • Video
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://youtu.be/iks5OO8Vh1c
https://edu.gcfglobal.org/en/access/advanced-report-options/1/
Goodwill Community Foundation
Copyright