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 for Government
- Adapting the Access Environment for Government Use
- Overview of Microsoft Access Objects
- Working with the Ribbon in Microsoft Access
An Outline of the Theory of Relational Databases for Government
- Fields and Records
- Keys
- Relationships Between Tables
- Normalization Techniques
- Ensuring Referential Integrity
Constructing Tables - Basics for Government
- Selecting Field Types and Sizes
- Creating Indexes
- Implementing Data Validation
- Defining Required Fields
- Using Input Masks
- Utilizing QuickParts
- Creating Calculated Fields
Constructing and Using Forms in Microsoft Access for Government
- Creating Simple Forms
- Navigating Within a Form
- Switching Between Different Views of a Form
- Adding, Editing, and Deleting Records in a Form
- Validating Data and Undoing Changes
- Sorting, Filtering, and Using Search Boxes
- Incorporating Combo Boxes on Forms
Gathering Data from External Files for Government
- Importing Data from Other Databases
- Importing Text Files (CSV)
- Importing Excel Spreadsheets
- Joining Tables from External Databases
Collecting Information by Email for Government
- Creating Emails to Collect Information
- Managing Responses to Collected Information
Queries in Microsoft Access for Government
- Select Queries
- Reviewing Action Queries
At the End of the Training for Government
- Creating Reports
- Creating Buttons to Activate Forms, Reports, and Queries
- Designing a Starting Form
- Separating Data from Applications
Requirements
Familiarity with the Microsoft Windows operating system for government use.
Basic understanding of Microsoft Access databases or similar systems for government applications.
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.
