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: Formatting Forms

GCFLearnFree.org

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

  • Lesson
  • Video
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://youtu.be/5MMLzgfNSlU
https://youtu.be/5MMLzgfNSlU
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://youtu.be/dEaQIrw3CZY
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://youtu.be/mtX2QLrJv1U
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.

  • Video
  • Lesson
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://youtu.be/iks5OO8Vh1c
https://youtu.be/iks5OO8Vh1c
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://youtu.be/1XUeGq80R5Q
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://youtu.be/-JWLgNqtfaw
Goodwill Community Foundation
Copyright
image

Microsoft Access: Designing a Multi-table Query (Parts 1 & 2)

GCFLearnFree.org

Learn how to create a complex multi-table query.

  • Video
  • Lesson
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://youtu.be/pcjXQqKWWNw
https://youtu.be/pcjXQqKWWNw
Goodwill Community Foundation
Copyright
image

Microsoft Access: Designing a Simple Query

GCFLearnFree.org

Learn how to create a simple one-table query.

  • Video
  • Lesson
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://youtu.be/LUL1nnxUz_c
https://youtu.be/LUL1nnxUz_c
Goodwill Community Foundation
Copyright
image

Microsoft Access: Sorting and Filtering Records

GCFLearnFree.org

Learn how to sort and filter data so you can customize how you organize and view your data.

  • Lesson
  • Video
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://youtu.be/qOoG8eWPV94
https://youtu.be/qOoG8eWPV94
Goodwill Community Foundation
Copyright
image

Microsoft Access: Working with Forms

GCFLearnFree.org

Learn how to use forms to enter new records and view and edit existing ones.

  • Video
  • Lesson
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://youtu.be/uTRdmSQjjm8
https://youtu.be/uTRdmSQjjm8
Goodwill Community Foundation
Copyright
image

Microsoft Access: Working with Tables

GCFLearnFree.org

Learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with.

  • Video
  • Lesson
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://youtu.be/e06FnSV9INw
https://youtu.be/e06FnSV9INw
Goodwill Community Foundation
Copyright
image

Microsoft Access: Managing Databases and Objects

GCFLearnFree.org

Learn how to to open and close an Access database, as well as how to open, close, and save objects.

  • Video
  • Lesson
  • WO.5 Understand Databases
https://edu.gcfglobal.org/en/access/
https://youtu.be/n3tG77UeGQ4
https://youtu.be/n3tG77UeGQ4
Goodwill Community Foundation
Copyright