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 practical application
- Implementing validation rules within tables
- Utilizing value lists
- Configuring search fields
- Creating and employing the OLE Object data type
Queries
- Constructing queries with the Union operator
- Developing Crosstab queries
- Applying logical, date, text, conversion, and aggregate functions
- Identifying duplicate and unmatched records
Forms
- Designing subforms
- Displaying totals
- Opening subforms in separate windows
- Establishing default values for controls
- Modifying form view settings
Reporting
- Numbering records within groups
- Designing multi-column reports
- Developing report templates
- Creating custom "labels" for users
Charts
- Generating charts
- Embedding charts into forms and reports
- Editing and customizing chart properties
Macros
- Building simple macros
- Utilizing the Macros Wizard
- Incorporating conditional logic
- Associating macros with control events
- Methods for executing macros
- Organizing macro groups
- Configuring the AutoExec macro
- Setting up AutoKeys macros
- Debugging macros using "single step mode"
Switchboard Manager
Handling data export and import processes
- Exporting tables and queries
- Exporting reports as snapshots
- Exporting reports to Microsoft Word
- Importing data from external databases
- Importing text files (CSV format)
- Importing Excel spreadsheets
- Linking to tables from other databases
Database Relational Model and Integrity
- Understanding foreign keys and maintaining consistency
- Implementing cascade delete and update operations
- Methods for joining tables
- Performing inner, outer, right, and left joins
- Joining tables without explicit "join" clauses
- Verifying referential integrity
Database Tools and Maintenance
- Compacting and repairing the database
- Creating backups and restoring data
- Using the Database Documenter
- Implementing database replication
- Synchronizing data
- Viewing object dependencies
Smart tags
Startup options
Requirements
Familiarity with the Windows operating system.
Foundational knowledge of Microsoft Access or another database management system.
21 Hours
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
