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
- Core objects within Microsoft Access
- Navigating the Ribbon
Overview of Relational Database Theory
- Fields and records
- Keys
- Relationships
- Normalization
- Referential integrity
Table Creation - Fundamentals
- Selecting field types and sizes
- Indexes
- Data validation
- Mandatory fields
- Input masks
- Quick Parts
- Calculated fields
Creating and Utilizing Forms in Microsoft Access
- Building simple forms
- Form navigation
- Switching between form views
- Adding, editing, and deleting records
- Record validation and undoing changes
- Sorting, filtering, and using a search box
- 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
Collecting Information via Email
- Designing emails to gather information
- Managing responses
Queries in Microsoft Access
- Select queries
- Overview of action queries
Conclusion
- Creating reports
- Developing buttons to launch forms, reports, and queries
- Setting up a startup form
- Decoupling data from applications
Requirements
Familiarity with the Microsoft Windows operating system.
Fundamental 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.
