Microsoft Access 2010
Original price was: £295.00.£49.00Current price is: £49.00.
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 aimed at?
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.
What is included in this course?
When you enrol, you’ll not only gain powerful, career-enhancing skills but also receive exclusive benefits, including:
Course Assessment Process
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.
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
Course Outline
Course Syllabus
Course Introduction
- Instructor Introduction
- Access Overview
- Course Outline
Section 1: Access Basics
- Section Overview
- What Does Access Do?
- Access Application Window
- Database Objects
- Basic Database and Table Management
- Customizing Access
- Keyboard Shortcuts
- Section Review
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 Overview
- Creating A New Database
- Creating Tables
- Inserting Field’s in Tables
- Setting Up Field Properties
- Formatting the Datasheet View
- Creating Relationships
- Keyboard Shortcuts
- Section Review
Section 4: Managing Table Data
- Section Overview
- Updating and Deleting Records
- Finding and Replacing Values
- Adding a Total Row
- Using Sub-datasheets
- Sorting Data
- Filtering Data
- Keyboard Shortcuts
- Section Review
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 Overview
- Form Basics and Creating Forms
- Contextual Tabs Design and Layout View
- Managing Table Data with Forms
- Modifying the Look and Design
- Design Tab Controls
- Section Review
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 Overview
- Setting Field Properties
- Validation Rules
- Input Mask
- Create Lookup Field
- Section Review
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 Overview
- Select Query Properties
- Parameter Queries
- Using Wild Cards
- Creating Action Queries
- Section Review
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
Payment Options
Pay securely online by debit or credit card or PayPal. Buying for your team? Talk to us about team training.
Student Reviews
There are no reviews for this course yet.
