Microsoft Access Advanced
At the end of this course you will be able to use advanced features in the design of all major Access objects, apply simple automation to database objects using macros, use built-in database tools to manage a database, and work with external data to import, export and link data.
Complete Course Syllabus
Advanced Table & Query Design
- Advanced field and table properties, lookup fields, and naming conventions
- Managing inner joins, outer joins, and self-joins in queries
- Summarising and grouping data using Totals queries
Action, Crosstab & Parameter Queries
- Creating interactive Parameter Queries with prompts
- Building Action Queries: Make-Table, Append, Update, and Delete queries
- Summarising multi-dimensional data with Crosstab Queries and Find Duplicates/Unmatched queries
Advanced Forms, Subforms & Macros
- Enhancing forms with combo boxes, option groups, command buttons, and calculated controls
- Creating linked subforms, start-up forms, and custom Navigation Forms
- Automating tasks with single macros, submacros, conditional macros, and event triggers
Importing, Exporting & Database Maintenance
- Importing from and exporting to Excel, CSV, and other databases
- Linking external tables and managing the Linked Table Manager
- Object Dependencies, Database Documenter, Performance Analyzer, Compact & Repair, and database security
More Access / It Courses
Microsoft Access Introduction
At the end of this course you will be able to identify the common objects of an Access database, design and build the structure of a database, input and maintain data, design user-friendly data entry forms, search the database using queries, and generate reports from your data.
IT Beginners Course
This course will help you become more comfortable using a personal computer (PC) and, more specifically, the Windows interface, managing files and folders, browsing the web, using OneDrive, and creating and managing emails in Outlook.
Microsoft Excel Introduction
Master workbook navigation, efficient data handling, and essential formulas. Create professional-looking spreadsheets, design clear charts, and produce polished print-ready reports.