Access Course: Learn Simple Data Organization

Skill	Pre-assess	Lesson	Post-assess	Learning mode

Access Basic Course Outline

Verified Learning

Skill	Pre-assess	Lesson	Post-assess
Access Fundamentals
Understand the Screen Learn the main parts of the Access window	Not Started	Not Started	Not Started
Open and Save a Database Access database launch essentials	Not Started	Not Started	Not Started
Work with Database Objects Access Database tools & object skills	Not Started	Not Started	Not Started
Tour of Tables Access database setup essentials	Not Started	Not Started	Not Started
Tour of Queries Explore how queries work in Access	Not Started	Not Started	Not Started
Tour of Forms Create, manage, and navigate forms in Access	Not Started	Not Started	Not Started
Tour of Reports Design, group, and print reports in Access	Not Started	Not Started	Not Started
Help Microsoft Access Help guides and tips	Not Started	Not Started	Not Started
Close and Exit Access Close your Access database safely and exit	Not Started	Not Started	Not Started

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Work with Databases			Account Required
Plan a Database Database design tips for better structure
Create a Database Access database setup and design basics
Add, Edit, and Delete Records Add, edit, or delete Access record
Select Data Create a select query in Access to filter data
Cut, Copy, and Paste Data Master cut copy and paste data across fields
Use Undo and Redo How to undo in Access and redo steps
Check Spelling Run Access spell check and fix typos
Use the Zoom Box Edit text with the Zoom dialog box in Access
Preview and Print Use Print Preview to review and print in Access

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Work with Data			Account Required
Find and Replace Data Find and replace in Access with quick precision
Sort Records Sort data in Access by fields and order
Use Common Filters Apply Access form filters to narrow records
Filter by Selection Quickly isolate records using Selection filter
Filter by Form Filter by Form Access criteria and tips
Create an Advanced Filter How to Use Advanced Filter in Access
Adjust Rows and Columns Autofit rows and columns in Access
Change Gridlines and Cell Effects Adjust gridlines, borders, and cell effects
Freeze a Column Keep key fields visible in Access tables
Hide a Column How to hide a column in Access tables

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Tables			Account Required
Create a Table Add fields and data types in Access tables
Understand Field Types and Properties Build a new table in Access step by step
Index a Field Create an index in Access for faster queries
Add a Primary Key and Auto-Increment Fields Add primary key and autonumber fields in Access
Insert, Reorder, and Delete Fields Add, rearrange, and remove fields in Access
Add Field Descriptions and Captions Add descriptions and captions to Access fields
Change the Field Size How to change field size in Access tables
Format Number, Currency, and Date/Time Fields Format numbers, currency, and date/time in Access
Format Text Fields How to format a field in Access quickly
Set a Default Value How to set default values in Access
Require Data Entry Force required fields in Access forms
Validate Data Access data validation rules and errors
Create an Input Mask Use input masks to standardize Access entries
Create a Lookup Field Set up a lookup field in Access
Create a Value List Build dropdown choices with an Access value list
Modify a Lookup List Switch a field to an Access lookup list
Add Total Rows Access Total Row sum average count

Student Downloads

Concise, easy-to-use guide for quick learning and reference.

Step-by-step illustrated reference guide.

Practice files for hands-on exercises.

Instructor Downloads

Lesson plans, instructions, and tips for delivering great classes.

Get a Completion Certificate

Share your certificate with prospective employers and your professional network.

Your Name

For verified skills in: Access Basic

Issued on December 04, 2025