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 existing system
- Defining database components
- Normalization
- Establishing relationships between elements
- Naming conventions
- Creating a database
- Methods for creating tables (Design View, Wizard, Manual Entry)
- Data types
- Field properties
Records and Operations
- Adding and editing records
- Setting records
- Searching for records
- Copying tables
Creating a Relational Database
- Keys
- Table relationships
- Dependencies
Queries
- Creating queries
- Utilizing the Query Wizard
- Performing operations on query results
- Applying query criteria
- Calculations and operators within queries
Forms and Controls
- Types of controls
- Using AutoForm
- Utilizing the Form Wizard
- Properties of controls and forms
- Printing forms
- Creating subforms
- Headers and footers
Reports
- Creating reports
- Using AutoReport
- Utilizing the Report Wizard
- Sections
- Report properties
Additional Tools for Forms and Reports
- AutoFormat
- Special effects
- Opening a form at database runtime
- Adding graphics and spell checking
- Switchboards
Exporting, Importing, and Linking Data
Security
- Passwords
- Database encryption
- Security Wizard
Backups
Requirements
Understanding of the Windows operating system.
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)
Well structured. Good teaching techniques. Course well documented!
Sorin
Course - VBA For Access & Excel
perfect level of knowledge transfair
Pascal - 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.
