Course Overview

Key Features

  • 18 Hrs of HQ e-learning content
  • 45 High Quality Demos
  • 32 End of Chapter Quizzes
  • 1 Scenario based Practice Test
  • Course Completion Certificate

Training Options

Self-Paced Learning

$ 149

  • Lifetime access to high-quality self-paced e-learning content curated by industry experts
  • 24x7 learner assistance and support

Corporate Training

Customized to your team's needs

  • Blended learning delivery model (self-paced eLearning and/or instructor-led options)
  • Flexible pricing options
  • Enterprise grade Learning Management System (LMS)
  • Enterprise dashboards for individuals and teams
  • 24x7 learner assistance and support

Course Curriculum

Course Content

  • Microsoft® Access 2010

    Preview
    • Lesson 0.0 - Course Overview

      05:15Preview
      • 1 Lesson 0-Course Overview
        00:24
      • 2 Key Features
        00:12
      • 3 Objectives
        00:27
      • 4 About the Course
        00:44
      • 5 About the Course (contd.)
        00:48
      • 6 Value of Microsoft® Access 2010 for Professionals
        00:32
      • 7 Value of Microsoft® Access 2010 for Organizations
        00:36
      • 8 Lessons Covered
        00:37
      • 9 Exam Question Types
      • 10 Microsoft® Access 2010 Certification
        00:45
      • 11 Sources of Information
      • 12 Conclusion
        00:10
    • Lesson 1.0 - Introduction To Microsoft Access 2010

      00:43Preview
      • 1 Introduction to Microsoft® Access 2010
        00:14
      • 2 Objectives
        00:29
    • Lesson 1.1 - Topic 1-Introduction to Database and Database Systems

      03:43
      • 1 Topic 1-Introduction to Database and Database Systems
        00:22
      • 2 What Is a Database
        00:48
      • 3 Types of Database Systems
        01:20
      • 4 Relational Database Management System
        01:13
    • Lesson 1.2 - Topic 2-Basic Features of MS Access 2010

      03:31Preview
      • 1 Topic 2-Basic Features of MS Access 2010
        00:12
      • 2 Access 2010
        00:37
      • 3 New Features of Access 2010
        01:07
      • 4 New Features of-Access 2010 (contd.)
        01:07
      • 5 Obtaining MS Access 2010
        00:28
    • Lesson 1.3 - Topic 3-Running Access and Using Database Files

      06:18Preview
      • 1 Topic 3-Running Access and Using Database Files
        00:05
      • 2 Running MS Access 2010
        00:53
      • 3 Access Database Files
        01:04
      • 4 Demo 1-Running Access and Creating a New Database
        01:04
      • 5 Demo 1-Running Access and Creating a New Database (contd.)
        01:04
      • 6 Demo 2-Opening Access and Database
        01:04
      • 7 Demo 2-Opening Access and Database (contd.)
        01:04
    • Lesson 1.4 - Topic 4-Working with Access 2010

      05:38Preview
      • 1 Topic 4-Working with Access 2010
        00:08
      • 2 Access 2010 User Interface
        00:34
      • 3 The Ribbon
        01:09
      • 4 Quick Access Toolbar
        00:36
      • 5 Navigation Pane
        00:47
      • 6 Notification Band
        00:48
      • 7 Work Area
        00:32
      • 8 Demo 3-Working with the Access Interface
        00:32
      • 9 Demo 3-Working with the Access Interface (contd.)
        00:32
    • Lesson 1.5 - Topic 5-Setting Access Options

      04:23Preview
      • 1 Topic 5-Setting Access Options
        00:07
      • 2 Access Options
        01:06
      • 3 Access Options (contd.)
        00:55
      • 4 Demo 4-Setting Access 2010 Options
        00:43
      • 5 Demo 4-Setting Access 2010 Options (contd.)
        00:43
      • 5 Quiz
      • 6 Summary
        00:43
      • 7 Conclusion
        00:06
    • Lesson 2.0 - Working with Tables

      00:45
      • 1 Working with Tables
        00:14
      • 2 Objectives
        00:31
    • Lesson 2.1 - Topic 1-Understanding Tables

      03:20Preview
      • 1 Topic 1-Understanding Tables
        00:10
      • 2 Tables
        00:41
      • 3 Tables (contd.)
        00:35
      • 4 Columns
        01:00
      • 5 Rows
        00:54
    • Lesson 2.2 - Topic 2-Managing Tables

      06:56Preview
      • 1 Topic 2-Managing Tables
        00:09
      • 2 Table Creation
        00:38
      • 3 Datasheet View
        01:04
      • 4 Design View
        00:34
      • 5 Saving and Viewing Tables
        00:41
      • 6 Demo 1-Creating and Managing Tables
        00:46
      • 7 Demo 1-Creating and Managing Tables (contd.)
        00:46
      • 8 Entering Data
        00:46
      • 9 Demo 2-Data Entry in Tables
        00:46
      • 10 Demo 2-Data Entry in Tables (contd.)
        00:46
    • Lesson 2.3 - Topic 3-Creating Using Templates

      04:02Preview
      • 1 Topic 3-Creating Using Templates
        00:11
      • 2 Templates
        00:53
      • 3 Backstage Templates
        01:07
      • 4 Application Parts
        00:37
      • 5 Demo 3-Using Table Templates
        00:37
      • 6 Demo 3-Using Table Templates (contd.)
        00:37
    • Lesson 2.4 - Topic 4-Compacting and Repairing Databases

      04:40Preview
      • 1 Topic 4-Compacting and Repairing Databases
        00:15
      • 2 Database Growth
        01:06
      • 3 Compact and Repair
        00:52
      • 4 Demo 4-Compact and Repair
        00:52
      • 5 Demo 4-Compact and Repair (contd.)
        00:52
      • 6 Quiz
      • 7 Summary
        00:37
      • 8 Conclusion
        00:06
    • Lesson 3.0 - Working with Fields

      00:41Preview
      • 1 Lesson 3-Working with Fields
        00:19
      • 2 Objectives
        00:22
    • Lesson 3.1 - Topic 1-Introduction to Fields

      08:38Preview
      • 1 Topic 1-Introduction to Fields
        00:11
      • 2 Fields
        00:37
      • 3 Data Types
        00:34
      • 4 Data Types (contd.)
        01:34
      • 5 Field Properties
        00:44
      • 6 Common Field Properties
        00:50
      • 7 Specific Field Properties
        00:36
      • 8 Demo 1-Adding and Managing Fields
        00:06
      • 9 Demo 1-Adding and Managing Fields (contd.)
        03:26
    • Lesson 3.2 - Topic 2-Data Validation

      12:09Preview
      • 1 Topic 2-Data Validation
        00:12
      • 2 Lookup Field
        01:07
      • 3 Demo 2-Using Lookup Fields
        00:09
      • 4 Demo 2-Using Lookup Fields (contd.)
        02:33
      • 5 Input Masks
        01:17
      • 6 Demo 3-Using Input Masks
        00:06
      • 7 Demo 3-Using Input Masks (contd.)
        02:49
      • 8 Validation Rules and Texts
        01:11
      • 9 Demo 4-Adding Validation Rules
        00:06
      • 10 Demo 4-Adding Validation Rules (contd.)
        02:39
    • Lesson 3.3 - Topic 3-Keys and Relationships

      09:31Preview
      • 1 Topic 3-Keys and Relationships
        00:37
      • 2 Keys
        00:28
      • 3 Primary Key
        00:55
      • 4 Foreign Key
        01:06
      • 5 Foreign Keys-Referential Integrity
        00:34
      • 6 Relationships
        00:18
      • 7 One-to-One Relationship
      • 8 One-to-Many Relationship
        00:31
      • 9 Many-to-Many Relationship
        00:31
      • 10 Demo 5-Adding Keys and Defining Relationships
        00:11
      • 11 Demo 5-Adding Keys and Defining Relationships (contd.)
        04:20
    • Lesson 3.4 - Topic 4-Sorting and Filtering

      03:50Preview
      • 1 Topic 4-Sorting and Filtering
        00:13
      • 2 Sorting
        00:47
      • 3 Ways of Sorting
        00:24
      • 4 Filtering
        00:49
      • 5 Advanced Filtering Options
        00:41
      • 6 Demo 6-Sorting and Filtering data
        00:06
      • 7 Demo 6-Sorting and Filtering data (contd.)
      • 8 Quiz
      • 9 Summary
        00:43
      • 10 Conclusion
        00:07
    • Lesson 4.0 - Working with Queries

      00:53Preview
      • 1 Lesson 4-Working with Queries
        00:16
      • 2 objectives
        00:37
    • Lesson 4.1 - Topic 1-Queries in MS Access

      09:19Preview
      • 1 Topic 1-Queries in MS Access
        00:16
      • 2 Query
        00:47
      • 3 Types of Queries
        01:52
      • 4 Using the Simple Query Wizard
        00:54
      • 5 Demo 1-The Simple Query Wizard
        00:09
      • 6 Demo 1-The Simple Query Wizard (contd.)
        01:11
      • 7 Design View
        00:31
      • 8 Demo 2-Using the Design View
        00:07
      • 9 Demo 2-Using the Design View (contd.)
        01:15
      • 10 Viewing Results
        00:34
      • 11 Multiple Table Queries
        00:50
      • 12 Demo 3-Querying from Multiple Tables
        00:06
      • 13 Demo 3-Querying from Multiple Tables (contd.)
        00:47
    • Lesson 4.2 - Topic 2-Calculated Fields, Parameter Queries, and Summary Queries

      09:31Preview
      • 1 Topic 2-Using Calculated Fields, Parameter Queries, and Summary Queries
        00:25
      • 2 Calculated Fields
        01:17
      • 3 Demo 4-Creating a Calculated Field
        00:05
      • 4 Demo 4-Creating a Calculated Field (contd.)
        01:02
      • 5 Parameter Queries
        01:10
      • 6 Demo 5-Creating Parameter Queries
        00:06
      • 7 Demo 5-Creating Parameter Queries (contd.)
        00:53
      • 8 Expression Builder
        00:53
      • 9 Demo 6-Using the Expression Builder
        00:06
      • 10 Demo 6-Using the Expression Builder (contd.)
        01:26
      • 11 Summary Queries
        00:52
      • 12 Demo 7-Using Summary Queries
        00:05
      • 13 Demo 7-Using Summary Queries (contd.)
        01:11
    • Lesson 4.3 - Topic 3-Perform Actions on Data with Queries

      07:26Preview
      • 1 Perform Actions on Data with Queries
        00:16
      • 2 Action Queries
        01:19
      • 3 Update and Delete Queries
        01:10
      • 4 Make Table and Append Queries
        00:49
      • 5 Demo 8 - Using Action Queries
        00:07
      • 6 Demo 8-Using Action Queries
        02:56
      • 7 Quiz
      • 8 Summary
        00:41
      • 9 Conclusion
        00:08
    • Lesson 5.0 - Creating and Using Forms

      00:43Preview
      • 1 Creating and Using Forms
        00:16
      • 2 Objectives
        00:27
    • Lesson 5.1 - Topic 1-Introduction to Forms

      02:12
      • 1 Topic 1-Introduction to Forms
        00:09
      • 2 Forms
        00:46
      • 3 Ways to Create Forms
        01:17
    • Lesson 5.2 - Topic 2-Auto Forms and Form Wizard

      06:34Preview
      • 1 Topic 2-Auto Forms and Form Wizard
        00:12
      • 2 Auto Forms
        00:50
      • 3 Auto Forms-Additional Features
        01:00
      • 4 Demo 1-Creating an Auto Form from a Table
        00:05
      • 5 Demo 1-Creating an Auto Form from a Table (contd.)
        01:02
      • 6 Form Wizard
        00:50
      • 7 Layouts of Form Wizard
        00:56
      • 8 Demo 2-Using the Forms Wizard
        00:05
      • 9 Demo 2-Using the Forms Wizard (contd.)
        01:34
    • Lesson 5.3 - Topic 3-Working with Templates

      09:04Preview
      • 1 Topic 3-Working with Templates
        00:16
      • 2 Types of Form Templates
        00:44
      • 3 Quick Start Templates
        00:50
      • 4 Demo 3-Using Quick Start
        00:08
      • 5 Demo 3-Using Quick Start (contd.)
        01:39
      • 6 More Form Templates
        00:56
      • 7 Demo 4-Using More Form Templates
        00:10
      • 8 Demo 4-Using More Form Templates (contd.)
        01:44
      • 9 Navigation Form Templates
        00:47
      • 10 Demo 5-Using a Navigation Form
        00:09
      • 11 Demo 5-Using a Navigation Form (contd.)
        01:41
    • Lesson 5.4 - Topic 4-Manually Creating a Form

      04:23Preview
      • 1 Topic 4-Manually Creating a Form
        00:14
      • 2 Layout and Design
        00:41
      • 3 Layout View
        00:42
      • 4 Design View
        00:32
      • 5 Demo 6-Manual Creation and Designing of a Form
        00:08
      • 6 Demo 6-Manual Creation and Designing of a Form (contd.)
        02:06
    • Lesson 5.5 - Topic 5-Form Elements and Formatting

      05:59Preview
      • 1 Topic 5-Form Elements and Formatting
        00:12
      • 2 Elements
        00:22
      • 3 Control Properties
        01:10
      • 4 Layout and Formatting
        00:55
      • 5 Demo 7-Arranging and Formatting a Form
        00:06
      • 6 Demo 7-Arranging and Formatting a Form (contd.)
        02:09
      • 7 Quiz
      • 8 Summary
        00:34
      • 9 Summary (contd.)
        00:24
      • 10 Conclusion
        00:07
    • Lesson 6.0 - Advanced Form Capabilities

      00:42
      • 1 Lesson 6-Advanced Form Capabilities
        00:16
      • 2 Objectives
        00:26
    • Lesson 6.1 - Advanced Controls

      10:23Preview
      • 1 Topic 1-Advanced Controls
        00:15
      • 2 List Box and Combo Box
        00:59
      • 3 Inserting List Box and Combo Box
        01:08
      • 4 Demo 1-Combo Box Control
        00:05
      • 5 Demo 1-Combo Box Control (contd.)
        01:24
      • 6 Command Buttons
        01:28
      • 7 Demo 2-Using the Button Control
        00:06
      • 8 Demo 2-Using the Button Control (contd.)
        02:05
      • 9 Tab Order
        01:37
      • 10 Demo 3-Changing the Tab Order
        00:05
      • 11 Demo 3-Changing the Tab Order (contd.)
        01:11
    • Lesson 6.2 - Linked Forms and Subforms

      09:35Preview
      • 1 Topic 2-Linked Forms and Subforms
        00:17
      • 2 Linked Form
        01:09
      • 3 Demo 4-Creating a Linked Form
        00:05
      • 4 Demo 4-Creating a Linked Form(contd.)
        02:36
      • 5 Subform
        01:11
      • 6 Demo 5-Creating a Subform
        00:05
      • 7 Demo 5-Creating a Subform(contd.)
        03:17
      • 8 Quiz
      • 9 Summary
        00:48
      • 10 Conclusion
        00:07
    • Lesson 7.0 - Building Reports

      00:38Preview
      • 1 Building Reports
        00:15
      • 2 Objectives
        00:23
    • Lesson 7.1 - Introduction to Reports

      03:52Preview
      • 1 Topic 1-Introduction to Reports
        00:10
      • 2 Reports
        00:52
      • 3 Views for Reports
        00:40
      • 4 Sections on Reports
        01:06
      • 5 Page Setup
        01:04
    • Lesson 7.2 - Creating Reports

      09:27Preview
      • 1 Topic 2-Creating Reports
        00:08
      • 2 Create Reports
        00:44
      • 3 Auto Report
        00:41
      • 4 Demo 1-Using Auto Report
        00:09
      • 5 Demo 1-Using Auto Report (contd.)
        01:14
      • 6 Report Wizard
        01:19
      • 7 Demo 2-Using the Report Wizard
        00:05
      • 8 Demo 2-Using the Report Wizard (contd.)
        02:20
      • 9 Labels
        01:13
      • 10 Demo 3-Creating Labels
        00:07
      • 11 Demo 3-Creating Labels (contd.)
        01:27
    • Lesson 7.3 - Working with Layout and Design View

      08:13Preview
      • 1 Topic 3-Working with Layout and Design Views
        00:14
      • 2 Layout View
        00:48
      • 3 Demo 4-Using Layout View
        00:05
      • 4 Demo 4-Using Layout View (contd.)
        02:54
      • 5 Design View
        00:39
      • 6 Demo 5-Using Design View
        00:05
      • 7 Demo 5-Using Design View (contd.)
        02:40
      • 8 Quiz
      • 9 Summary
        00:42
      • 10 Conclusion
        00:06
    • Lesson 8.0 - Advanced Reports

      00:43Preview
      • 1 Advanced Reports
        00:17
      • 2 Objectives
        00:26
    • Lesson 8.1 - Report Export

      05:54Preview
      • 1 Topic 1-Report Export
        00:12
      • 2 Exporting Reports
        01:06
      • 3 Way to Export Reports
        00:39
      • 4 Automate Exports
        01:08
      • 5 Demo 1-Exporting a Report
        00:08
      • 6 Demo 1-Exporting a Report (contd.)
        02:41
    • Lesson 8.2 - Charts in Reports

      05:57Preview
      • 1 Topic 2-Charts in Reports
        00:13
      • 2 Chart Options
        00:39
      • 3 Chart Options (contd.)
        01:32
      • 4 Demo 2-Using the Chart Wizard
        00:06
      • 5 Demo 2-Using the Chart Wizard (contd.)
        01:51
      • 6 Demo 3-Customizing the chart
        00:07
      • 7 Demo 3-Customizing the chart (contd.)
        01:29
    • Lesson 8.3 - Creating Pivot Tables and Charts

      02:46Preview
      • 1 Topic 3-Creating Pivot Tables and Charts
        00:12
      • 2 Pivot Tables and Charts
        00:37
      • 3 Demo 4-Creating a Pivot Table and Chart
        00:06
      • 4 Demo 4-Creating a Pivot Table and Chart (contd.)
        01:51
    • Lesson 8.4 - Conditional Formatting

      05:50Preview
      • 1 Conditional Formatting
        00:12
      • 2 Using Rules to Format
        00:46
      • 3 Conditions to Set Rules
        00:34
      • 4 Adding Data Bars
        00:32
      • 5 Demo 5-Using Conditional Formatting
        00:09
      • 6 Demo 5-Using Conditional Formatting (contd.)
        03:37
    • Lesson 8.5 - Using Subreports

      03:39Preview
      • 1 Topic 5-Using Subreports
        00:11
      • 2 Subreports
        00:47
      • 3 Adding Subreports
        00:41
      • 4 Demo 6-Creating a SubReports
        00:06
      • 5 Demo 6-Creating a SubReports (contd.)
        01:02
      • 6 Quiz
      • 7 Summary
        00:44
      • 8 Thank you
        00:08

Reviews

  • Bailey Jordan

    Bailey Jordan

    Clear and concise delivery; easy to follow and understand. Kudos Simplilearn for this awesome course!

  • Eleanor Reynolds

    Eleanor Reynolds

    Good course to help you get familiar with Access and moving around within it.

  • Reagan Patterson

    Reagan Patterson

    This was an excellent introduction to access and how database works. I feel confident to move onto something more complex. Thank you Simplilearn!

prevNext

Why Online Bootcamp

  • Develop skills for real career growthCutting-edge curriculum designed in guidance with industry and academia to develop job-ready skills
  • Learn from experts active in their field, not out-of-touch trainersLeading practitioners who bring current best practices and case studies to sessions that fit into your work schedule.
  • Learn by working on real-world problemsCapstone projects involving real world data sets with virtual labs for hands-on learning
  • Structured guidance ensuring learning never stops24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts

FAQs

  • How do I enroll for the Online training?

    You can enroll for the training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.
    1. Visa debit/credit card
    2. American express and Diners club card
    3. Master Card, or
    4. Through PayPal

  • What will I get along with this training?

    You will have access to the online e-learning and practice tests along with the training.

  • Can I cancel my enrollment? Do I get a refund?

    Yes, you can cancel your enrollment. We provide you complete refund after deducting the administration fee. To know more please go through our Refund Policy.

  • Do you provide any course completion certificate?

    Yes, we offer course completion certificate after you successfully complete the training program.

  • Where and how can I access the e-learning content? Are there any limitations?

    Once you register with us for a course by paying the course fee, you can have 24/7 access to the e-learning content on our website. An automated course purchase confirmation mail from our side will guide you through the process.

  • I am not able to access the online course. Whom should I contact for a solution?

    Please raise a request via our Help and Support portal to have your issue resolved.

  • Do you provide money back guarantee for the training programs?

    Yes. We do offer a money-back guarantee for many of our training programs. You can refer to the Refund Policy and raise refund requests via our Help and Support portal.

  • Do you provide any course completion certificate?

    Yes, we offer course completion certificate after you successfully complete the training program.

  • What is Simplilearn’s Exam pass guarantee?

    We guarantee you will pass your certification exams provided you use Simplilearn’s online training materials the way they are intended to be used. One has to satisfy certain parameters in order for the guarantee to be validated. You can contact support@simplilearn.com for more information.

  • What is Microsoft Access 2010 training all about?

    This training equips you with the knowledge and skills on how to perform tasks in Access 2010, such as using existing databases, creating new databases, building tables, and creating or editing forms and reports.

  • What is in store for me in terms of increasing my technical capabilities if I go for this certification training?

    You will learn to master Microsoft Access 2010 and use it to keep track of important information. The training also provide the ability to split a database into front-end and back-end components and safely share data with other users while keeping your interface private.

  • Are there any pre-requisites before starting Microsoft Access 2010 training?

    Beginners or experienced Access users, both can enroll for this course.

  • I want to know more about the training program. Whom do I contact?

    Please join our Live Chat for instant support, call us, or Request a Call Back to have your query resolved.

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.