Course Introduction

Microsoft Access is an information management tool that allows the users to analyse and manage a large amount of data more efficiently than any other spreadsheet application. It is the database application in the Microsoft Office that help professionals to store information for referencing, reporting and analysis. The Microsoft Access Masterclass training course provides essential knowledge and skills required to enter, store, and retrieve data for referencing and creating reports. The course enables the delegates to create complex queries, make forms and build a database with a good relational structure. During the one day course, the delegates will learn how to create basic to advanced reports, design Access databases, manage interfaces with Access Forms and automate tasks with Macros and VBA.

Microsoft Access Masterclass

Microsoft Access is a database management program that allows the users to create databases and tables, build reports and structures and insert the queries into the tables to achieve the desired results. The course familiarizes delegates to the various concepts and terminologies related to MS Access, identify how to automate the processes using macros, manipulate the data using advanced queries and customise reports for organising the information displayed to have specific print layouts. During the course, the candidates will learn how to design and build a database, how menus and ribbons work, constructing tables and table relationships, create subtotals and do calculations, how Macros can be used to automate tasks, create queries to search and interrogate their data and how Access can work with other Microsoft Office programs.

Course Content

Fundamentals of MS Access

  • Basic queries
    • Purpose and users of database
    • Output type
  • Methods for designing Database
    • Top-Down
    • Bottom-Up
  • Collect Information
    • Data mapping
    • Sample data map
  • Normalisation
    • 1stNF
    • 2ndNF
    • 3rdNF
  • Naming Conventions
  • Table Relationships
    • Different types of relationships
  • Normalisation of Data

Introduction to User Interface

  • Access Ribbon
  • Quick Access Toolbar
  • Object Navigation Pane
  • Work Surface
  • Access Options Dialog Box
  • Create a database using Wizard

Generate Reports

  • Build a report
  • Add controls to a report
  • Improve an appearance of a report
  • Preparing a report for print
  • Organise report information
  • Format reports

Tables

  • Creating an access database
  • Create a new database
  • Different data types
  • Determine data types
  • Create a table in design view

Handling Queries

  • Building simple queries
  • Learn Dynaset
  • Enter criteria: exact match and range operators
  • Understand difference between AND versus OR
  • Use of wildcards
  • Learn about use of keywords
  • Sort and hide fields
  • Create multi-table queries
  • Additional tips

Forms

  • Forms
  • Alter a form
  • Add data records in form view
  • Form record navigation
  • View of layout
  • Designing of a view
  • One-Click Forms

Advanced Query Techniques

  • Create query join
  • Create Find Unmatched and Find Duplicate Queries
  • Create Parameter Queries
  • Use Like keyword in Parameter Queries
  • Create a top X query
  • Review calculated query fields
  • Summarise query data with totals
  • Insert WHERE statements in Summary queries
  • Create a crosstab query Form Wizard

Share Data with other Applications

  • Export table and queries to excel
  • Import data from .txt file
  • Import data from excel
  • Export data to a .txt file
  • Link external sources
  • Use of word merge

Maintain a Database

  • Backup a Database
  • Recover a Database
  • Compact a Database
  • Repair a Database
  • Save a Database as a Template
  • Encrypt a Database
  • Configure Database Options
  • Set a Form as The Startup Form
  • Use Database Tools

Prerequisites

No formal prerequisites are required for attending the Microsoft Access Masterclass training course. However, the candidates should have basic knowledge of working with Window operating system and Microsoft Office 2010.

Target Audience

The Microsoft Access Masterclass training course is designed for anyone who wants to improve their knowledge and skill set with Access. These include:

  • Data Administrators
  • Data Analysts
  • Data Architects
  • Programmers

Delegates Will Learn How To

  • Get to know about the database and its related terminology
  • Learn how to create databases with objects
  • Work effectively with reports, data, queries and forms
  • Learn how to automate the processes using macros
  • Understand advanced Query techniques and forms
  • Learn to organise the database to maintain efficiency and performance
  • Customise reports for organising the information displayed to have specific print layouts
  • Discover the method to join tables for retrieving data from unrelated tables
  • Learn how advanced queries can be used to manipulate the data
  • Learn to plan and validate the data entered into the database

Training Solutions at Your Convenience

Our objective has always been to address and resolve the problems of our learners in an efficient manner and improve their learning prospects. We are accustomed in providing training courses as per our learner’s convenience. We love every opportunity to use our experience to resolve difficulties confronted by learners.

Microsoft Access Masterclass Training Calender

Filters

arrow
course-virtual

Bournemouth

Best Selling Course in Bournemouth

Fri

26

Nov

2021

£1495

Duration:

course-virtual

Cambridge

Best Selling Course in Cambridge

Fri

26

Nov

2021

£1295

Duration:

course-virtual

London

Best Selling Course in London

Fri

26

Nov

2021

£995

Duration:

course-virtual

Birmingham

Best Selling Course in Birmingham

Fri

26

Nov

2021

£995

Duration:

course-virtual

Manchester

Best Selling Course in Manchester

Fri

26

Nov

2021

£995

Duration:

course-virtual

Online Instructor-led(Virtual)

Best Selling Course

Fri

12

Nov

2021

£795

Duration:

course-virtual

Online Instructor-led(Virtual)

Best Selling Course

Fri

10

Dec

2021

£795

Duration:

Optional add-ons

6 Months Access - £109

Extend your access to match your schedule.

1 Year Access - £164

Give yourself as much time as you need to complete the course

Microsoft Access Masterclass

hours

40 Hours (on average)

days

90 Days Access

administration

40 Hours (on average)

  • Course Price

    £545

  • add-ons Price

    £0

  • Sub-Total

    £545

foundation-call Enquire Now

Upon purchase you will receive a password via the email you used to purchase the course.

You will then be able to login to our online learning platform with your email and password.

You will have access to the platform for 90 days from the date of purchase.

ONSITE ENQUIRY?

Fill up the form below and we will get back to you!

name name-red
email email-red
phone-call phonecall-red
house house-red
book book-red
position position-red
house house-red
comment comment-red
conference

Video Conferencing

We provide the best web conferencing platform(s) to facilitate our learners to enhance their communication with the instructor.

whiteboard

Digital Whiteboards

Our courses include the real-time demonstration of figures, diagrams and other interactive material through digital whiteboards.

messaging

Instant Messaging

During the Virtual Classroom session, learners can raise their queries through instant messaging and follow up on their doubts.

control

Participation Controls

Through participating effectively in training, individuals can easily discuss their views, mute their surroundings and virtually "raise" their hands.

Features of Our Virtual Classroom Courses

future

How to Choose and Attend Your Ideal Course?

FIND COURSES

We provide 400+ courses covering broader aspects of personal and professional development training needed by any individual. You can choose any course as per your need or requirement. Our courses are designed to fulfil the current organisational and job marketplace requirements.

search}

Select the Course

Choose the course you want to attend to fulfil your desired goals.

details}

Attend the Course

Attend the training with your prefered method at your convenience.

book}

Get Certification

Upon finishing the course, you will get the completion certificate validating your learning.

Microsoft Access Masterclass

£ 545 £ 495

Benefits of Attending Our Online Courses

We provide a variety of certification programmes or courses for individuals to master a skill set and pursue a full-time career in management, IT, or other domains through the online method to provide them with the convenience of learning. Our dedicated staff works tirelessly to assure the availability of courses with eminence quality that's not found anywhere with benefits like:

skilled

Get Tailored Programmes

affordable

Quick Delivery

flexible

Scalability and Consistency

access

90 Days Access

Learn a New Skill From Onsite Training

Adaptable Courses

We provide onsite courses modified according to our client's organisational needs.

Cost-Effective Learning

Onsite training helps you to reduce travelling and venue expenses.

Learn in Familiar Surroundings

Training at your convenient place can be ideal for learning new skills.

Team Building Opportunity

Attending onsite training with your team can help to improve your team dynamics tremendously.

name

name name-red
phone-call phonecall-red
email email-red
email email-red
comment comment-red
up-arrow
LOADING