Microsoft Access Intermediate - Nationwide
Classroom based course with Post Course Support – All Level Introduction to Advance
Infero Training Ltd
Summary
Live Virtual training - £201.60 for 1 day training
Classroom training - £261.60 for 1 day...
- Certificate of completion - Free
- Tutor is available to students
Add to basket or enquire
Location & dates
King Street
MANCHESTER
Lancashire
M24PD
United Kingdom
Princes Square
LEEDS
West Yorkshire
LS14HY
United Kingdom
New Street Station Forecourt
BIRMINGHAM
West Midlands
B24ND
United Kingdom
Theatre Square
NOTTINGHAM
Nottinghamshire
NG16LG
United Kingdom
Overview
This intensive 1 day, hands-on course Microsoft Access Intermediate course helps you gain comprehensive, practical understanding of Access.
In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customise reports. Extending your knowledge of Microsoft Access will result in a robust, functional database for your users.
This course is suitable for anybody wanting to learn 2019, 2016, 2013, 2010 or 2007, as it cover all the aspects and differences between the versions.
You can choose either our Classroom training at one of our venues or Live, Instructor-led Virtual training from the comfort of your home.
.
Benefits of Studying Microsoft Access with Infero Training:
- CPD Accredited Classroom training in Small Groups for Max Focus
- Only Microsoft Approved Courseware and Exercise Files are used
- Free Assessment of Skills prior to booking
- Certificate of Completion & Complementary 12 Months Post Course Support
- Premier Locations, Latest Tech, Refreshments, OR We Come to You
- 100% Money Back Guarantee & Price Match Guarantee
- Bespoke Courses & Group Discounts from £89 per person
.
Certification
This Microsoft Access course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets. The Microsoft Certified Application Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.
Certificates
Certificate of completion
Digital certificate - Included
Description
Course Content
Lesson 1: Designing a Relational Database
Topic A: Relational Database Design
Topic B: Create a Table
Topic C: Create Table Relationships
Lesson 2: Joining Tables
Topic A: Create Query Joins
Topic B: Relate Data Within a Table
Topic C: Work with Subdatasheets
Lesson 3: Using Data Validation
Topic A: Use Field Validation
Topic B: Use Form and Record Validation
Lesson 4: Creating Advanced Queries
Topic A: Create Parameter Queries
Topic B: Summarise Data
Topic C: Create Subqueries
Topic D: Create Action Queries
Topic E: Create Unmatched and Duplicate Queries
Lesson 5: Organising a Database for Efficiency
Topic A: Data Normalisation
Topic B: Create a Junction Table
Topic C: Improve Table Structure
Lesson 6: Using Advanced Reporting Techniques
Topic A: Include Control Formatting in a Report
Topic B: Add a Calculated Field to a Report
Topic C: Add a Subreport to an Existing Report
.
Course Objectives
Upon successful completion of this Microsoft Access course, students will be able to:
- Design a relational database.
- Join tables to retrieve data from unrelated tables.
- Validate data entered into a database.
- Use advanced queries to manipulate your data.
- Organise a database for efficiency and performance, and to maintain data integrity.
- Customise reports to organise the displayed information and produce specific print layouts.
.
Testimonials
I chose Infero training due to a recommendation from a colleague. The course booking process was easy and straight forward. I chose to do an MS Access course which was on a 1-2-1 basis with the trainer.
The 1-2-1 method of training suited me as this meant the course ran at a speed that I was comfortable with. Upon returning to work, I had used my newly gained skills to create databases for the logging of our equipment, this wouldn't have be possible without the training at Infero.
The whole experience of using and attending Infero Training has meant that I have placed two of my staff on MS Office courses and I plan to send more staff MS Office training in 2014.
Mark Meade (Divisional Service Manager) from Vaillant Group
.
Having had no previous training on Microsoft office, I personally felt the need to enhance my (basic) skills and knowledge by enrolling on a course that would cater for my specific needs so that I could utilise these systems more effectively in the workplace.
The course offerings were perfect, as I was able to choose which level I felt I needed to attend (i.e. beginner, intermediate, advanced etc). Suada offered some very useful advice in deciding which course was most appropriate for me having established what level I was currently working to.
Due to the sessions being on a 1-2-1 basis with just myself and the trainer Huseyn, the course was run at my pace, which was ideal as I did not feel there was any rush to cover the agenda in the allotted time. The workbooks were/are excellent as they explained every step clearly, which was complimented by the trainers contribution. The powerpoint slides also clearly illustrated the discussion points we were covering which aided me whilst completing the exercises.
I found Huseyn to be very friendly, approachable and supportive on all three occasions I spent with him.
Although I have not yet had much of an opportunity in utilising my new skills and knowledge on the systems, they will come in very handy when we will finally be upgraded to Microsoft Office 2007 later in the year.
I thoroughly enjoyed the courses and would certainly recommend Infero should the need arise in the future.
Darren Carlin (Operations Training Officer) from TNT UK
Who is this course for?
This Microsoft Access course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, or creating advanced queries and reports.
Requirements
Before taking this Microsoft Access course, students are recommended to take the following course, or have equivalent knowledge:
- Microsoft Access Introduction
Career path
Being proficient in Microsoft Access can open the door to many career opportunities such as:
- Database Developer
- Data Analyst
- Business Analyst
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.