Course description
Access: Intermediate (In-House)
This course is designed for people who want to discover more about the features and operations in Microsoft Access so that they become more efficient when manipulating and analysing data. The course quickly takes you from beginner level to more advanced topics.
Upcoming start dates
Suitability - Who should attend?
This course is suitable for existing users of Microsoft Access who wish to build on their knowledge, or for those who have completed our Level 1 course and wish to progress further.
Course Pre-Requisites
Delegates should have previous experience with Microsoft Access and basic knowledge within the package.
For more information on suitability, please send an enquiry here
Training Course Content
Advanced Table Design
- Attachment fields
- Multiple value fields
- Lookup fields
- Advanced field properties including Input Masks
- Multiple field primary keys
- Multiple field indexes
- Using the Access Documenter
Relational Concepts
- Relational concepts & rules
- Data structure principles
- Types of relationship
- Referential integrity
Multiple Tables and Forms
- Using a combo box in forms
- Combo box properties
- Lookup properties
- Creating forms with subforms
- Editing sub forms
- Tabbed sub forms
- Embedding sub forms using drag & drop
Advanced Select Queries
- Filter by form
- Advanced Filter/Sort
- Convert filter to select query
- Duplicate records query
- Unmatched records query
- Working with multiple tables
- Understanding query join types
- Concatenating fields
- Calculations in queries
- Using string functions
- Using date functions
- Using the immediate if function Using wildcards & parameters
Advanced Reports
- Working with multiple tables
- Concatenating fields
- Date & time functions
- String functions
- Custom styles
Why choose SquareOne Training
25 years' experience of delivering quality IT Training Services
All trainers Certified Microsoft Office Trainer (MOS) or higher
Public and in-house training throughout the UK
Expenses
This training course will be delivered in the form of a closed course at your company's premises and can be custom tailored to meet the needs and requirements of your particular organisation.
SquareOne can come to you no matter where you are based throughout the UK or Europe. The cost of this training course is available upon request.
Please send an enquiry here
Request info
SquareOne Training
With 30 years of experience in IT training, personal skills, and consultancy, SquareOne specialise in crafting and delivering exceptional industry leading training courses. Our extensive range of courses are tailored to cater to a diverse range of learning preferences and...
Case Studies
SquareOne Deliver IT Rollout Projects to a World Leading Gas and Oil Company
Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.
Excel Templates For Mexichem
At SquareOne Training we take pride in designing Spreadsheets for our customers, so we were delighted to be asked to design a solution to track staff courses and KPI alerts. This spreadsheet was implemented in 2018, but completely changed the way the company worked and made the data not only accurate but trackable.