Access – Level 1 & 2 (Private)

Description

Overview:

This course provides the basic concepts and skills to use Microsoft Access including how to navigate the Access interface, and how to create and modify tables, queries, forms, and reports. Also learn the concepts and skills for the advanced use of Microsoft Access including how to create advanced queries, forms, and reports, how to create macros, and how to manage your databases.

Prerequisite(s):

At least one year experience using Windows 10, 8, or 7

Audience:

Outline:

Lesson 1: Database fundamentals

• Understanding general database terms
• Relational databases
• Access interface and objects

Lesson 2: Tables

• Creating tables
• Creating fields
• Data Validation
• Relationships and keys

Lesson 3: Queries

• Creating basic queries
• Modifying queries
• Using calculated fields

Lesson 4: Forms

• Creating simple forms
• Form design
• Form controls

Lesson 5: Reports

• Creating Reports
• Report controls
• Formatting reports

Lesson 6: Advanced queries

• Grouping and summarizing
• Updating, deleting, and relationships
• Indexing for performance

Lesson 7: Advanced forms

• Subforms
• Advanced control types
• Specialized form types

Lesson 8: Advanced reports

• Subreports
• Advanced grouping
• Advanced formatting

Lesson 9: Macros

• Creating basic macros
• Using variables
• Troubleshooting macros

Lesson 10: Database management

• Compact & Repair
• Restoring a database
• Other maintenance tasks