catraining

 

Microsoft Partner

Microsoft Access Training in London

Microsoft Access 2019 Introduction

Audience: This course is designed for new or self-taught Microsoft Access 2019 users. The course will cover all aspects of database design and objects.

Course Duration: 2 days(2)

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

Course Location: This Microsoft Access 2019 Introduction 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:access training london
  • Understand the role of Microsoft Access objects
  • Plan a relational database
  • Create fields and tables
  • Create forms from scratch or using the Form Wizard
  • Understand Select queries
  • Create calculated fields
  • Produce Reports

 


Course Content

print this page
Module 1: Introduction to Microsoft Access
  • What is a Microsoft Access Table?
  • What is a Microsoft Access Query?
  • What is a Microsoft Access Form?
  • What is a Microsoft Access Report?
  • What is Tell Me? (new)
Module 2: Working with Microsoft Access
  • Starting Microsoft Access
  • Exploring Backstage View
  • Using the Access Ribbon
  • Opening an existing Microsoft Access database
  • Navigating Microsoft Access
  • Quitting Microsoft Access
  • Launch Access from a modern template (new)
Module 3: Working with Tables
  • Opening an existing Microsoft Access table
  • Adding, editing and deleting records
  • Finding specific records
  • Sorting and filtering the data
  • Hiding and unhiding columns
  • Printing the table
  • Freezing columns
  • Moving columns
  • Module 4: Planning a Microsoft Access Relational Database
    • Creating tables
    • Using Quick Start fields
    • Setting field properties
    • Setting the primary key
    • Defining relationships
    • Setting referential integrity
    • Creating lookups
    • Creating calculated fields
Module 5: Working with Forms
  • Creating a form with the Form Wizard
  • Editing a form
  • Opening a form
  • Adding, editing and deleting records
  • Find and replace records
  • Filtering data in a form
Module 6: Introduction to 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
  • Summarising data
Module 7: Microsoft Access Reports
  • Creating a report using the Report Wizard
  • Using Design View to modify a report
  • Previewing a report
  • Printing the reportMicrosoft

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.