MS Access 2010 Intermediate Online Course

1 Training

Short course

Online

Save 75%
£ 29 VAT inc.

The best Access courses

See all

See all

Description

  • Type

    Short course

  • Methodology

    Online

  • Duration

    365 Days

Certificate in Microsoft Access 2010 Intermediate

"The Microsoft Access 2010 Intermediate course will teach learners the fundamentals of database design, and how to construct a relational database where data analysis and future modifications are made easier. This course is a follow-up from the basic Access training and will touch on topics such as tables and its attributes, field properties and structures. The crucial step of this course is to equip new users with key components in Access 2010. This will help learners build a database retrieve data, generate reports and design and formulate queries.

The Microsoft Access 2010 Intermediate course will teach learners how to import data into the database, retrieve and modify records, delete records, build forms and reports.

The Access 2010 Intermediate course will give you an understanding of the different types of data and how to determine which data is allocated. You need to be efficient in these steps, otherwise the database will not function efficiently. The course is internationally recognised and accredited to a training organisation and you will be issued an internationally recognised qualification following full completion of Microsoft Access 2010 Intermediate."

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course




"The course is aimed at individuals who have beginner’s knowledge of Access 2010.
Students looking to expand their skills in Microsoft Office Access 2010.
The course is ideal for individuals working as programmers.
Anyone interested in developing their skills in Microsoft Office Access 2010.

"

"You must be over the age of 16 and have a basic understanding of Maths, English and ICT
Job seekers / graduates / school leavers"

Those who successfully complete the exam will be awarded the certificate in Microsoft Access 2010 Intermediate.

Our online programme is well designed that you feel same as you are in the classroom. This course is comprised of professionally narrated e-Learning modules, interactive quizzes, tests and exams. All delivered through a system that you will have access to 24 hours a day, 7 days a week in 365 days (12 months). Effective support service, and study materials including step by step guided tutorial videos build your confidence to study well and guide you to secure your qualification.


On receiving your request, one of our stuff members will call you or send you a message by explaining everything about the course you are requesting information including how you can sign up, payment options, exam and enrollment requirements etc.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2018

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

  • Access
  • Database
  • Database training
  • Design
  • Project
  • Microsoft Access
  • Programmer
  • Assistant
  • Project team
  • Project Assistant

Teachers and trainers (1)

Vitthal Srinivasan

Vitthal Srinivasan

Flipkart, Credit Suisse and INSEAD

Course programme

"

Course Curriculum

➤ Module 01: Relational Databases

Course Introduction

1.0 Topic A: Database Normalization

2.0 Topic B: Table Relationships

3.0 Topic C: Referential Integrity

➤ Module 02: Related Tables 1.0

1.0 Topic A: Creating Lookup Fields

2.0 Topic B: Modifying Lookup Fields

3.0 Topic C: Using Subdatasheets

➤ Module 03: Complex Queries

1.0 Topic A: Joining Tables in Queries

2.0 Topic B: Using Calculated Fields

3.0 Topic C: Summarizing and Grouping Values

➤ Module 04: Advanced Form Design

1.0 Topic A: Adding Unbound Controls

2.0 Topic B: Adding Graphics

3.0 Topic C: Adding Calculated Values

4.0 Topic D: Adding Combo Boxes

5.0 Topic E: Advanced Form Types

➤ Module 05: Reports and Printing

1.0 Topic A: Customized Headers and Footers

2.0 Topic B: Calculated Values

3.0 Topic C: Printing

4.0 Topic D: Labels

➤ Module 06: Charts

1.0 Topic A: Charts in Forms

2.0 Topic B: Charts in Reports

➤ Module 07: PivotTables and PivotCharts

1.0 Topic A: PivotTables

2.0 Topic B: Modifying PivotTables

3.0 Topic C: PivotCharts

4.0 Topic D: PivotTable Forms

Learning Outcomes

  • Learn Access 2010 interface including Ribbon Features and Backstage View
  • Learn new techniques to create forms to present data visually
  • Learn how to filter data in tables and forms
  • Learn how to improve report design, how to sort and group on the report and add existing fields
  • Learn how to update database quickly

Progression and Career Path

Once you successfully complete Microsoft Access 2010 Intermediate you will be qualified to work in the following positions. The Microsoft Access 2010 Intermediate qualification will also put you in line to demand a higher salary or job promotion.

  • Programmer – £44,873 per annum
  • Web Developer – £24,833 per annum
  • Project Assistant – £20,785 per annum
  • Business Executive – £23,667 per annum
  • Business Analyst – £35,543 per annum
  • Technical Support Analyst – £22,753 per annum

Other Benefits

  • Written and designed by the industry’s finest expert instructors with over 15 years of experience
  • Repeat and rewind all your lectures and enjoy a personalised learning experience
  • Gain access to quality video tutorials
  • Unlimited 12 months access from anywhere, anytime
  • Excellent Tutor Support Service (Monday to Friday)
  • Save time and money on travel
  • Learn at your convenience and leisure
  • Quizzes, tests mock exams, practice exams to ensure you are 100% ready
  • Eligible for a NUS discount card
  • Free Career Support Service
  • 25% Discount on personal Statement and covering letter writing service
  • Free Access to Over 150 courses for 2 days (48 hours)
  • Free access to course before you purchase (For selected courses only)

"

Additional information

Access Duration
The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course.  The course is self-paced and you can complete it in stages, revisiting the lectures at anytime.

Method of Assessment
At the end of the Microsoft Access 2010 Intermediate course you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.

Awarding Body
The certificate will be awarded by CPD and iAP. This internationally recognised qualification will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in the IT enterprise.

See related categories

MS Access 2010 Intermediate Online Course

£ 29 VAT inc.

The best Access courses

See all

See all