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
Database Fundamentals for Government
- Analysis of the current system
- Define database items
- Normalization
- Relations between elements
- Naming standards
- Create a database
- Methods for creating arrays (Design View, Wizard, Inputting Data)
- Data types
- Field properties
Records and Operations on Records
- Adding and editing a record
- Setting the record
- Searching for records
- Copying tables
Create a Relational Database
- Keys
- Relations between tables
- Dependencies
Queries
- Create queries
- Using the Query Wizard
- Operations on query results
- Criteria for queries
- Calculations and operators in queries
Forms and Controls
- Types of controls
- Using AutoForm
- Using the Form Wizard
- Properties of controls and forms
- Printing forms
- Create a subform (Subform)
- Headers and footers
Reports
- Create reports
- Using AutoReport
- Using the Report Wizard
- Sections
- Properties of reports
Additional Tools for Forms and Reports
- AutoFormat
- Special Effects
- Opening a form at runtime in the database
- Adding graphics, spell check
- Switchboards
Exporting, Importing, and Linking Data for Government
- Passwords
- Database encryption
- Security Wizard
Backups
Requirements
Proficiency with Windows is essential for government operations and workflows.
21 Hours
Testimonials (4)
The trainings by our self
Andreas - Diehl
Course - Access Advanced
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.
Iwona - Universal-Investment-Gesellschaft mit beschrankter Haftung
Course - Access Intermediate
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
Course - Access VBA
I liked the examples and the way he explained.
