YOUR CART
- No products in the cart.
Subtotal:
€0
Overview
This course starts by reviewing the design concepts for building a robust relational
model. You will gain a fast, practical and extensive knowledge of the powerful
features of Microsoft Access, learning how to build tables, forms, queries, reports
and macros.
Course Objectives
This advanced course is designed for users familiar with Microsoft Access who aim to maximize its potential. You'll master complex queries, create dynamic forms and reports using VBA, and optimize database performance with advanced techniques.
See also
Other Office applications Word, Excel, PowerPoint and Outlook outlines for further ways to continue your learning path
Content
Tables
- Tables: Adding Fields & Specifying Data Types
- Advanced Field Properties
- Primary Key – Simple & Composite
- Indexing
Data Modelling
- Designing Relational Databases.
- Data Anomalies
- Database Normalisation
- Data Modelling Tips
- Referential Integrity Relationships
- One to One, One to Many & Many to Many
SQL SELECT QUERIES
- SQL Order by Clause, Group by Clause & Where Clause
- Parameter Queries
- Combining Clauses
- Aggregate Functions such as SUM, MIN, MAX, AVG, COUNT
- Action Queries: UPDATE, DELETE, APPEND
- Calculations in Queries
Forms
- Form Design, Blank Form, Form Wizard, and Navigation Forms
- Sub Forms
- Working with Controls, and Layout Views
Reports
- Report Design, Blank Report, Report Wizard & Labels Report
- Working with Controls, and Layouts Advanced SQL
- Creating Data
- Reading Data from multiple tables
- Updating Data
- Deleting Data
- Make Table Query
- Joining Data from Multiple Tables: Inner Join. Left Join, Right Join & Outer Join
Visual Basic for Applications VBA
- Modules Subroutines and Functions
- Subroutine / Function Scope
- Creating Variables & Variable Scope
- Form Input / Output
- Conditional Logic & Boolean Logic
- Using Switchboards
- Macros: create, assign and edit
You will learn how to
- Master the essentials of building and refining tables.
- Master complex queries using SQL and advanced functions.
- Design dynamic forms and reports with advanced controls and VBA.
- Optimize database performance through normalization and indexing.
- Generate reports using the Report Wizard, manage controls, and format layout views.
- Utilize VBA to create modules, automate tasks, and develop macros for enhanced functionality.
- …and much more
Audience
Completion of Access Foundations
Course
Classroom and Virtual training options
Online Course Materials
Duration
2 Days
More Courses...
Contact us...
Relevant, industry-focused learning and development
Our expert trainers have a wealth of experience in providing corporate training. Whether you pick off-the-shelf professional diplomas or a customised online L&D Program, we provide relevant, engaging content for all employees.
