Microsoft Access Masterclass

ABOUT THE PROGRAM

The Microsoft Access Masterclass training course provides the delegates with the knowledge to help them create and manage databases and their components. The users get to learn about tables, queries, forms, reports their data without having to consider the intricacies involved in doing so. Reports help them to get the data they wish to analyse, and Macros are used to automate certain tasks they wish to perform again and again. Delegates are also taught the uses of Sub-Forms and Sub-Reports i.e. when the user has to enter data in Master-Child form or retrieve data from multiple tables.

Data can be analysed and summarized using Pivot Tables, and also integrated with the web. The course will allow the delegates to learn various aspects related to the Microsoft Access database such as Designing databases, managing databases, performing backup and recovery, designing the graphical interfaces using Forms and reports and automating tasks with Macros and other utilities.

  • Learn to work with Tables and Queries in MS Access

  • Understand the various types of Queries

  • Learn how to build a Graphical Interface for entering data into Access tables

  • Automate Tasks using Access Macros

  • Perform Administrative tasks in MS Access to safeguard your data

  • Perform Administrative tasks in MS Access to safeguard your data

WHAT'S INCLUDED ?

Find out what's included in the training programme.

Includes

Key Learning Points

Clear and concise objectives to guide delegates through the course.

Includes

Courseware

Courseware will also be provided to the delegates so that they can revise the course after the training.

Includes

Certificate

Delegates will get certification of completion at the end of the course.

Includes

Tutor Support

A dedicated tutor will be at your disposal throughout the training to guide you through any issues.

PREREQUISITES

A basic knowledge of working in the windows environment is required though not mandatory.

TARGET AUDIENCE

Anybody having the basic skills to work with windows applications can attend this course. The following are liable to sit for the course:

  • Data Analysts
  • Data Administrators
  • Individuals who are new to the Access Database

WHAT WILL YOU LEARN?

  • Learn to Navigate the Microsoft Access environment
  • Understand the various ways to write queries
  • Know about the various query types
  • Build Forms and Reports based on Queries
  • Automate tasks using Macros
  • Understand how to create a Master-Child relationship in Access Forms
  • Learn to embed Sub-Reports in a report
  • Share data with other Microsoft native applications
  • Retrieve data from unrelated tables

Enquire Program

Fill in the form below & we'd get back to you.

PROGRAM OVERVIEW

The delegates, during the course, are introduced to managing databases using MS Access. They learn about the various features of MS Access such as Tables, Relationships, Queries, Forms, Reports, and Macros. Besides they are also introduced to tools that help them to administer the database for purposes such as backup and recovery. The delegates also learn how to protect their data from unauthorised access by the use of encryption techniques.  With this course the delegates gain the knowledge required of them to design relational databases, write complex queries, customise reports, perform validations, and modify existing data effectively whenever and wherever required.


PROGRAM CONTENT

Fundamentals of MS Access

  • Why use a database?
  • Database Designing Approaches
    • Top-Down
    • Bottom-Up
  • Collecting Information
    • Data mapping
    • Sample data map
  • Normalisation – The three Normal Forms
  • Naming Conventions
  • Relationships in a Database
  • Normalisation of Data

The Microsoft Access User Interface

  • The Ribbon
  • Quick Access Toolbar
  • Object Navigation Pane
  • Work Surface
  • Access Options Dialog Box
  • Database Creation Wizard

Microsoft Access Reports

  • Generating reports
  • Add controls to a report
  • Improve the appearance of a report
  • Preparing to Print a report
  • Organise report information
  • Formatting reports

Tables

  • Creating an access database from a Template
  • Create a new blank database
  • Understand the different data types in Microsoft Access
  • Determine data types
  • Designing Tables

Handling Queries

  • Building simple queries
  • Understanding About Dynasets
  • Specifying Criteria for Queries: exact match and range operators
  • The AND and OR operators in a Query
  • Wildcard Characters
  • Using keywords
  • Sorting and hiding fields
  • Basing Queries on Multiple Tables

Forms

  • Forms
  • Altering Forms
  • Add Records in Form View
  • Navigating Records using Forms
  • The Layout
  • The Design View
  • One-Click Forms

Advanced Query Techniques

  • Create query joins to return data
  • Create Find Unmatched and Find Duplicate Queries
  • Create Parameterized Queries
  • Using LIKE, and IN in Queries
  • Extracting TOP X records using a query
  • Review calculated query fields
  • Summarise query data with totals
  • Using a WHERE statements in Summary queries
  • Creating a Cross Tab Query

Share Data with other Applications

  • Export table and queries to Excel
  • Import records from Excel
  • Import from a Text file
  • Export to a Text file
  • Link external sources
  • Using Merge in an SQL Query

Maintaining the Access Database

  • Perform Backup and Recovery
  • Compact a Database
  • Repairing a Database
  • Templating Databases
  • Protecting A Database using Encryption
  • Configure Database Options
  • Assign A Form to Open At Start Up
  • Use Database Tools

Microsoft Access Masterclass Enquiry

 

Enquire Now


----- OR -------

Reach us at 0121 368 7851 or info@msptraining.com for more information.

ABOUT Eastleigh

Eastleigh is located in Hampshire, UK. It is one of the main cities in the area of Eastleigh. The town is the part of South Hampshire and lies between Winchester and Southampton. The foremost considerable development was a railway town. The city located on River Itchen is one of the Uk’s premier chalk streams.

 

History:

Eastleigh is situated on the ancient Roman road that was constructed in 79 A.D. between Bitterne and Winchester. During the Roman era, the Eastleigh area was dominated by Roman people as it was confirmed after the excavation of coffins, their remains and others weapons. A record shows the existence of village named Saxon village since 932 A.D.

One more additional evidence of the presence of the Romans was declared in a survey conducted by TIME. King Ethelstan granted some portion of land in North Stoneham during military aid. There is one museum called Eastleigh Museum in the town. It is located in the High Street, and it holds the information regarding the city and the nearby villages.

 

Education:

There are two colleges for further education in Eastleigh including Eastleigh College and Barton Peveril Sixth Form College. Norwood Primary School, the Crescent Primary School, Cherbourg Primary School are famous primary schools that are giving services to the northern city. Crestwood College is the only secondary school in the town.

 

Religion

In the early 1930s, the church was founded called Emmanuel Baptist Church. It is located in the former Desborough Mission Hall.

 

Sport:

Eastleigh F.C.

It is the only senior football team that is playing from 2014-2015 in the Conference Premier.

 

Solent Kestrels

The game of basketball is very prominent in the region, and Solent kestrels are the most followed basketball club here. The region's club represented in the second highest level sports event, i.e. the English basketball league division. It was promoted from 2nd division to first when it became champions in a 2015-2016 season. The team usually play under the supervision of coach Matt Guymon and mostly play its game at Fleming Park Leisure centre.

 

Eastleigh Ladies Hockey Club

Situated in South Hampshire, Eastleigh Ladies Hockey Club fields two teams in Hampshire Women’s League along with playing floodlit and indoor league games.

 

Eastleigh Rugby Football Club

“The Hub” is the source through which the Eastleigh Rugby Football Club plays. Presently, there are four senior sides, colts and young player improvement.

 

Eastleigh Running Club

Eastleigh has a broadly based running club for those who are interested in running.

 

Politics

MP Mims Davies represents the House of Commands in Eastleigh. In general election of 2015, she was designated for the constituency with a majority vote of 9,147. She won against the Mike Thornton of Liberal Democrats who was elected at the elections of 2013 with the majority of 1,771 votes. Prior to 2005, the Eastleigh constituency MP was David Chidgey and later on, this seat was won by Huhne.

 

Transport:

Rail

Eastleigh has a famous railway station named as Eastleigh railway station. It is the foremost railway station that is located on the South Western Main Line. It provides fast and regular services to Winchester to Southampton, Poole and Bournemouth. It is connecting station for other two routes namely Eastleigh-Romsey Line and Eastleigh-Fareham.

 

Air

Eastleigh has 20th largest airport in England namely Southampton Airport. It is served by a dedicated machine railway station that is nest station stop from Eastleigh railway station.

 

Bus

The bus services are provided by Bluestar, Briijan Tours, Stagecoach, First Group Hampshire, Xelabus and Wilts and Dorset.

 

Road

The M3 and M27 motorway are also giving access to travellers owing to its location near to the junction point of Eastleigh town.