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 interface
- Understanding Microsoft Access objects
- Utilizing the Ribbon interface
Overview of Relational Database Theory
- Fields and records
- Primary and foreign keys
- Establishing relationships
- Database normalization
- Enforcing referential integrity
Basics of Table Construction
- Selecting appropriate data types and field sizes
- Working with indexes
- Implementing data validation rules
- Defining required fields
- Configuring input masks
- Utilizing Quick Parts
- Creating calculated fields
Designing and Using Forms in Microsoft Access
- Building basic forms
- Navigating through forms
- Switching between different view modes
- Adding, editing, and deleting records
- Validating data and undoing changes within a record
- Sorting, filtering data, and using search boxes
- Incorporating combo boxes into forms
Importing Data from External Sources
- Importing data from other database files
- Importing text files (CSV format)
- Importing Excel spreadsheets
- Linking tables from external databases
Collecting Information via Email
- Designing email templates for data collection
- Managing and processing returned responses
Queries in Microsoft Access
- Working with select queries
- Reviewing action queries
Final Steps
- Generating reports
- Adding command buttons to launch forms, reports, and queries
- Setting up a startup form
- Splitting the database into front-end and back-end components
Requirements
Familiarity with the Microsoft Windows operating system.
Foundational knowledge of Microsoft Access or another comparable 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.
