Microsoft Access 2010
Vocational qualification
Online
Description
-
Type
Vocational qualification
-
Methodology
Online
-
Start date
Different dates available
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.
The great thing about our Microsoft Access 2010 course is that you are in charge of your start and finish date, with no deadline pressures!
We train our students to the very best standards, offering expert instructor-led training via our state of the art eLearning platform.
By achieving the Microsoft Office Specialist certification, you will create more career opportunities and be better positioned when applying for work.
Enrol today and prepare for a future you deserve.WHY STUDY WITH MY TRAINING ACADEMY?
Flexible training- study anytime, anywhere and from any device. Expert Instructor-Led Training Ð our courses are delivered by the finest instructors with a minimum of 15 years real-world experience and are subject matter experts in their field, which is why we have a 97.4% pass rate. Visual Demonstrations & Multimedia PresentationsÐ allows students to develop their skills based on real world scenarios explained by the instructor. Quizzes & Exam SimulatorsÐ custom practice exams to prepare students for their final exams. We offer practice quizzes after each module to ensure students are...
Important information
Price for Emagister users:
Facilities
Location
Start date
Start date
About this course
Anyone looking to develop their Microsoft Access skills.
Reviews
Subjects
- Access
- Office IT
- Database
- Database training
- Hacking
- Data Protection
- Computer Engineering
- Design
- Layout
- Ms Office
- IT Security
- Microsoft Access
- Microsoft Office
- Data security
- Computer Systems
- IT Systems
- Computer Science
- Network Engineering
- Computering
Course programme
Instructor Introduction
Access Overview
Course OutlineSection 1: Access Basics
Section Overview
What Does Access Do?
Access Application Window
Database Objects
Basic Database and Table Management
Customizing Access
Keyboard Shortcuts
Section ReviewSection 2: Designing a Database
Section Overview
Database Design Process
Normalizing Data
Setting Primary and Foreign Keys
Section ReviewSection 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 ReviewSection 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 ReviewSection 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 ReviewSection 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 ReviewSection 7: Creating and Managing Reports
Section Overview
Creating Reports, Report Views, and Managing Report Sections
Adding Calculated Fields and Formatting the Report Controls
Section ReviewSection 8: Controlling Data Entry
Section Overview
Setting Field Properties
Validation Rules
Input Mask
Create Lookup Field
Section ReviewSection 9: Finding and Joining Data
Section Overview
Inner and Outer Joins
Joining Unrelated Tables and Relating Data Within Tables
Section ReviewSection 10: Creating Flexible Queries
Section Overview
Select Query Properties
Parameter Queries
Using Wild Cards
Creating Action Queries
Section ReviewSection 11: Enhancing Forms
Section Overview
Using the Form Layout View and Improving Form Appearance
Restricting Data Entry
Command Buttons and Creating Sub forms
Section ReviewSection 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 ReviewSection 13: Sharing Access Data
Section Overview
Importing and Exporting Data
Sharing Data and Merging Data with Word
Section ReviewSection 14: Structuring Existing Data
Section Overview
Analyzing Tables and Junction Tables
Improving Table Structure
Section ReviewSection 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 ReviewSection 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 ReviewSection 17: Making Forms More Effective
Section Overview
Form Format Properties
Active X Controls and Tabbed Pages
Display Pivot Chart Table on Forms
Section ReviewSection 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 ReviewSection 19: Creating a Start-up Interface
Section Overview
Creating and Modifying a DB Switchboard
Setting and Modifying Start-up Options
Section ReviewSection 20: Database Maintenance
Section Overview
Database Maintenance Tools
Section ReviewSection 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 ReviewCourse ReviewMULTI-USER TRAINING PACKAGESThis online course can be integrated in your professional training plan. M.T.A. can provide you with a tailored learning solution, that can be customised to meet each team member's requirements. Choosing a multi-user training package, you can get significant discounts for 5+ users and even further discounts for 10+ users Ð and an excellent return on your investment.
Microsoft Access 2010