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
- Customizing the Access interface
- Understanding Microsoft Access objects
- Navigating and utilizing the Ribbon
Overview of Relational Database Theory
- Fields and records
- Keys
- Relationships
- Normalization
- Referential integrity
Table Construction - Basics
- Selecting field types and sizes
- Using indexes
- Data validation
- Setting required fields
- Configuring input masks
- Utilizing Quick Parts
- Creating calculated fields
Designing and Using Forms in Microsoft Access
- Creating simple forms
- Navigating within forms
- Switching between form views
- Adding, editing, and deleting records
- Validating and undoing record changes
- Sorting, filtering, and using search boxes
- Implementing combo boxes on forms
Importing Data from External Files
- Importing data from other databases
- Importing text files (CSV)
- Importing Excel spreadsheets
- Linking tables from other databases
Collecting Information via Email
- Creating mailouts to gather information
- Managing responses
Queries in Microsoft Access
- Select queries
- Action queries overview
Final Topics
- Creating reports
- Adding buttons to launch forms, reports, and queries
- Setting up a startup form
- Implementing front-end/back-end architecture to separate data from applications
Requirements
Familiarity with the Microsoft Windows operating system.
Basic knowledge of Microsoft Access or another database 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.
