Microsoft Access Intermediate - Nationwide

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.

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

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.

Before taking this Microsoft Access course, students are recommended to take the following course, or have equivalent knowledge:

• Microsoft Access Introduction

Being proficient in Microsoft Access can open the door to many career opportunities such as:

• Database Developer
• Data Analyst
• Business Analyst

Certificate of completion

Digital certificate - Included