Microsoft Access 2010

Teachers

Study247

Category:

Office Skills/

Trusted by professionals from some of the world's leading companies

Price Original price was: £295.00.Current price is: £49.00. Includes VAT

Bulk Discounts

Bigger orders = better discounts

Title	Courses	Discount
Discount	3 - 14	10% £44.10
Discount	15 - 49	20% £39.20
Discount	50 - 99	30% £34.30
Discount	100 - 999	40% £29.40

Enquire

Duration: 35 Hours

Awarded By : Microsoft

Access : 12 Months

Type : Online Course

Eligible to Apply : Yes

Learn How It Works Book Your Exam Buying for your team?

Course Description

In order to succeed in today's business world, you must have competent skills in Microsoft Office. Whether you're an administrative assistant, office manager, sales professional or business manager, utilising all of the powerful features of Microsoft Office will make you more efficient and subsequently more marketable. Almost every job in the business world involves office products. Take your skills to the next level and make your current job easier to manage by completing our Microsoft Access 2010 course.

The Microsoft Access 2010 course has been designed to provide you with the essential skills you will need to be proficient in Access 2010, in a work or home environment, in as short a time as possible. You don't need any prior experience of Microsoft Access, but you will need to be familiar with using a computer and the Windows environment.

Get the skills employers are currently looking for, enrol today!

Who Is This Course For?

Anyone looking to develop their Microsoft Access skills.

By choosing online learning instead of a classroom based course, it eliminates the need for time away from work, saving you valuable time and money. It is ideal for those with tight schedules as our online courses give you 12 months unlimited access to all the course materials, so you can study at a pace that suits you. Allowing you to easily resume your studies whenever you have the time. All you need is internet connection to study, so you can study from the comfort of your home or any environment that suits you.

Certification Details

In order to earn your certification, you’ll have to sit an exam after completing your course with us. To prepare you for your exam, we provide interactive quizzes after each module and a mock exam at the end of your course to ensure you’re fully prepared for the real thing. Once you’ve passed with at least 85%, you’ll be ready to book your exam as a private candidate.

Booking your exam is pretty simple, just purchase your exam voucher and schedule your exam. To make life easier, we can help you find an appropriate exam centre and give you all the information you need to secure your place.

Please note that the exam fees aren’t included in the course price.

Got a question about exams? Contact one of our course advisors. We’re happy to help!

Requirements

Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.

For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player.

Course Outline

Course Syllabus

Course Introduction

Instructor Introduction
Access Overview
Course Outline

Section 1: Access Basics

Section 2: Designing a Database

Section Overview
Database Design Process
Normalizing Data
Setting Primary and Foreign Keys
Section Review

Section 3: Building a Database

Section 4: Managing Table Data

Section 5: Creating Selection Queries

Section Overview
Creating Queries Using the Query Wizard
Creating Queries Using the Query Design View
Adding Criteria
Add Calculated Fields to Query
Section Review

Section 6: Creating and Managing Forms

Section 7: Creating and Managing Reports

Section Overview
Creating Reports, Report Views, and Managing Report Sections
Adding Calculated Fields and Formatting The Report Controls
Section Review

Section 8: Controlling Data Entry

Section 9: Finding and Joining Data

Section Overview
Inner and Outer Joins
Joining Unrelated Tables and Relating Data Within Tables
Section Review

Section 10: Creating Flexible Queries

Section 11: Enhancing Forms

Section Overview
Using the Form Layout View and Improving Form Appearance
Restricting Data Entry
Command Buttons and Creating Sub forms
Section Review

Section 12: Customizing Reports

Section Overview
Organizing Report Information and Setting Report Control Properties
Page Layout and Controlling Pagination
Summarize Info and Sub-reports
Mailing Labels
Section Review

Section 13: Sharing Access Data

Section Overview
Importing and Exporting Data
Sharing Data and Merging Data with Word
Section Review

Section 14: Structuring Existing Data

Section Overview
Analyzing Tables and Junction Tables
Improving Table Structure
Section Review

Section 15: Writing Table Queries

Section Overview
Multi Table Query
Creating Unmatched Queries
Create Duplicate Queries
Create Duplicate Queries and Grouping and Summarizing
Crosstab Query
Creating Pivot tables and Pivot Charts
Section Review

Section 16: Using Macros

Section Overview
Planning and Creating Macros
Attach Macros to Command Buttons
Restrict Records Displayed Using Where Condition
Require Data Entry with Macros
Automate Data Entry
Section Review

Section 17: Making Forms More Effective

Section Overview
Form Format Properties
Active X Controls and Tabbed Pages
Display Pivot Chart Table on Forms
Section Review

Section 18: Improving Reports

Section Overview
Include Chart In Report and Concatenating
Arranging Data In Columns, Grouping, and Parameter Reports
Report Events and Cancelling a Blank Report from Printing
Section Review

Section 19: Creating a Start-up Interface

Section Overview
Creating and Modifying a DB Switchboard
Setting and Modifying Start-up Options
Section Review

Section 20: Database Maintenance

Section Overview
Database Maintenance Tools
Section Review

Section 21: Distributing and Securing a Database

Section Overview
Splitting a Database
Implementing Security and Trust centre
Setting Passwords
Converting Files and Signing with Digital Signatures
Section Review

Course Review

Career Path

We've put together a list of relevant job titles you can apply for after achieving the Microsoft Office certification (note that some careers may require further study, training and/or work experience):

Office Administrator
Business Administrator
Personal Assistant, Clerical Assistant
Receptionist
Secretary
Customer Service Representative
Project Officer, Project Manager
Business Manager
Sales Executive, Sales Manager, Sales Director
Human Resource Officer
Finance Assistant. Book-keeper, Accountant
Healthcare Assistant, Nurse
Database Administrator

Training Features

Flexible Learning

Study247 anytime, anywhere on any device.
World Class E-learning Platform

Study in a user friendly, state-of-the-art e-learning platform.
Expert Instructor-Led Training

Access step-by-step video tutorials delivered by leading industry experts.
Visual Demonstrations & Multimedia Presentations

Develop your skills based on real world scenarios.
Quizzes & Mock Exam

Interactive quizzes after each module and a mock exam at the end of your course to ensure you're fully prepared for your final certification exam.
Flash Cards & Educational Games

Allow you to train in ways that keep you engaged and focus.
Social Learning & Networking

Interact and collaborate with other students, form study groups, engage in discussions, rate different courses and stay up to date with all the latest industry knowledge.
Navigation & Controls

Allows you to study in bite-size chunks. You can pause, rewind or fast forward your tutorials, take study notes and more.

Need Practical Experience?

As a bolt-on option, we offer Practice Labs as it provides users with an online lab platform to develop their practical skills in IT technologies such as CompTIA, Microsoft, Cisco and VMWare.

In addition to the hardware you require, you also gain access to high quality practical exercises covering exam topics to help you to maximize your study time and increase your results. Practice Labs are highly effective and offer a cheaper alternative to setting up your own test environment.

You will gain unlimited access to the Practice Labs for 12 months- helping you to consolidate your learning and prepare you for work. Learn More

Apply for an XO Student Discount Card

When you enrol on a course with us, you automatically qualify for an XO student discount card which will enable you to enjoy savings from not only high street retailers, bars and restaurants, but also travel companies across the United Kingdom. Learn More