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
- Analyzing the current system
- Defining database elements
- Normalization
- Establishing relationships between elements
- Adhering to naming conventions
- Creating a database
- Methods for creating tables (Design View, Wizard, Data Entry)
- Data types
- Field properties
Records and Record Operations
- Adding and editing records
- Setting record properties
- Searching for records
- Copying tables
Creating a Relational Database
- Keys
- Linking tables
- Dependencies
Queries
- Creating queries
- Utilizing the Query Wizard
- Performing operations on query results
- Query criteria
- Calculations and operators in queries
Forms and Controls
- Types of controls
- Using AutoForm
- Using the Form Wizard
- Properties of controls and forms
- Printing forms
- Creating a subform
- Headers and footers
Reports
- Creating reports
- Using AutoReport
- Using the Report Wizard
- Report sections
- Report properties
Additional Tools for Forms and Reports
- AutoFormat
- Special Effects
- Opening a form at runtime
- Adding graphics and spell check
- Switchboards
Exporting, Importing, and Linking Data
Security
- Passwords
- Database encryption
- Security Wizard
Backups
Requirements
Familiarity with Windows.
21 Hours
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.
