Microsoft Access: Access - Part 2 (Advanced)
Advanced Access over two days: validate input, organise databases for performance, create advanced queries, forms and reports, import and export data, automate with macros and VBA, and secure and distribute the database.
About this course
Advanced Access over two days: validate input, organise databases for performance, create advanced queries, forms and reports, import and export data, automate with macros and VBA, and secure and distribute the database.
What you'll learn
- Provide input validation features to promote the entry of quality data into a database.
- Organize a database for efficiency and performance, and to maintain data integrity.
- Improve the usability of Access tables.
- Create advanced queries to join and summarize data.
- Use advanced formatting and controls to improve form presentation.
- Use advanced formatting and calculated fields to improve reports.
Curriculum
- Create lookups within a table
- Work with subdatasheets
- Create query joins
- Create subqueries
- Summarize data
- Apply conditional formatting
- Create tab pages with subforms and other controls
- Apply advanced formatting to a report
- Add a calculated field to a report
- Control pagination and print quality
- Import and link data
- Export data
- Create action queries
- Create unmatched and duplicate queries
- Create subreports
- Create a navigation form
- Show details in subforms and popup forms
- Create a standalone macro to automate repetitive tasks
- Create a macro to program a user interface component
- Restrict records by using a condition
- Create a data macro
- Getting started with VBA
- Using VBA with form controls
- Back up a database
- Manage performance issues
- Document a database
- Split a database for multiple-user access
- Implement security
- Convert an Access database to an ACCDE file
- Package a database with a digital signature
- What Is Microsoft Copilot Chat?
- The Magic Prompt Formula
- Work Smarter with AI
Who it's for
Access users building more robust databases.
Before you start
- Access - Part 1 or equivalent experience.
Related courses
More in Microsoft Office & 365 Apps →Data Analysis and Visualization with Microsoft Excel
Microsoft Office & 365 Apps
View course →Microsoft Access: Access Part 1 (Introduction)
Microsoft Office & 365 Apps
View course →SQL Fundamentals - Part 1: Essential Querying Skills
Microsoft Data & Power BI
View course →55205 Mastering Microsoft Project 2016
Microsoft Office & 365 Apps
View course →55234 SharePoint 2016 Site Collections and Site Owner Administration
Microsoft Office & 365 Apps
View course →55238 SharePoint Online for Administrators
Microsoft Office & 365 Apps
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.