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
Database Fundamentals
- Analysis of the current system
- Define database items
- Normalization
- Relations between the elements
- Naming standards
- Create a database
- Methods for creating arrays (Design View, Wizard, Inputting Data)
- Data types
- Field properties
Records and operations records
- Adding and editing a record
- setting the record
- Search record
- Copying tables
Create a relational database
- Keys
- Relations tables
- Dependencies
Queries
- Create queries
- Using the Query Wizard
- Operations on the results of the query
- criteria query
- Calculations and operators in queries
Forms and controls
- Types of controls
- Using AutoForm
- Using the wizard forms (Form Wizard)
- Properties of controls and forms
- Printing forms.
- Create a subform (Subform)
- Headers and footers
Reports
- Create reports.
- Using AutoReport
- Using the Report Wizard (Report Wizard)
- Sections
- Properties reports
Additional tools for forms and reports
- AutoFormat
- Special Effects
- Open a form at runtime database
- Adding graphics, spell check
- Switchboards
Exporting, importing and linking data
Security
- Passwords
- Database encryption
- Security Wizard
Backups
Requirements
Knowledge of Windows.
21 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €6840 online delivery, based on a group of 2 delegates, €2160 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (5)
The trainings by our self
Andreas - Diehl
Course - Access Advanced
Our group was not that big so every time we asked a question we received an extensive answer with examples. So everything was well explained and it can be noticed that trainer has a great knowledge.
Iwona - Universal-Investment-Gesellschaft mit beschrankter Haftung
Course - Access Intermediate
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
Course - Access VBA
The training started for the early beginners, so everybody could get to know what all is about.
Amanda Dzida
Course - Access - podstawy
I liked the examples and the way he explained.
