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_2007

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 2007

    74 Lessons      03:03:11 hrs

    Microsoft Access is a powerful program to create and manage r databases. It has many built-in features to assist in constructing and viewing r 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

    • +

      Introduction


       

      Introduction to Microsoft Access 2007

      02:21

       

      N/A

       

      N/A


       

      Understanding Databases

      02:41

       

      N/A

       

      N/A


       

      Access 2007 Workspace

      02:19

       

      N/A

       

      N/A


       

      Access 2007 Workspace

      06:39

       

      N/A

       

      N/A


    • +

      Familiarizing the Interface


       

      Access 2007 Interface: A Closer Look

      06:28

       

      N/A

       

      N/A


       

      Access 2007 Global Settings

      03:38

       

      N/A

       

      N/A


    • +

      Building a Database


       

      Creating A Database

      02:29

       

      N/A

       

      N/A


       

      Creating Tables

      03:47

       

      N/A

       

      N/A


       

      Adding Primary Key

      01:41

       

      N/A

       

      N/A


       

      Table Validation Rules

      02:19

       

      N/A

       

      N/A


       

      Defining Indexes

      02:11

       

      N/A

       

      N/A


       

      Defining Table Relationships

      02:17

       

      N/A

       

      N/A


       

      Database Limitations

      01:11

       

      N/A

       

      N/A


    • +

      Modifying a Database


       

      Renaming Objects

      01:05

       

      N/A

       

      N/A


       

      Deleting an Object

      01:22

       

      N/A

       

      N/A


       

      Modifying Tables:Renaming Fields

      01:17

       

      N/A

       

      N/A


       

      Modifying Tables:Adding Caption to Fields

      01:16

       

      N/A

       

      N/A


       

      Modifying Tables:Adding New Fields

      01:10

       

      N/A

       

      N/A


       

      Modifying Tables:Moving Fields

      01:26

       

      N/A

       

      N/A


       

      Modifying Tables:Deleting Fields

      01:16

       

      N/A

       

      N/A


       

      Changing Data Attributes

      01:44

       

      N/A

       

      N/A


       

      Lookup Properties

      02:21

       

      N/A

       

      N/A


       

      Modifying Primary Keys

      01:14

       

      N/A

       

      N/A


       

      Compacting Database

      01:50

       

      N/A

       

      N/A


    • +

      Importing and Linking Data


       

      Creating DSN

      04:18

       

      N/A

       

      N/A


       

      Importing Vs. Linking

      01:59

       

      N/A

       

      N/A


       

      Importing Data from SQL Server

      02:43

       

      N/A

       

      N/A


       

      Importing Data from a SpreadSheet

      03:02

       

      N/A

       

      N/A


       

      Importing Data from a Text File

      03:19

       

      N/A

       

      N/A


       

      Modifying Imported Tables

      01:00

       

      N/A

       

      N/A


       

      Linking Files

      02:51

       

      N/A

       

      N/A


    • +

      Working with Queries


       

      Single Table Data Query

      02:25

       

      N/A

       

      N/A


       

      Query Datasheet View

      02:22

       

      N/A

       

      N/A


       

      Query using Multiple Tables

      03:52

       

      N/A

       

      N/A


       

      Using Query Wizard

      02:15

       

      N/A

       

      N/A


       

      Summary Information

      02:28

       

      N/A

       

      N/A


       

      Parameterized Queries

      02:44

       

      N/A

       

      N/A


       

      Query Properties

      02:31

       

      N/A

       

      N/A


       

      SQL View

      03:25

       

      N/A

       

      N/A


       

      PivotTables and PivotCharts

      04:08

       

      N/A

       

      N/A


    • +

      Modification Data with Queries


       

      Updating Row Groups

      03:58

       

      N/A

       

      N/A


       

      New Table using Make Table Query

      02:10

       

      N/A

       

      N/A


       

      Inserting Data from Another Table

      02:09

       

      N/A

       

      N/A


       

      Delete Row Groups

      01:57

       

      N/A

       

      N/A


       

      Troubleshooting Action Queries

      02:19

       

      N/A

       

      N/A


       

      Searching a Record

      01:22

       

      N/A

       

      N/A


       

      Modifying Data using Forms

      01:04

       

      N/A

       

      N/A


       

      Printing Forms

      01:36

       

      N/A

       

      N/A


    • +

      Creating and Working with Forms


       

      Forms Overview

      02:08

       

      N/A

       

      N/A


       

      Form Wizard - Building a Data Input Form

      03:32

       

      N/A

       

      N/A


       

      Form Design View

      01:39

       

      N/A

       

      N/A


       

      Modifying Lookups

      03:10

       

      N/A

       

      N/A


       

      Data Input using Forms

      01:49

       

      N/A

       

      N/A


    • +

      Modifying Forms


       

      Layout View

      03:07

       

      N/A

       

      N/A


       

      Enchancing the look of a Form

      02:07

       

      N/A

       

      N/A


       

      Form Properties

      02:56

       

      N/A

       

      N/A


       

      Control Properties

      03:16

       

      N/A

       

      N/A


    • +

      Form Design - Advanced


       

      Form using Multiple Table Query

      03:21

       

      N/A

       

      N/A


       

      Sub-Forms

      03:00

       

      N/A

       

      N/A


       

      Using the Option Button

      03:57

       

      N/A

       

      N/A


       

      Conditional Formatting

      02:16

       

      N/A

       

      N/A


       

      Tab Controls in a Form

      03:35

       

      N/A

       

      N/A


       

      Using ActiveX Controls

      03:02

       

      N/A

       

      N/A


       

      Form Design - Conclusion

      01:25

       

      N/A

       

      N/A


    • +

      Designing Reports


       

      An Overview of Reports

      01:07

       

      N/A

       

      N/A


       

      Printing Reports

      01:30

       

      N/A

       

      N/A


       

      Creating Reports using Report Command

      01:40

       

      N/A

       

      N/A


       

      Creating Reports using Report Wizard

      03:24

       

      N/A

       

      N/A


       

      Report Properties

      02:43

       

      N/A

       

      N/A


       

      Building Complex Reports

      00:59

       

      N/A

       

      N/A


    • +

      Internet and Access 2007


       

      Understanding Static Pages

      03:34

       

      N/A

       

      N/A


       

      Understanding Dynamic Pages

      01:52

       

      N/A

       

      N/A


       

      Creating Dynamic Web Pages

      02:09

       

      N/A

       

      N/A


       

      Access 2007 and SharePoint

      01:54

       

      N/A

       

      N/A


    Self Assessment

    Attempts

    Status

    Introduction

    0

     


    Familiarizing the Interface

    0

     


    Building a Database

    0

     


    Modifying a Database

    0

     


    Importing and Linking Data

    0

     


    Working with Queries

    0

     


    Modification Data with Queries

    0

     


    Creating and Working with Forms

    0

     


    Modifying Forms

    0

     


    Form Design - Advanced

    0

     


    Designing Reports

    0

     


    Internet and Access 2007

    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.