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 existing system
- Defining database components
- Normalization techniques
- Establishing relationships between elements
- Adhering to naming conventions
- Creating a database
- Methods for creating tables (Design View, Wizard, Data Entry)
- Understanding data types
- Configuring field properties
Records and Record Operations
- Adding and editing records
- Setting record parameters
- Searching for records
- Duplicating tables
Building a Relational Database
- Working with keys
- Establishing table relationships
- Understanding dependencies
Queries
- Creating queries
- Utilizing the Query Wizard
- Performing operations on query results
- Applying query criteria
- Executing calculations and using operators in queries
Forms and Controls
- Exploring control types
- Utilizing AutoForm
- Using the Form Wizard
- Configuring control and form properties
- Printing forms
- Creating subforms
- Working with headers and footers
Reports
- Generating reports
- Utilizing AutoReport
- Using the Report Wizard
- Understanding sections
- Configuring report properties
Additional Tools for Forms and Reports
- Applying AutoFormat
- Adding special effects
- Opening forms during database runtime
- Incorporating graphics and spell-checking
- Configuring switchboards
Exporting, Importing, and Linking Data
Security Measures
- Managing passwords
- Encrypting the database
- Utilizing the Security Wizard
Backups
Requirements
Familiarity with the Windows operating system.
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.
