Access 2010 Beginner to Advanced Online Training

Access 2010 Beginner to Advanced Online Training

Course Outline

This course covers basic, intermediate, and advanced features of Microsoft Office's Access 2010 software. Access 2010 is a database application design and deployment tool that you can use to keep track of important information. You can keep your data on your computer, or you can publish to the Web - so others can use your database with a web browser.

OUR Price

£60.00

£50.00+ VAT

R.R.P.

£114.00

£95.00+ VAT

 

Key Features

  • 12 Months Unlimited Online Access to Expert Instructor-Led Training
    • Get trained by the very finest instructors in the IT industry today. With a minimum of 15 years real-world experience, they're all experts in their respective fields. Unlike live classes, you can fast-forward, repeat or rewind any part of your lecture. This creates a truly personal learning experience, and provides all the benefits of hands-on training - along with the unique flexibility of 24x7 access so you can fit everything around your schedule.
  • Visual Demonstrations & Multimedia Presentations
    • All courseware includes instructor-led demonstrations and visual presentations, allowing students to focus their skills development around real-world scenarios.
  • Quizzes & Exam Simulators
    • Customised practice exams help prepare you more effectively for your final examinations. And by utilising practice quizzes after each module, you ensure confidence and gauge your effectiveness on each topic before proceeding.
    • The included practice exams are also purposely designed to replicate & mirror the testing centre exam environment. With an average of 100 questions, you can ensure you're 100% prepared.
  • Social Learning & Networking
    • A world class Learning Management System (LMS) allows you to effectively interact & collaborate with other students, form individual study-groups, engage in forum discussions, rate different courses, and keep up with the latest industry knowledge. This is unmatched in the training industry, and makes your learning process far more fun and enjoyable.
  • Flash Cards & Educational Games
    • Education is not a one-size-fits-all activity, as students learn in many different ways - often preferring a variety of different tools. This is why we also provide Flash Cards & Educational Games throughout... All designed to ensure the maximum retention level, while keeping you more engaged and focused.
  • Navigation & Controls
    • The modular fashion of these self-paced training programs allows you a great deal of flexibility, with access to expert-level instruction anytime of the day or night. Full navigation controls allow you to pace your training throughout tightly defined sections & modules.
Access 2010 Beginner to Advanced Online Training

Course Description

This course covers basic, intermediate, and advanced features of Microsoft Office's Access 2010 software. Access 2010 is a database application design and deployment tool that you can use to keep track of important information. You can keep your data on your computer, or you can publish to the Web - so others can use your database with a web browser.

Click HERE For Access 2013

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 Subforms
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 Canceling a Blank Report from Printing
Section Review

Section 19: Creating a Startup Interface
Section Overview
Creating and Modifying a DB Switchboard
Setting and Modifying Startup 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 center
Setting Passwords
Converting Files and Signing with Digital Signatures
Section Review

Course Review

(Any associated exam costs are not included)
FREE : IT Certification & Career Training Guide