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
- Customising the Access environment
- Microsoft Access objects
- Working with the Ribbon
An overview of relational database theory
- Fields and records
- Keys
- Relationships
- Normalisation
- Referential integrity
Building tables – fundamentals
- Selecting field types and sizes
- Indexes
- Data validation
- Required fields
- Input masks
- Quick Parts
- Calculated fields
Creating and using forms in Microsoft Access
- Creating simple forms
- Navigating within a form
- Switching between form views
- Adding, editing and deleting records
- Validating and undoing changes to records
- Sorting, filtering and using the search box
- Using combo boxes in forms
Gathering 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 emails to collect information
- Managing responses
Queries in Microsoft Access
- Select queries
- Review of action queries
At the end
- Creating reports
- Creating buttons to activate forms, reports and queries
- Creating a startup form
- Separating data from the application
Requirements
Knowledge of the Microsoft Windows operating system.
Basic knowledge of Microsoft Access or similar database systems.
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.
