Microsoft Access 2013 – Intermediate

Global Edulink

Add to wishlist

Duration / Course length: Upto 6 Hours Start now
Accredited by: CPDiAP
Certificates:
Sample certificate
Course delivery: This course is delivered in video format

Course details

On this Microsoft Access 2013 intermediate course, provided by Global Edulink, a well-respected provider of online training courses globally, you are skilfully guided through the use of the software by qualified trainers who are specialists in their field of work. We make it easy for you to understand the intermediate aspects of this application, such as relational database design, joining tables and querying their joints, efficient organisation of databases, import and export of data to and from Access, useful mail merges and, finally, its advanced reporting tools.

Microsoft Access 2013 is the number one database application in the world and is designed to make databases easier to create and use. It’s used to store a set of information, query that information, build easy-to-use graphical interfaces, and create reports on the stored data.

Many businesses use Microsoft Access, from small one-person outfits to the largest corporations world-wide, because it’s easy to maintain and requires very little infrastructure to support. Understanding Access is vital to real-world database use and, at Global Edulink, our course will furnish you with skills that we believe can certainly progress your career.

COURSE CURRICULUM

Module 1 : Relational Database

Relational Database Design
Create a Table – Access
Create Table Relationships

Module 2 : Joining Tables

Create Query Joins
Join Tables That Have No Common Fields
Relate Data within a Table
Work with Subdatasheets
Create Subqueries

Module 3 : Organizing a Database for Efficiency

Data Normalization
Create a Junction Table
Improve Table Structure

Module 4 : Import and Export the Data

Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel

Module 5 : Mail Merge

Create a Mail Merge

Module 6 : Advanced Reporting

Organize Report Information
Format Reports
Control Formatting in a Report
Add a Calculated Field to a Report
Subreport to an Existing Report

Benefits you will gain:

High quality e-learning study materials and mock exams.
Tutorials/materials from the industry leading experts.
24/7 Access to the Learning Portal.
Benefit of applying TOTUM Discount Card.
Recognised Accredited Qualification.

Method of Assessment

At the end of the course, learners will also take an online multiple choice question assessment test. This online multiple choice question test is marked automatically so you will receive an instant grade and know whether you have passed the course.

Certification:

Successful candidates will be awarded certificates for Certificate in Microsoft Access 2013 Intermediate ;
Updated on 18 March, 2024

Eligibility / Requirements

This course is available to all students, of all academic backgrounds. However, basic IT skills would be an advantage.
Learners should be ages 16 or over to undertake the qualification.
Good understanding of English language, numeracy and ICT are required to attend this course.

Job roles this course is suitable for:

Software Engineer , Technical Support Engineer , Technical Sales Manager , Business Analyst , IT , Web Developer , Software Tester

About Global Edulink

Global Edulink – online education for a skill-hungry workforce

Education is just one aspect of life that can shape who you are and who you want to be as an employee. In a time-poor world, sometimes you need a flexible approach to help you achieve your goals. Online learning with Global Edulink offers just that – professional and vocational training to fit in with your life.
Global Edulink is well-established in the UK, but reaches out to learners all over the world. The company aims to bridge the gaps in a three step process of training, skills, and jobs, where you can learn at your own pace using interactive teaching techniques.
How the courses work

Learn with Global Edulink and you’ll have the opportunity to gain insight and knowledge from tutors that are well qualified and experienced in their industry sector. Your tutor will be your mentor and support during your learning journey.

Because each course combines practical and theory, you’ll pick up essential knowledge and gain the confidence to put it into practice at the same time.
High-quality course materials are provided, which you can access at any time during the course, which will help strengthen your knowledge and help you to perform well in the workplace.
You’ll find a course structure focused around modules, which can have mock and final exams at the end, with pass grades and diplomas awarded on completion. Some courses will lead to professional qualifications assessed and awarded by external bodies such as NCFE, PEARSON, and PEOPLECERT etc.
Browse through the course guides and you will find details on any skill level or entry requirements, who the course is best suited to and what you can hope to achieve and build on while you learn. Some courses require no prior knowledge or experience, while others are for those already in a specific job or with some experience to build on. The course details also cover the method of assessment and length of course.

275 students have enrolled with Global Edulink through Laimoon

See all Global Edulink courses

Pay & enrol now