Microsoft Access 2010 Advanced Course

1 Training

Short course

Online

Save 75%
£ 29 VAT inc.

The best Office Systems courses

See all

See all

Description

  • Type

    Short course

  • Methodology

    Online

  • Duration

    365 Days

Awarded the certificate in Microsoft Access 2010 A

"The Microsoft Access 2010 Advanced course follows the basic and intermediate training to showcase advanced techniques by bringing together Access objects to make a cohesive application. The learner will gain an understanding of why Access utilises Properties and Events. Individuals will also learn how to create macros and how to select Control and Events to achieve an optimal outcome. It is a hands-on course to equip learners on how to construct advanced design forms, use pivot charts and pivot tables for complex record handling and data retrieval. Microsoft Access 2010 will help learners simplify their tasks, and to import and export data to be used in Microsoft Word and Excel.

The Microsoft Access 2010 Advanced course will teach learners how to create and use advanced queries, create effective reports and understand documentation.

The Microsoft Access 2010 Advanced course will help learners understand the features and components to become familiar with Access. 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 Advanced."

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course




"The course is aimed at individuals who have intermediate knowledge of Access 2010.
Students looking to expand their skills in Microsoft Office Access 2010.
The course is ideal for individuals working as programmers and web developers.
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 Advanced.

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
  • SQL
  • Database training
  • Design
  • Web
  • Microsoft Access
  • Web Development
  • Programmer
  • Web Developer

Teachers and trainers (1)

Marc Beneteau

Marc Beneteau

Trainer

Course programme

"

Course Curriculum

➤ Module 01: Querying with SQL

1.0 Topic A: SQL and Access

2.0 Topic B: Writing SQL Statements

3.0 Topic C: Attaching SQL Queries to Controls

➤ Module 02: Advanced Queries

1.0 Topic A: Creating Crosstab Queries

2.0 Topic B: Creating Parameter Queries

3.0 Topic C: Using Action Queries

➤ Module 03: Macros

1.0 Topic A: Creating, Running, and Modifying Macros

2.0 Topic B: Attaching Macros to the Events of Database Objects

➤ Module 04: Advanced Macros

1.0 Topic A: Creating Macros to Provide User Interaction

2.0 Topic B: Creating Macros that Require User Input

3.0 Topic C: Creating AutoKeys and AutoExec Macros

4.0 Topic D: Creating Macros for Data Transfer

➤ Module 05: Importing, Exporting, and Linking

1.0 Topic A: Importing Objects

2.0 Topic B: Exporting Objects

3.0 Topic C: Working with XML Documents

4.0 Topic D: Linking Access Objects

5.0 Topic E: Using Hyperlink Fields

➤ Module 06: Database Management

1.0 Topic A: Optimizing Resources

2.0 Topic B: Protecting Databases

3.0 Topic C: Setting Options and Properties

Learning Outcomes

  • Learn how to design the application
  • Learn how to use advanced form design
  • Learn how to create and use macros
  • Learn how to distribute the database
  • Learn how to create effective reports

Progression and Career Path

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

  • Programmer
  • Web Developer
  • Project Assistant
  • Business Executive
  • Business Analyst
  • Technical Support Analyst

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 Advanced 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

Microsoft Access 2010 Advanced Course

£ 29 VAT inc.

The best Office Systems courses

See all

See all