Access 2007

Access 2007 icon
 03:03:11 Hrs

Course Description

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.

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

Collapse all Expand all

  •   IntroductionOpen or Close
    -

    Introduction to Microsoft Access 2007

    02:21

     
     


    -

    Understanding Databases

    02:41

     
     


    -

    Access 2007 Workspace

    02:19

     
     


    -

    Access 2007 Workspace

    06:39

     
     


  •   Modifying a DatabaseOpen or Close
    -

    Renaming Objects

    01:05

     
     


    -

    Deleting an Object

    01:22

     
     


    -

    Modifying Tables:Renaming Fields

    01:17

     
     


    -

    Modifying Tables:Adding Caption to Fields

    01:16

     
     


    -

    Modifying Tables:Adding New Fields

    01:10

     
     


    -

    Modifying Tables:Moving Fields

    01:26

     
     


    -

    Modifying Tables:Deleting Fields

    01:16

     
     


    -

    Changing Data Attributes

    01:44

     
     


    -

    Lookup Properties

    02:21

     
     


    -

    Modifying Primary Keys

    01:14

     
     


    -

    Compacting Database

    01:50

     
     


  •   Importing and Linking DataOpen or Close
    -

    Creating DSN

    04:18

     
     


    -

    Importing Vs. Linking

    01:59

     
     


    -

    Importing Data from SQL Server

    02:43

     
     


    -

    Importing Data from a SpreadSheet

    03:02

     
     


    -

    Importing Data from a Text File

    03:19

     
     


    -

    Modifying Imported Tables

    01:00

     
     


    -

    Linking Files

    02:51

     
     


  •   Working with QueriesOpen or Close
    -

    Single Table Data Query

    02:25

     
     


    -

    Query Datasheet View

    02:22

     
     


    -

    Query using Multiple Tables

    03:52

     
     


    -

    Using Query Wizard

    02:15

     
     


    -

    Summary Information

    02:28

     
     


    -

    Parameterized Queries

    02:44

     
     


    -

    Query Properties

    02:31

     
     


    -

    SQL View

    03:25

     
     


    -

    PivotTables and PivotCharts

    04:08

     
     


  •   Modification Data with QueriesOpen or Close
    -

    Updating Row Groups

    03:58

     
     


    -

    New Table using Make Table Query

    02:10

     
     


    -

    Inserting Data from Another Table

    02:09

     
     


    -

    Delete Row Groups

    01:57

     
     


    -

    Troubleshooting Action Queries

    02:19

     
     


    -

    Searching a Record

    01:22

     
     


    -

    Modifying Data using Forms

    01:04

     
     


    -

    Printing Forms

    01:36

     
     


  •   Modifying FormsOpen or Close
    -

    Layout View

    03:07

     
     


    -

    Enchancing the look of a Form

    02:07

     
     


    -

    Form Properties

    02:56

     
     


    -

    Control Properties

    03:16

     
     


  •   Internet and Access 2007Open or Close
    -

    Understanding Static Pages

    03:34

     
     


    -

    Understanding Dynamic Pages

    01:52

     
     


    -

    Creating Dynamic Web Pages

    02:09

     
     


    -

    Access 2007 and SharePoint

    01:54

     
     


BM
Tips & Tricks
Status
Self Assessments
Attempts
Status
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.