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
Microsoft Access
- Adapting the Access interface
- Understanding Microsoft Access objects
- Navigating the Ribbon
Overview of Relational Database Theory
- Fields and records
- Keys
- Relationships
- Normalization
- Referential integrity
Building Tables - Fundamentals
- Selecting field data types and sizes
- Indexes
- Data validation rules
- Required fields
- Input masks
- Quick Parts
- Calculated fields
Designing and Utilizing Forms in Microsoft Access
- Creating basic forms
- Navigating within forms
- Switching between different form views
- Adding, editing, and deleting records
- Validating and reversing changes within a record
- Sorting, filtering, and using search boxes
- Incorporating combo boxes in forms
Importing Data from External Sources
- Importing data from other databases
- Importing text files (CSV)
- Importing Excel spreadsheets
- Linking tables from external databases
Gathering Information via Email
- Creating email templates for data collection
- Managing incoming responses
Queries in Microsoft Access
- Select queries
- Review of action queries
Finalizing the Application
- Creating reports
- Designing buttons to launch forms, reports, and queries
- Setting up a startup form
- Separating backend data from the front-end application
Requirements
Knowledge of the Microsoft Windows operating system.
Foundational knowledge of Microsoft Access or another database management system.
14 Hours
Testimonials (1)
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.
