Access 2010

Access 2010  icon
 03:37:10 Hrs

Course Description

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.

Video Resolution:
   800 X 600
   1024 X 768
BM
Lesson Plans
Duration
Status
Notes

Collapse all Expand all

  •   Author MentoringOpen or Close
    -

    Audience for this Course

    01:47

     
     


    -

    Job Roles and Employment Opportunities

    01:05

     
     


    -

    Pre-requisite Knowledge and Skills

    00:56

     
     


  •   Database Theory and DesignOpen or Close
    -

    What is a Database?

    03:08

     
     


    -

    What is Normalization?

    04:46

     
     


    -

    Creating a Database Using the Database Wizards

    03:06

     
     


    -

    Create a Database without the Wizard

    02:28

     
     


    -

    Exploring the Relational Database

    03:09

     
     


    -

    Ways to share an Access database - Part I

    05:56

     
     


    -

    Ways to share an Access database - Part II

    02:47

     
     


  •   TablesOpen or Close
    -

    Creating a Database Table

    03:27

     
     


    -

    Using the Correct Data Types

    05:22

     
     


    -

    Managing Fields Properties

    03:01

     
     


    -

    Adding an Input Mask - Part I

    04:49

     
     


    -

    Adding an Input Mask - Part II

    02:36

     
     


    -

    Working with Validation Rule - Part I

    05:12

     
     


    -

    Working with Validation Rule - Part II

    02:47

     
     


  •   Working With Table DataOpen or Close
    -

    The New Calculated Field in Access 2010

    03:55

     
     


    -

    The Primary Key Constraint

    03:45

     
     


    -

    Sorting Data in a Table

    03:22

     
     


    -

    Filtering Table Data - Part I

    02:38

     
     


    -

    Filtering Table Data - Part II

    04:19

     
     


    -

    Find and Replace Field Values

    02:42

     
     


  •   QueriesOpen or Close
    -

    What is A Query?

    04:14

     
     


    -

    Working with CrossTab Query

    03:09

     
     


    -

    Adding Criteria In a Query

    05:01

     
     


    -

    Working with Parameter Query

    03:14

     
     


    -

    Boolean Fields in Querying

    03:08

     
     


    -

    Working with Wildcards

    03:54

     
     


    -

    Sorting the Results of a Query

    02:57

     
     


  •   Working the RelationshipsOpen or Close
    -

    What are Relationships?

    05:13

     
     


    -

    Referential Integrity

    02:50

     
     


    -

    Creating Relationships between Tables

    04:53

     
     


    -

    Cascading Updates and Deletes

    02:51

     
     


  •   LayoutsOpen or Close
    -

    Understanding Layouts

    01:58

     
     


    -

    Using Layouts

    01:44

     
     


    -

    Working with Rows and Columns in a Layout

    03:15

     
     


  •   FormsOpen or Close
    -

    Understanding Layout and Design Views

    02:34

     
     


    -

    Creating a Form Using the Form Tool

    02:14

     
     


    -

    Creating a Form Using the Wizard

    03:11

     
     


    -

    Fine-tune the Forms in Views

    03:17

     
     


    -

    Working with Blank Forms

    02:54

     
     


    -

    Working with Tab Order

    02:55

     
     


  •   ReportsOpen or Close
    -

    Categorizing Types of Access Reports

    02:58

     
     


    -

    Creating a Basic Report Using the Wizard

    02:15

     
     


    -

    Working with Grouped Reports

    03:46

     
     


    -

    Adding Sorting and Totals

    02:58

     
     


    -

    Export a Report

    01:58

     
     


    -

    Adding Conditional Formats

    03:12

     
     


  •   MacrosOpen or Close
    -

    What are Access Macros?

    01:35

     
     


    -

    How do I view a Macro's Actions?

    03:19

     
     


    -

    Embedded Macros with the Buttons

    03:58

     
     


    -

    Working with Combo Boxes

    03:20

     
     


BM
Tips & Tricks
Status
Self Assessments
Attempts
Status

Author Mentoring

-

Fundamentals of Access

-

Setting Up the Environment

-

Getting Acquainted with Access 2010

-

Database Theory and Design

-

Tables

-

Working with Table Data

-

Queries

-

Working the Relationships

-

Layouts

-

Forms

-

Reports

-

Importing and Exporting Data

-

Macros

-
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.