Creating Relationships with the Lookup Wizard
Creating Aggregate Queries
Create Basic Queries

21:59

Create Basic Queries

Learn how to search your database for specific information and results. You will also learn how to manipulate your data using a calculated field.

Create Basic Queries
Creating Reports in Access
Creating Aggregate Queries

08:27

Creating Aggregate Queries

Aggregate queries can take large amounts of information and summarize this into more meaningful results.

Creating Aggregate Queries
Crosstab Queries
Creating Reports in Access

14:47

Creating Reports in Access

Access reports are powerful tools for summarizing and presenting data. Learn some tips and techniques for creating meaningful reports.

Creating Reports in Access
Creating Forms
Crosstab Queries

06:47

Crosstab Queries

Crosstab queries help to summarize data in a very effective way--think of Aggregate Queries, but even more awesome! Learn how to use the Query Wizard to create a Crosstab Query.

Crosstab Queries
Unmatched and Duplicate Queries
Creating Forms

13:06

Creating Forms

Forms are used in Microsoft Access for data entry and also for output. Learn the basics of creating forms and adding features, such as graphics and command buttons.

Creating Forms
Creating Relationships in Access
Unmatched and Duplicate Queries

09:39

Unmatched and Duplicate Queries

Learn how to use the Query Wizard in Access to generate useful information.

Unmatched and Duplicate Queries
Create an Access Database
Creating Relationships in Access

09:58

Creating Relationships in Access

Creating relationships between tables in Access is the key to unlocking the most valuable information from your database. You will learn the principles and technique for establishing relationships.

Creating Relationships in Access
Creating Relationships with the Lookup Wizard
Create an Access Database

21:11

Create an Access Database

Learn how to create an Access database. No previous knowledge is required! You will create an Access database file and then will create tables. Learn some useful tips and techniques for getting off to a good start in Access.

Create an Access Database
Create Basic Queries
Creating Relationships with the Lookup Wizard

13:39

Creating Relationships with the Lookup Wizard

You will review the importance of referential integrity when creating relationships in Access. Then you will learn a second way of creating relationships between tables that makes data entry much more efficient and accurate. The Lookup Wizard method will create a relationship between two tables, and it will also provide the user with a drop-down list from which to select the correct entry. You will learn how to modify a database relationship to a Lookup, and will also learn how to create…

‹ ›

Most Popular

  • Thumbnail for entry Create Basic Queries

    21:59

    Create Basic Queries

    Create Basic Queries

    From Sask Polytech AVMedia

    1,466 plays 0  
    Learn how to search your database for specific information and results. You will also learn how to manipulate your data using a calculated field.
  • Thumbnail for entry Creating Aggregate Queries

    08:27

    Creating Aggregate Queries

    Creating Aggregate Queries

    From Sask Polytech AVMedia

    1,251 plays 0  
    Aggregate queries can take large amounts of information and summarize this into more meaningful results.
  • Thumbnail for entry Creating Reports in Access

    14:47

    Creating Reports in Access

    Creating Reports in Access

    From Sask Polytech AVMedia

    1,011 plays 0  
    Access reports are powerful tools for summarizing and presenting data. Learn some tips and techniques for creating meaningful reports.