Level 2 Microsoft Access
-
I really loved that even though I was already aware of many subjects taught in the course, I really learnt more thing that I didn’t know of. So glad to have done this program, thanks so much to The Software Training Company and my classmates for making it easier!
← | →
-
This course was so easy to do and I found it very informative. Now at work I can see how to apply everything I learnt from Heather, my tutor. She was great and absolutely into the course. She was patient, understanding and was always looking to explain according to everyone’s needs. This is why I will like to thank her and this centre for providing me with such a good experience.
← | →
-
The Software Training Company Ltd has a great relationship with us for several years. The support and dedication they give to us on daily basis, by Heather’s hands is just amazing and this is why all the courses are so worth it. We really appreciate their support.
← | →
Course
In Royal Leamington Spa
Improve your professional career with this course!
-
Type
Course
-
Methodology
Inhouse
-
Location
Royal leamington spa
-
Duration
2 Days
-
Start date
Different dates available
To develop topics covered in the previous course and to introduce more advanced Access commands and functions.
The course will provide the delegates with the opportunity to explore the more sophisticated features and facilities of
Access. They will learn how to use complex query techniques, create efficient forms and reports, and use macros to
automate their work.
Facilities
Location
Start date
Start date
About this course
This course is designed for delegates who have a need to further their understanding of Access and identify how it can
be used to create a fully functional database system.
Delegates should have attended the 2 day Introduction to Access course or have gained thorough practical experience
and understanding of the basic design features of tables, forms, queries and reports.
Reviews
-
I really loved that even though I was already aware of many subjects taught in the course, I really learnt more thing that I didn’t know of. So glad to have done this program, thanks so much to The Software Training Company and my classmates for making it easier!
← | →
-
This course was so easy to do and I found it very informative. Now at work I can see how to apply everything I learnt from Heather, my tutor. She was great and absolutely into the course. She was patient, understanding and was always looking to explain according to everyone’s needs. This is why I will like to thank her and this centre for providing me with such a good experience.
← | →
-
The Software Training Company Ltd has a great relationship with us for several years. The support and dedication they give to us on daily basis, by Heather’s hands is just amazing and this is why all the courses are so worth it. We really appreciate their support.
← | →
Course rating
Recommended
Centre rating
Babcock Aldershot
Lorraine
Fraikin (HR)
Air Tanker
SFS
Subjects
- Powerpoint
- Access
- Database Design
- Database
- SQL
- Database training
- Computer Engineering
- Design
- IT Security
- Microsoft Access
- SQL Server
- Queries
- IT Systems
- Computer Science
- Office systems
- IT
- Access 2013
- Computering
- Microsoft
- Mirosoft Access
- Advanced Access
Course programme
Course content
Creating Powerful Tables
• Modify field and table properties
• Using validation rules
• Creating input masks
• Using lookups
Relational Database Summary
• The relational model
• Types of relationships
• Referential integrity
Advanced Queries
• Calculations using queries
• Performing custom calculations
• Parameter queries
• Table joins
• Finding unmatched and duplicate records
• Creating crosstab queries
• Common Access Functions
Advanced Form Design
• Creating and using sub forms
• Calculated fields and expressions
• The expression builder
• Combo and list boxes
• Page tabs
• Option groups and option fields
• Use of unbound fields
• Using sub reports
Reports Review
• Multiple table reports
• Parameter query reports
• Grouping and sorting data
• Adding calculated fields
Macros
• Creating and running a macro
• Command buttons
• Using macros in forms
• Grouping macros
• Using conditions in macros
• Synchronising forms
• Custom menus using menu builder
Events on Forms
• Form window events
• Keyboard events
• Data events
• Error and timing events
• Focus events
• Mouse events
• Attaching macros to events
Database Security
• Groups and users
• General approach
• Compacting, Repairing and encrypting databases
Level 2 Microsoft Access