The Microsoft Access Masterclass training course provides the delegates with the knowledge to help them create and manage databases and their components.
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
Prerequisities
A basic knowledge of working in the windows environment is required though not mandatory.
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
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
MSP Training has successfully delivered numerous world class training solutions for over 16 years. Founded in 1998 as Pentagon, we are the longest serving independent provider of accredited courses for both corporate and public sector organisations and individuals in the world.
This has given us a great deal of experience in providing knowledgeable and service driven training experiences and solutions, so rest assured that we can configure training that will meet your needs.
If you’re in need of a course urgently, we can deliver almost any course you need, at a time and location that works for you. We pride ourselves in our reputation, where we are frequently recommended to new clients by existing clients.
How Do We Do All This.
Our expert team of procurers and trainers have the exact and unique experience required to source an accredited, on budget programme which will surpass the quality expectations of even the most discerning client.
Our long established foothold in the industry has given us a strong awareness that companies often struggle to find a professional administration and training organisation to fulfil their divers training requirements.
We’ve worked hard to make available training programmes which not only lead the field in price but also boast a wide choice of superb training centres in a whole range of locations, excellent quality of training, training methods that offer both interesting content and learning methods whilst being progressive at the same time, all on a practically unlimited supply of dates, both midweek and at weekends. Our excellent customer service team is on hand to support you and the course.
By partnering with the UK's finest training providers of MSP to ensure that whenever your programme takes place, you will receive the best training available.
Currently based in Maidenhead and operational around the whole UK, we have a choice of over 60 superb training centres at locations ranging from Bournemouth, Brighton and Dorking in the South to Exeter, Bristol and Cardiff in the West, Glasgow, Aberdeen and Edinburgh in Scotland and many more in between.
In larger city locations we often have a choice of more than one course in a week, with London sometimes offering more courses each week.
Through our partners we are also able to offer excellent Residential events that allow delegates to immerse themselves into their course and forget about the outside world, if only for a few days.
Whether you are a new user or have been using Visio for years, this course will vastly increase your understanding of Visio. Existing users will learn how to get the most out of Visio, break any bad habits, learn shortcuts and discover a massive range of hints and tips from our expert Visio trainer...
The ability to generate flowcharts, room layouts, and business plans within a tool like Microsoft Visio contributes to improved communication, streamlined operations, better decision-making, and a competitive advantage for businesses across various industries.
Collaborate more effectively to create professional documents, and effortlessly communicate using mail merge.
Microsoft OneNote is a computer program for free-form information gathering and multi-user collaboration. It gathers users' notes (handwritten or typed), drawings, screen clippings and audio commentaries. Notes can be shared with other OneNote users over the Internet or a network
The course starts with the concept of relational databases, it is a common known fact that users of Access either miss-understand or just don’t know how to create a database properly using a relational database structure.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy