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
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
Best Practice Training is an independent provider of project management and IT service management training courses.
Since our formation in 2011, we have successfully delivered training courses to both the public and private sectors throughout the UK and internationally.
Our Values
Our main goal is to make a positive difference to your organisation. What you learn should have a direct, lasting impact on your future at a business and personal level. How do we achieve this?
Who We Are?
Best Practice Training is an independent provider of project management and IT service management training courses.
Since our formation in 2011, we have successfully delivered training courses to both the public and private sectors throughout the UK and internationally.
What We Aim to Do?
We aim to have enduring relationships with our customers. Best Practice Training provides authorised certification from highly reputed certification bodies.
What matter to us is teaching to bring real and long-lasting benefit to your work. Our main objective is to provide the highest quality of training so that you can enhance your career in your industry.
What Do We Provide?
Best practice Training provides you with a large variety of professional courses to help you develop your skills. We will help you to implement learned skills effectively in your business.
The variety of courses that we deliver range from Project Management, Technical IT, Systems Architecture, Business Skills, Cyber Security and much more.
This three day Office 365 Organisational Transformation Programme aims to upskill leaders and managers on how the suite of Office 365 apps can be developed to transform the performance, productivity and operation of any organisation.
Collaborate more effectively to create professional documents, and effortlessly communicate using mail merge.
Microsoft Visio course is offered by Olas. Olas uses a variety of delivery methodologies and believe a blended learning approach leads to the participants retaining the knowledge learnt through the learning event.
This Microsoft Excel Foundation Training Course can be tailored to suit the unique demands of your business. Jemco can deliver training at the client’s premises if required, whether Glasgow, Edinburgh or throughout Scotland and the UK.
In Access VBA you will learn how to extend the functionality of Access using a programming language called Visual Basic for Applications (VBA). With VBA you can create code which will allow you to automate the functionality of your database.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy