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 conflicts, 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 office 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 Office 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.

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 final exam you will have the opportunity to test your proficiency with a mock exam.

Certification:

  • After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.
  • Certificates 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 certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification 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 confidence to enrich yourself and brighten up your career in the relevant job market.

Course Curriculum

Module 01: Beginner
Getting Started
Database Concepts FREE 00:04:00
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
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
Complex Queries
Joining Tables in Queries 00:26:00
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
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 FREE 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
Advanced Macros
Creating Macros to Provide User Interaction 00:20:00
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
Mock Exam
Mock Exam- Level 3 Diploma in Microsoft Access 2010 00:30:00
Final Exam
Final Exam- Level 3 Diploma in Microsoft Access 2010 00:30:00

Course Reviews

4.9

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

No Reviews found for this course.

460 STUDENTS ENROLLED

ACCREDITED BY

OUR COURSE AWARDING BODIES

OUR COURSE PARTNERS

Have you any inquiry?

  • By submitting your information, you agree to the terms and conditions stated in our Privacy Policy

Certificate Code

top

© John Academy.