catraining

 

Microsoft Partner

Microsoft Access Training in London

Microsoft Access 2016 Intermediate

Audience: This course is designed for those who have a working knowledge of Access and would like to develop further knowledge of its wider capabilities. It is ideal for those who wish to interrogate existing Access databases, create queries and reports as well as gaining an insight into the fundamentals of database design using Tables and Relationships.

Course Duration: 1 day(1)

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and Saturday club.

Course Location: This Microsoft Access 2016 Intermediate training course is delivered at our training centre in London situated close to Liverpool Street station; training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

 

MOS Excel Specialist / Expert Exam Costs ( optional )

 

All Vouchers now include a Retake Voucher
Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

 

View Scheduled Public Courses

 

 

After completing this course, students will be able to:reaining course
  • Set field properties in Tables
  • Design Advanced Queries
  • Create Table Relationships
  • Work in Form Design View
  • Work In Report Design View
  • Use Sub forms and Sub reports

 

 


Course Content

print this page
Module 1: Table Design
  • Setting advanced field properties in tables
  • Input masks
  • Validation rules
  • Default values
  • Lookup fields
  • Creating Calculated Fields on Tables
  • Relating Tables and the different types of Relationships
Module 2: Creating Relationships between Tables
  • Creating Relationships
  • Different Relationship types
  • Viewing subdatasheets
  • Setting referential integrity
  • Cascade options
Module 3: Select Queries
  • Select queries explained
  • Creating select queries
  • Working with query views
  • Adding and deleting fields
  • Sorting records in the Design View
  • Using query criteria
  • Adding calculated fields
Module 4: Designing Advanced Queries
  • Setting join types between tables and queries
  • Setting top values in a query
  • Creating Calculated fields
  • Creating Summary queries
  • Grouping queries
  • Creating Parameter queries
Module 5: Action Queries
  • Update Query
  • Make Table Query
  • Delete Query
  • Append Query
  • Union Query
Module 6: Working in Form Design View
  • Manipulating controls in form design view
  • Changing form and control properties
  • Adding controls to a form
  • List boxes, Check boxes and Option buttons etc.
  • Using calculations on forms
Module 7: Working in Report Design View
  • Manipulating controls in a report
  • Changing report control properties
  • Managing sorting and grouping in reports
  • Adding calculations to a report
  • Controlling pagination
Module 8: Using Sub forms and Sub reports
  • Creating Sub forms
  • Creating Sub reportsaccess training london

Call us now for further information Tel:08001601666

Access training london delivering all your training needs

VENUE
We offer a state of the art training venue in the heart of London, with a variety of dedicated training and conference rooms. We can also provide training at client sites.
TRAINING FACILITIES  
At our training venue, every student is provided a 23” Touch screen monitor. All rooms have ceiling mounted projectors and facilitators’ computers. We also have a dedicated Apple training room.
For onsite courses in the London Postcode area, we can supply up to ten laptops to support training courses if required .

TRAINING MATERIALS
On completion of our courses students will be given unlimited access to our online materials.