Microsoft Access Masterclass

by Best Practice Training Limited Claim Listing

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 w

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Best Practice Training Limited Logo

img Duration

Enquire Now

Course Details

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.

 

Overview

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.

 

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

  • Southampton Branch

    Wessex House, Upper Market Street, Southampton

Check out more MS Access courses in UK

PCWorkshops Logo

MS PowerPoint Intermediate/Advanced

MS PowerPoint is really easy, but in this PowerPoint Training Courses, we cover most aspects in a fast-paced day, and attend the to more tricky aspects. This course is one-to-one to attend to specific aspects per delegate. Group training could be organised on request.

by PCWorkshops
Storm Training & Solutions Logo

MS Excel (Intro)

Learn how to make spreadsheet design easy in the comfort of your work place onsite, learn the fastest tips and tricks to use formulae and functions, relative vs absolute references, page set up and print. Learn valuable short cut keys and be more productive.

by Storm Training & Solutions [Claim Listing ]
NILC Training Logo

Microsoft Word Introduction Training Course

This course is designed to provide delegates with an introduction to the main operations of Microsoft Word. After completing this course, delegates will be familiar enough to use Microsoft Word on a day-to-day basis.

by NILC Training [Claim Listing ]
Best Practice Training Limited Logo

Microsoft Visio Masterclass

Microsoft Visio Masterclass intends to provide the delegates with the tips and tricks to enhance the usage of Visio for improving the productivity. Our well trained and highly qualified instructors made this course interactive and engaging.

by Best Practice Training Limited [Claim Listing ]
Chamber of Commerce Training Logo

Microsoft Word (Selected Intermediate & Advance Features)

This afternoon session is suitable for delegates with existing Word experience and who are required to produce longer Word documents.

by Chamber of Commerce Training [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy