Free Trial

You get to enjoy all premium features and unlimited course access in WingsLive.com for 1 day free trial.

It takes only 30 Seconds! Try now!

Membership

Get unlimited course access, exclusive features and learn on any device with our premium account that helps you to meet all your learning objectives.

Access Code

If you purchased an access code card in any outlet or if you have any of our Discount Code, Gift Code, Promo Code, Please Click here.

Login


Forgot password? Click here

Send us your Feedback

Forgot Password?

Please enter your registered email address to reset your password: you will receive an email with further instructions.

Free Trial Account

Sign up with:

Sign up with Facebook
Sign up with Google

Sign up with Email:

Share this course to your loved one

via Mail ID

Embed Link

Copy this link
www.wingslive.com/index.php/courses/Access_2010

Quick Links

  •   Buy Gift

    Give a Gift of Knowledge

    "It always remembers, Give a man a fish, and you feed him for a day;
    Show him how to catch fish, and you feed him for a lifetime."

    Three simple processes for ordering it.
    Step 1: Simply decide which subscription plan you would like to give as a gift
    Step 2: Tell us whom you want this to be send
    Step 3: Complete the payment and leave the reset to us!
    We will send our WingsLive Gift Voucher code, in an attractive gift wallet & envelope,
    bearing your individual gift message, to your selected delivery address within 3 working
    days (or) We will send our WingsLive Gift Voucher code, in an attractive E-Greeting card,
    bearing your individual gift message, to the given email address within few minutes of
    time.
      CBT Store   Contact Us
  • Search Result

    Access 2010

    79 Lessons      04:30:37 hrs

    Microsoft Access is a powerful program to create and manage databases. It has many built-in features to assist in constructing and viewing information. Access is much more involved and is a more genuine database application than other programs such as Microsoft Works.

    Screen Resolution Available On
    CD/DVD-Rom's, Online, Apps

    Searched Keyword:
    << Back

    BM

    Lesson Plans

    Duration

    Status

    ABL

    Notes

    Excersice


    Collapse all Expand all

    • +

      Author Mentoring


       

      Audience for this Course

      01:47

       

      N/A

       

      N/A


       

      Job Roles and Employment Opportunities

      01:05

       

      N/A

       

      N/A


       

      Pre-requisite Knowledge and Skills

      00:56

       

      N/A

       

      N/A


    • +

      Fundamentals of Access


       

      History of Microsoft Access

      02:43

       

      N/A

       

      N/A


       

      What is Microsoft Access?

      05:02

       

      N/A

       

      N/A


       

      Course Objective

      01:39

       

      N/A

       

      N/A


    • +

      Setting Up the Environment


       

      Checklist for Installation

      01:43

       

      N/A

       

      N/A


       

      Step by Step Installation

      02:47

       

      N/A

       

      N/A


    • +

      Getting Acquainted with Access 2010


       

      Navigating the User Interface

      05:47

       

      N/A

       

      N/A


       

      The New File Menu in Access 2010

      07:15

       

      N/A

       

      N/A


       

      Making the Most of the Navigation Pane

      05:53

       

      N/A

       

      N/A


       

      Customize the Quick Access Toolbar

      04:39

       

      N/A

       

      N/A


    • +

      Database Theory and Design


       

      What is a Database?

      03:08

       

      N/A

       

      N/A


       

      What is Normalization?

      04:46

       

      N/A

       

      N/A


       

      Creating a Database Using the Database Wizards

      03:06

       

      N/A

       

      N/A


       

      Create a Database without the Wizard

      02:28

       

      N/A

       

      N/A


       

      Exploring the Relational Database

      03:09

       

      N/A

       

      N/A


       

      Ways to share an Access database – Part I

      05:56

       

      N/A

       

      N/A


       

      Ways to share an Access database – Part II

      02:47

       

      N/A

       

      N/A


    • +

      Tables


       

      Creating a Database Table

      03:27

       

      N/A

       

      N/A


       

      Using the Correct Data Types

      05:22

       

      N/A

       

      N/A


       

      Managing Fields Properties

      03:01

       

      N/A

       

      N/A


       

      Adding an Input Mask – Part I

      04:49

       

      N/A

       

      N/A


       

      Adding an Input Mask – Part II

      02:36

       

      N/A

       

      N/A


       

      Working with Validation Rule – Part I

      05:12

       

      N/A

       

      N/A


       

      Working with Validation Rule – Part II

      02:47

       

      N/A

       

      N/A


    • +

      Working With Table Data


       

      The New Calculated Field in Access 2010

      03:55

       

      N/A

       

      N/A


       

      The Primary Key Constraint

      03:45

       

      N/A

       

      N/A


       

      Sorting Data in a Table

      03:22

       

      N/A

       

      N/A


       

      Filtering Table Data – Part I

      02:38

       

      N/A

       

      N/A


       

      Filtering Table Data – Part II

      04:19

       

      N/A

       

      N/A


       

      Find and Replace Field Values

      02:42

       

      N/A

       

      N/A


    • +

      Queries


       

      What is A Query?

      04:14

       

      N/A

       

      N/A


       

      Working with CrossTab Query

      03:09

       

      N/A

       

      N/A


       

      Adding Criteria In a Query

      05:01

       

      N/A

       

      N/A


       

      Working with Parameter Query

      03:14

       

      N/A

       

      N/A


       

      Boolean Fields in Querying

      03:08

       

      N/A

       

      N/A


       

      Working with Wildcards

      03:54

       

      N/A

       

      N/A


       

      Sorting the Results of a Query

      02:57

       

      N/A

       

      N/A


       

      Produce Totals Using an Access Query

      02:19

       

      N/A

       

      N/A


       

      Finding Duplicate Records With a Query

      04:06

       

      N/A

       

      N/A


       

      Queries With The iif Function

      02:36

       

      N/A

       

      N/A


    • +

      Working the Relationships


       

      What are Relationships?

      05:13

       

      N/A

       

      N/A


       

      Referential Integrity

      02:50

       

      N/A

       

      N/A


       

      Creating Relationships between Tables

      04:53

       

      N/A

       

      N/A


       

      Cascading Updates and Deletes

      02:51

       

      N/A

       

      N/A


    • +

      Layouts


       

      Understanding Layouts

      01:58

       

      N/A

       

      N/A


       

      Using Layouts

      01:44

       

      N/A

       

      N/A


       

      Working with Rows and Columns in a Layout

      03:15

       

      N/A

       

      N/A


    • +

      Forms


       

      Understanding Layout and Design Views

      02:34

       

      N/A

       

      N/A


       

      Creating a Form Using the Form Tool

      02:14

       

      N/A

       

      N/A


       

      Creating a Form Using the Wizard

      03:11

       

      N/A

       

      N/A


       

      Fine-tune the Forms in Views

      03:17

       

      N/A

       

      N/A


       

      Working with Blank Forms

      02:54

       

      N/A

       

      N/A


       

      Working with Tab Order

      02:55

       

      N/A

       

      N/A


       

      Creating a Split Form

      03:03

       

      N/A

       

      N/A


       

      Add Logos and Images in a Form

      02:53

       

      N/A

       

      N/A


       

      Finding Records in a Form

      03:20

       

      N/A

       

      N/A


       

      Working with the Properties Window

      04:35

       

      N/A

       

      N/A


       

      Types of Properties

      05:07

       

      N/A

       

      N/A


    • +

      Reports


       

      Categorizing Types of Access Reports

      02:58

       

      N/A

       

      N/A


       

      Creating a Basic Report Using the Wizard

      02:15

       

      N/A

       

      N/A


       

      Working with Grouped Reports

      03:46

       

      N/A

       

      N/A


       

      Adding Sorting and Totals

      02:58

       

      N/A

       

      N/A


       

      Export a Report

      01:58

       

      N/A

       

      N/A


       

      Adding Conditional Formats

      03:12

       

      N/A

       

      N/A


       

      Understanding Sub Reports

      03:30

       

      N/A

       

      N/A


       

      Adding Images In Reports

      03:06

       

      N/A

       

      N/A


       

      Creating a Sub Report

      01:14

       

      N/A

       

      N/A


    • +

      Importing and Exporting Data


       

      Exporting Tables to Excel Application

      02:58

       

      N/A

       

      N/A


       

      Importing Data into Access from Excel

      04:56

       

      N/A

       

      N/A


    • +

      Macros


       

      What are Access Macros?

      01:35

       

      N/A

       

      N/A


       

      How do I view a Macro’s Actions?

      03:19

       

      N/A

       

      N/A


       

      Embedded Macros with the Buttons

      03:58

       

      N/A

       

      N/A


       

      Working with Combo Boxes

      03:20

       

      N/A

       

      N/A


    • +

      Migrating Access 2007 to Access 2010


       

      Why Should We Migrate To Access 2010?

      03:59

       

      N/A

       

      N/A


       

      A Closer Look into Access 2010-I

      05:17

       

      N/A

       

      N/A


       

      A Closer Look into Access 2010-II

      05:06

       

      N/A

       

      N/A


       

      Convert Older Databases to Access 2010

      03:16

       

      N/A

       

      N/A


    Self Assessment

    Attempts

    Status

    Author Mentoring

    0

     


    Fundamentals of Access

    0

     


    Setting Up the Environment

    0

     


    Getting Acquainted with Access 2010

    0

     


    Database Theory and Design

    0

     


    Tables

    0

     


    Working with Table Data

    0

     


    Queries

    0

     


    Working the Relationships

    0

     


    Layouts

    0

     


    Forms

    0

     


    Reports

    0

     


    Importing and Exporting Data

    0

     


    Macros

    0

     


    Migrating Access 2007 to Access 2010

    0

     


    Lesson Plans

    Tips and Tricks

    Glossary

    A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

    Glossary is not available for this index.