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)