3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
LOGIN
HOME / COURSE / MICROSOFT OFFICE / ACCESS / VIDEO COURSE / LEVEL 3 DIPLOMA IN MICROSOFT ACCESS 2010
Level 3 Diploma in Microsoft Access 2010 ( 6 REVIEWS )
459 STUDENTS
Description: This particular course has multiple functions including working with templates, generating the baseline plans, monitoring and renovating projects, analysing …
TAKE THIS COURSE
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
1/19
3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
£350.00 £69.00
1 YEAR ADVANCED, BEGINNER, INTERMEDIATE COURSE BADGE COURSE CERTIFICATE
65
NUMBER OF UNITS
2
NUMBER OF QUIZZES
11 HOURS, 27 MINUTES
HOME
CURRICULUM
REVIEWS
Description: This particular course has multiple functions including working with templates, generating the baseline plans, monitoring and renovating projects, analysing the project statistics, coping with delays and con icts, and overall, learning to customise projects. In fact, through executing the project server 2010, you will gain knowledge of communicating the project information as well as combining the project data with the other relevant o ce applications in general. Moreover, the learners who are basically the information workers and those who want to learn the elementary level of the Access 2010 skills properly match with the very design of the course. Apart from that,the Microsoft O ce 2010 Access Intermediate- Complete Video Course is basically based on the skills and ideas learned from the Access 2010.This particular course helps you learn the items such as: the relational databases, related tables,complex queries, reports and printing, charts and pivot tables and also pivot charts. The fundamental topics that have been discussed in the particular course include: learning about querying with SQL, the advanced queries, Macros, the Advanced Macros and so on. https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
2/19
3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your nal exam you will have the opportunity to test your pro ciency with a mock exam.
Certi cation: After completing and passing the course successfully, you will be able to obtain an Accredited Certi cate of Achievement. Certi cates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.
Who is this Course for? Level 3 Diploma in Microsoft Access 2010 is certi ed by CPD Quali cations Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and quali cation required for this course, it is available for all students from any academic background.
Requirements Our Level 3 Diploma in Microsoft Access 2010 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
Career Path After completing this course you will be able to build up accurate knowledge and skills with proper con dence to enrich yourself and brighten up your career in the relevant job market. COURSE CURRICULUM
Module 01: Beginner Getting Started
Database Concepts
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
00:04:00
3/19
3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
Exploring the Access Environment
00:11:00
Getting Help
00:02:00
Databases and Tables
Planning and Designing Databases
00:12:00
Exploring Tables
00:11:00
Creating Tables
00:33:00
Fields and Records
Changing the Design of a Table
00:15:00
Finding and Editing Records
00:06:00
Organizing Records
00:16:00
Data Entry Rules
Setting Field Properties
00:14:00
Working with Input Masks
00:07:00
Setting Validation Rules
00:06:00
Basic Queries
Creating and Using Queries
00:13:00
Modifying Query Results and Queries
00:05:00
Performing Operations in Queries
00:17:00
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
4/19
3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
Using Forms
Creating Forms
00:11:00
Using Design View
00:14:00
Sorting and Filtering Records
00:04:00
Working with Reports
Creating Reports
00:10:00
Modifying and Printing Reports
00:16:00
Module 02: Intermediate Relational Databases
Database Normalization
00:14:00
Table Relationships
00:13:00
Referential Integrity
00:12:00
Related Tables
Creating Lookup Fields
00:11:00
Modifying Lookup Fields
00:06:00
Using Subdatasheets
00:04:00
00:26:00
Complex Queries
Joining Tables in Queries
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
5/19
3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
Using Calculated Fields
00:09:00
Summarizing and Grouping Values
00:08:00
Advanced Form Design
Adding Unbound Controls
00:08:00
Adding Graphics
00:04:00
Adding Calculated Values
00:06:00
Adding Combo Boxes
00:04:00
Advanced Form Types
00:10:00
Reports and Printing
Customized Headers and Footers
00:17:00
Calculated Values
00:08:00
Calculated Values
00:08:00
Printing
00:03:00
Labels
00:05:00
Charts
Charts in Forms
00:08:00
Charts in Reports
00:06:00
PivotTables and PivotCharts
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
6/19
3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
PivotTables
00:05:00
Modifying PivotTables
00:07:00
PivotCharts
00:04:00
PivotTable Forms
00:01:00
Module 03: Advanced Querying with SQL
SQL and Access 123
00:06:00
Writing SQL Statements
00:18:00
Attaching SQL Queries to Controls
00:06:00
Advanced Queries
Creating Crosstab Queries
00:05:00
Creating Parameter Queries
00:11:00
Using Action Queries
00:17:00
Macros
Creating, Running, and Modifying Macros
00:08:00
Attaching Macros to the Events of Database Objects
00:05:00
00:20:00
Advanced Macros
Creating Macros to Provide User Interaction
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
7/19
3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
Creating Macros that Require User Input
00:04:00
Creating AutoKeys and AutoExec Macros
00:07:00
Creating Macros for Data Transfer
00:07:00
Importing, Exporting, and Linking
Importing Objects
00:14:00
Exporting Objects
00:06:00
Working with XML Documents
00:13:00
Linking Access Objects
00:13:00
Using Hyperlink Fields
00:06:00
Database Management
Optimizing Resources
00:16:00
Protecting Databases
00:05:00
Setting Options and Properties
00:06:00
00:30:00
00:30:00
Mock Exam
-
Mock Exam- Level 3 Diploma in Microsoft Access 2010
Final Exam
-
Final Exam- Level 3 Diploma in Microsoft Access 2010
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
8/19
3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
COURSE REVIEWS
4.9 6 ratings
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.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
9/19
3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
Project Management Level 2 Certi cate for Manager
£279.00 £17.00
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
438
10/19
3/26/2018
A
Level 3 Diploma in Microsoft Access 2010 - John Academy
liate Marketing Online Certi cate Course
£199.00 £10.00
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
499
11/19
3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
Python 3 for Beginners
£279.00 £25.00 508
459 STUDENTS ENROLLED
CERTIFICATION
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
12/19
3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
13/19
3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
14/19
3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
15/19
3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
BY ACCREDITATION
COURSE AWARDING BODY
R
i
d
i h h UK R
i
fL
i
P
id
(UKRLP)
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
16/19
3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
Registered with the UK Register of Learning Providers (UKRLP) UKPRN: 10063816
COURSE PARTNERS
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
17/19
3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
ABOUT We are a company who is best known for o ering awarding body accredited courses for anyone who wishes to take their professional life to the next level. 2nd Floor, 16-18 Whitechapel Rd, London E1 1EW, United Kingdom. 020 3744 3990 info@johnacademy.co.uk CERTIFICATE CODE Enter Certi cate Code
VALID ATE
IMPORTANT LINKS
About Us FREE CV REVIEW Terms & Conditions Privacy Policy Cookie Policy FAQ Contact COMING SOON
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
18/19
3/26/2018
Level 3 Diploma in Microsoft Access 2010 - John Academy
© ADAMS ACADEMY INC. LTD. T/A JOHN ACADEMY.
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-access-2010-2/
19/19