Course not currently available
Access Intermediate Training Course
Course
Online
Description
-
Type
Course
-
Methodology
Online
The course participants will learn the terminology of relational databases, acquire the skills to design database applications, know the basic principles of creating forms and reports.
About this course
Knowledge of Microsoft Windows OS.
Basic knowledge of Microsoft Access database or other.
Reviews
Subjects
- Excel
- Access
- Database
- Database training
- Design
- Collecting
- MS Excel
- Microsoft Access
- Databases
- Database monitoring
Course programme
- Adapting the Access environment
- Microsoft Accessobjects
- Working with ribbon
- fields and records
- keys
- relationships
- normalization
- referential integrity
- type and size of fields selection
- indexes
- data validation
- required fields
- input mask
- quickparts
- calculated fields
- creating simple forms
- navigation in form
- switching between views of forms
- adding, editing and deleting records
- validation and undoing changes in the record
- sorting, filtering, and a search box
- combo box on a form
- importing data from other databases
- importing text files (CSV)
- importing Excel spreadsheets
- joining tables from other databases
- creating mail to collect information
- answers management
- select queries
- action queries review
- creating reports
- creating buttons for activating forms, reports, queries
- creating starting form
- separating data from applications
Additional information
Access Intermediate Training Course