5/17/2018
Diploma in Microsoft Office 2013 Access - Visio Learning
LOGIN
HOME / COURSE / MICROSOFT OFFICE / ACCESS / VIDEO COURSE / DIPLOMA IN MICROSOFT OFFICE 2013 ACCESS
Diploma in Microsoft O ce 2013 Access ( 9 REVIEWS )
HOME
497 STUDENTS
CURRICULUM
REVIEWS
Microsoft Access is the world’s premier database management system, and is much more e cient 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 O ce 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 e ciency, 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 https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2013-access/
1/16
5/17/2018
Diploma in Microsoft Office 2013 Access - Visio Learning
Internationally recognised accredited certi cation on successful completion Free accredited e-certi cate 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 E cient 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 quali cations required for enrolment on this course. It is available to all students of all academic backgrounds.
Assessment and Certi cation 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-certi cate. PDF and hard copy certi cates can be ordered for an additional fee. PDF Certi cate – £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 con dence to progress. You will also be able to add your quali cation to your CV, enhance your career and become more competitive within your chosen industry.
COURSE CURRICULUM
Getting Started with Access
Orientation to Microsoft Access
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2013-access/
00:48:00
2/16
5/17/2018
Diploma in Microsoft Office 2013 Access - Visio Learning
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
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2013-access/
3/16
5/17/2018
Diploma in Microsoft Office 2013 Access - Visio Learning
Enhance the Appearance of a Report
00:05:00
Prepare a Report for Print
00:03:00
00:06:00
Customizing the Access Environment
The Access Options Dialog Box
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 E
ciency
Data Normalization
00:13:00
Create a Junction Table
00:07:00
Improve Table Structure
00:05:00
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2013-access/
4/16
5/17/2018
Diploma in Microsoft Office 2013 Access - Visio Learning
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
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2013-access/
5/16
5/17/2018
Diploma in Microsoft Office 2013 Access - Visio Learning
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
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2013-access/
6/16
5/17/2018
Diploma in Microsoft Office 2013 Access - Visio Learning
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 9 ratings
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2013-access/
7/16
5/17/2018
Diploma in Microsoft Office 2013 Access - Visio Learning
5 STARS
0
4 STARS
0
3 STARS
0
2 STARS
0
1 STARS
0
NO REVIEWS FOUND FOR THIS COURSE.
RELATED COURSES
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2013-access/
8/16
5/17/2018
Diploma in Microsoft Office 2013 Access - Visio Learning
Tarot Reading Level 3
£279.00 £29.00
478
WordPress E-commerce Management
£279.00 £29.00
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2013-access/
529
9/16
5/17/2018
Diploma in Microsoft Office 2013 Access - Visio Learning
Nutritional Therapy Level 2
£275.00 £29.00 470
TAKE T H I S COURSE
£279.00 £29.00
1 YEAR ADVANCED, BEGINNER, INTERMEDIATE COURSE BADGE COURSE CERTIFICATE NUMBER OF UNITS https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2013-access/
63 10/16
5/17/2018
Diploma in Microsoft Office 2013 Access - Visio Learning
0
NUMBER OF QUIZZES
9 HOURS, 50 MINUTES
Instructors GARY CARROLL
497 STUDENTS ENROLLED
APPROVED COURSE CENTRE
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2013-access/
11/16
5/17/2018
Diploma in Microsoft Office 2013 Access - Visio Learning
î…˛ îƒś
OUR STUDENTS SAY.. An extremely helpful and informative Great Course Content! Learn from course, especially in conjunction with quiz anywhere using personal devices and and video tutorial. Video is a good way to learn.
Mike
Kiara
Student, Finance
Student
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2013-access/
Course content are awesome! course I had this time.
Ginny Student
12/16
5/17/2018
Diploma in Microsoft Office 2013 Access - Visio Learning
OUR COURSES PARTNERS
Registered with the UK Register of Learning Providers (UKRLP) UKPRN: 10063816
All Visio Learning students are entitled to apply for an NUS card
YOU MAY LEARN Windows Server 2008 Applications Infrastructure Training Diploma
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2013-access/
13/16
5/17/2018
Diploma in Microsoft Office 2013 Access - Visio Learning
Windows Server 2008 Applications Infrastructure Training Diploma BY TAYLOR CHRISTOPHER
Con guring Windows Devices – 70-697 BY JAC WALSH
Accounting Skills Training Diploma BY JOHN ADAMS
Accredited Diploma in Child Psychology BY BRECKEN EMERSON
Accredited Pharmacy Technician Diploma BY NICHOLAS ALVARADO
Active Listening Training Diploma BY JOHN ADAMS
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2013-access/
14/16
5/17/2018
Diploma in Microsoft Office 2013 Access - Visio Learning
Admin, Secretarial & PA Diploma BY ROBIN WALKER
Administrative Assistant Skills Training BY ALVERT
Adobe After Effects CC 2017 Professional Training BY ANDREW JONES
Adobe Illustrator Training Level 2 BY ROBIN WALKER
ABOUT We are a company who is best known for offering awarding body accredited courses for anyone who wishes to take their professional life to the next level. 11 Floor, 15 St Botolph Street, London EC3A 7BB 020 3743 0883 info@visiolearning.co.uk CERTIFICATE CODE Enter Certi cate Code
VALI DAT E https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2013-access/
15/16
5/17/2018
Diploma in Microsoft Office 2013 Access - Visio Learning
IMPORTANT LINKS About Us Blog FAQ Redeem Voucher Terms & Conditions Privacy Policy Cookie Policy Contact Us COMING SOON
© VISIO LEARNING.
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2013-access/
16/16