What you'll learn
A Microsoft Access 2016 course typically covers the creation and management of relational databases, focusing on four primary objects: Tables, Queries, Forms, and Reports. The curriculum is generally divided into introductory and advanced levels to move students from basic data entry to complex database automation.
Foundational Topics (Beginner Level)
Introductory courses focus on the core environment and essential database principles.
- Database Fundamentals: Understanding relational database structures, terminology, and design principles.
- Tables & Data Types: Creating tables, assigning data types (e.g., Short Text, Number, Date/Time), and setting primary keys to uniquely identify records.
- Data Entry & Management: Using Datasheet and Design views to add, edit, sort, and filter records.
- Basic Queries: Building "Select" queries to retrieve specific information from a single table.
- Standard Forms & Reports: Using Wizards to quickly generate user-friendly data entry forms and summary reports.
Advanced Topics (Intermediate to Expert Level)
Advanced courses transition into managing data at scale and automating repetitive tasks.
- Relational Design: Establishing one-to-many relationships and enforcing referential integrity to ensure data consistency.
- Complex Queries: Creating "Action" queries (Update, Append, Delete, Make Table) and multi-table joins to manipulate large datasets.
- Custom Form & Report Design: Adding calculated fields, subforms, subreports, and conditional formatting for professional data presentation.
- Automation: Building Macros to automate common tasks, such as opening a specific form or running a monthly report with one click.
- Database Utilities: Performing maintenance tasks like compacting, repairing, and splitting databases for multi-user environments.
Prerequisites & Certification
- Requirements: Most courses require basic familiarity with the Windows environment and file management.
- Professional Alignment: Many 2016 courses are specifically designed to prepare students for the Microsoft Office Specialist (MOS)
Show More
Course Syllabus
The Microsoft Access 2016 syllabus is typically structured into modules that progress from foundational database design to advanced automation and security.
Module 1: Database Fundamentals
- Introduction to Access: Navigating the Ribbon, Quick Access Toolbar, and the Navigation Pane.
- Database Design Principles: Understanding relational structures, data mapping, and the three levels of Normalization.
- Creating Databases: Starting from scratch or using built-in templates to jumpstart projects.
Module 2: Working with Tables
- Field Properties: Defining data types such as Short Text, Long Text, Large Number, and AutoNumber.
- Primary & Foreign Keys: Assigning unique identifiers and establishing links between tables.
- Table Relationships: Creating one-to-many relationships and enforcing Referential Integrity.
- Data Entry: Managing records in Datasheet View, including sorting, filtering, and find-and-replace.
Module 3: Querying Data
- Select Queries: Using criteria and logical operators (AND/OR) to retrieve specific data.
- Calculated Fields: Building expressions to perform mathematical operations within a query.
- Action Queries: Automating bulk changes with Update, Append, Delete, and Make-Table queries.
- Specialized Queries: Designing Parameter, Crosstab, and Duplicate/Unmatched queries.
Module 4: Forms and User Interface
- Form Creation: Using the Form Wizard and "One-Click" form tools for rapid development.
- Design & Layout: Customizing headers, footers, logos, and tab orders for better navigation.
- Advanced Controls: Adding subforms, combo boxes, and applying Conditional Formatting.
Module 5: Professional Reporting
- Report Generation: Organizing information using Grouping and Sorting levels.
- Design Tools: Adding record counts, calculated totals (Sum/Avg), and page numbers.
- Subreports: Embedding detailed reports within a main report to show complex data relationships.
Module 6: Automation and Advanced Management
- Macros: Automating common tasks like opening forms, running queries, or validating data entry.
- External Data: Importing from and exporting to Excel, text files, or linking to other Access databases.
- VBA Basics: Introduction to Visual Basic for Applications for more complex custom functionality.
- Database Utilities: Compacting/repairing, backing up, splitting databases for multi-user access, and encrypting with passwords
Bestseller
