• LOGIN
  • No products in the cart.

Microsoft Access is the world’s premier database management system, and is much more efficient compared to Excel. It is used in almost every industry, and now you can learn to use it too with the help of this Diploma in Microsoft Office 2013 Access course.

The course is divided into three parts and starts out with helping you get started with Access, work with table data, using & creating queries, generating reports and customizing the interface. Next you will move onto more intermediate concepts like relational database, joining tables, improving efficiency, collaboration, and reporting. The advanced portion of the course will help you implement advanced form design, use data validation, macros, advanced database management, and much more.

So stop wasting time, get this course now.

Course Highlights

  • Internationally recognised accredited certification on successful completion
  • Free accredited e-certificate
  • Study at your own pace, anytime and anywhere
  • Access to all courses with a monthly membership plan of £29
  • High quality video and text course materials
  • Efficient exam system, assessment and instant results
  • Improve your chance of gaining professional skills and better earning potential
  • Eligibility for NUS Extra card which gives you a discount from thousands of retailers

Requirements

There is no experience or previous qualifications required for enrolment on this course. It is available to all students of all academic backgrounds.

Assessment and Certification

You can test your learning as you progress through the course by undertaking mock tests. On completion of the course, there will be an assessment consisting of multiple choice questions for which the pass mark is 60%. On passing, you will gain instant access to your e-certificate.  PDF and hard copy certificates can be ordered for an additional fee.

  • PDF Certificate – £9
  • Hardcopy by Post- £19
  • Both PDF and Hardcopy – £24

Tutor Support

With all our courses, you will receive access to dedicated tutors and technical support. You will also be provided with unlimited email, phone and live chat support to help answer any questions you might have whilst studying the course.

Course Compatibility

All our courses are fully compatible with PC’s, Mac’s, tablets and smartphones.

Career Path

Completing this course will help you to increase your knowledge and improve your skills and instil in you the confidence to progress. You will also be able to add your qualification to your CV, enhance your career and become more competitive within your chosen industry.

Course Curriculum

Getting Started with Access
Orientation to Microsoft Access 00:48:00
Create a Simple Access Database 00:28:00
Get Help in Microsoft Access 00:05:00
Working with Table Data
Modify Table Data 00:13:00
Sort and Filter Records 00:06:00
Create Lookups 00:15:00
Querying a Database
Join Data from Different Tables in a Query 00:14:00
Sort and Filter Data in a Query 00:19:00
Perform Calculations in a Query 00:11:00
Creating Advanced Queries
Create Parameter Queries 00:11:00
Create Action Queries 00:08:00
Create Unmatched and Duplicate Queries 00:06:00
Summarize Data 00:09:00
Generating Reports
Create a Report 00:10:00
Add Controls to a Report 00:08:00
Enhance the Appearance of a Report 00:05:00
Prepare a Report for Print 00:03:00
Customizing the Access Environment
The Access Options Dialog Box 00:06:00
Designing a Relational Database
Relational Database Design 00:13:00
Create a Table 00:15:00
Create Table Relationships 00:10:00
Joining Tables
Create Query Joins 00:10:00
Join Tables That Have No Common Fields 00:04:00
Relate Data within a Table 00:06:00
Work with Subdatasheets 00:05:00
Create Subqueries 00:06:00
Organizing a Database for Efficiency
Data Normalization 00:13:00
Create a Junction Table 00:07:00
Improve Table Structure 00:05:00
Sharing Data Across Applications
Import Data into Access 00:12:00
Export Data to Text File Formats 00:06:00
Export Access Data to Excel 00:03:00
Create a Mail Merge 00:11:00
Create a Mail Merge
Organize Report Information 00:19:00
Format Reports 00:17:00
Include Control Formatting in a Report 00:04:00
Add a Calculated Field to a Report 00:05:00
Add a Subreport to an Existing Report 00:06:00
Implementing Advanced Form Design
Add Controls to Forms 00:22:00
Create Subforms 00:03:00
Organize Information with Tabs Pages 00:05:00
Enhance Navigation of Forms 00:06:00
Apply Conditional Formatting 00:05:00
Using Data Validation
Field and Record Validation 00:23:00
Form Validation 00:08:00
Using Macros to Improve User Interface Design
Create a Macro 00:17:00
Restrict Records Using a Condition 00:05:00
Validate Data Using a Macro 00:06:00
Automate Data Entry Using a Macro 00:06:00
Convert a Macro to VBA 00:05:00
Using Advanced Database Management
Link Tables to External Data Sources 00:05:00
Manage a Database 00:07:00
Determine Object Dependency 00:05:00
Document a Database 00:05:00
Analyze the Performance of a Database 00:05:00
Distributing and Securing a Database
Splitting a Database for Multiple User Access 00:05:00
Implement Security 00:09:00
Set Passwords 00:07:00
Convert an Access Database to an ACCDE File 00:07:00
Analyze the Performance of a Database 00:05:00
Managing Switchboards
Create a Database Switchboard 00:07:00
Modify a Database Switchboard 00:04:00
Set Startup Options 00:06:00
Mock Exam
Final Exam

Course Reviews

4.9

4.9
9 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE

Instructors

498 STUDENTS ENROLLED

APPROVED COURSE CENTRE

Approved Course Centre CPDQS

Alpha-Academy-Certificate-Mockup13

Our Students Say..

OUR COURSES PARTNERS

Registered with the UK Register of Learning Providers (UKRLP)
UKPRN: 10063816

Artboard-1-1

© Visio Learning.

Select your currency
USD United States (US) dollar