Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Tables and Fields
- Indexes and their application
- Table validation rules
- Value lists
- Search fields
- Creating and utilising OLE Object data types
Queries
- Queries utilising the Union operator
- Crosstab queries
- Logical, date, text, conversion, and aggregate functions
- Identifying duplicate and unmatched records
Forms
- Designing subforms
- Displaying totals
- Opening subforms in a new window
- Defining default values for controls
- Adjusting form views
Reporting
- Numbering records within groups
- Generating multi-column reports
- Developing report templates
- Creating user-defined 'labels'
Charts
- Creating charts
- Embedding charts within forms and reports
- Editing and modifying charts
Macros
- Developing simple macros
- Using the Macros Wizard
- Adding conditions
- Linking macros to control events
- Methods for executing macros
- Creating macro groups
- Autoexec macro
- AutoKeys macro
- Testing macros in 'single step mode'
Switchboard Manager
Export and import data
- Exporting tables and queries
- Exporting reports as snapshots
- Exporting reports to Microsoft Word
- Importing data from other databases
- Importing text files (CSV)
- Importing Excel spreadsheets
- Linking tables from external databases
Database Relational Model and Database Integrity
- Foreign keys and methods to maintain consistency
- Cascade deletion and updating of related records
- Methods for joining tables
- Performing inner, outer, right, and left joins
- Joining tables without the 'join' clause
- Testing integrity
Database Tools and Maintenance.
- Compacting and repairing the database
- Backing up and restoring
- Using the Database Documenter
- Database replication
- Synchronisation
- Viewing dependencies between objects
Smart tags
Startup options
Requirements
Knowledge of Windows.
Basic understanding of Microsoft Access databases or similar systems.
21 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3900 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (3)
perfect level of knowledge transfair
Pascal - Diehl
Course - Access Advanced
I learned a lot of new things which will be useful for my tasks.
Zsolt - Diehl
Course - Access Advanced
The trainings by our self
