Microsoft Access

Module 1: Introduction to Databases and Access

Understanding the role of databases

Overview of Microsoft Access environment

Navigating the Access interface: Ribbon, Navigation Pane, and Views

Access database structure: Tables, Queries, Forms, Reports

Module 2: Creating a New Database

Starting a blank database

Understanding relational database principles

Planning tables and relationships

Naming conventions and best practices

Module 3: Creating and Modifying Tables

Designing tables with fields and data types

Setting primary keys

Using input masks and field properties

Creating lookup fields and value lists

Using validation rules and default values

Module 4: Managing Table Data

Entering, editing, and deleting records

Sorting and filtering data

Importing data from Excel or other sources

Linking tables across databases

Module 5: Relationships and Referential Integrity

Creating relationships between tables

One-to-one, one-to-many, and many-to-many relationships

Enforcing referential integrity

Cascading updates and deletes

Using the Relationship View effectively

Module 6: Creating and Running Queries

Introduction to queries: Select, Action, and Parameter queries

Designing Select queries using Query Design View

Filtering with criteria and expressions

Sorting and using calculated fields

Using wildcards and logical operators in queries

Working with multiple tables in a query (joins)

Module 7: Action Queries

Make Table Queries

Update Queries

Append Queries

Delete Queries

Running queries safely and backing up data

Module 8: Parameter and Crosstab Queries

Prompting users for input with Parameter Queries

Creating Pivot-style summaries with Crosstab Queries

Using functions within queries (Date(), Now(), IIf())

Module 9: Creating Forms for Data Entry

Designing user-friendly forms

Using Form Wizard and Layout View

Adding controls: text boxes, combo boxes, buttons

Setting form properties and control formats

Creating navigation forms and switchboards

Module 10: Subforms and Layout Design

Creating subforms for related data

Linking parent/child records

Conditional formatting in forms

Enhancing usability with macros and navigation buttons

Module 11: Creating and Formatting Reports

Using the Report Wizard

Grouping and sorting records

Summarizing data with totals and averages

Adding logos, headers, footers, and page numbers

Conditional formatting in reports

Module 12: Advanced Form and Report Features

Embedding subreports

Printing filtered reports

Using charts and visual summaries in reports

Adding calculated fields and custom labels

Module 13: Introduction to Macros and Automation

Creating simple macros

Automating navigation and form events

Assigning macros to command buttons

Introduction to VBA (optional, based on group level)

Module 14: Database Security and Maintenance

Compacting and repairing databases

Creating backup copies

Splitting the database for multi-user access

Password-protecting Access databases

Managing users and permissions

Module 15: Exporting and Integrating Data

Exporting to Excel, PDF, and Word

Importing and linking external data

Integrating with Microsoft Outlook and SharePoint

Tips for building scalable databases Bonus Add-ons (Optional)

Industry-specific case study (e.g., inventory tracking, employee database, or client management)

Access Templates for Common Business Needs

Access vs Excel: When to Use What

Introduction to SQL in Access (for advanced audiences)