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
- Navigating the Access environment
- Understanding Microsoft Access objects
- Working with the ribbon interface
Overview of Relational Database Theory
- Fields and records
- Keys
- Relationships
- Normalization
- Referential integrity
Table Construction - Basics
- Selecting field types and sizes
- Indexes
- Data validation rules
- Required fields
- Input masks
- Quick Parts
- Calculated fields
Creating and Utilizing Forms in Microsoft Access
- Building simple forms
- Navigating within forms
- Switching between form views
- Adding, editing, and deleting records
- Validating records and undoing changes
- Sorting, filtering, and using search boxes
- Adding combo boxes to 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 for data collection
- Managing responses
Queries in Microsoft Access
- Select queries
- Action queries overview
Finalizing the Project
- Generating reports
- Creating command buttons to activate forms, reports, and queries
- Designing a start-up form
- Implementing split database architecture (separating data from the application)
Requirements
Familiarity with the Microsoft Windows operating system.
Foundational 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.
