Course Curriculum
- 2 sections
- 20 lectures
- 00:00:00 total length
-
Tour of the screen
00:11:00 -
Using Design view to create and edit tables
00:45:00 -
Using the lookup wizard
00:09:00 -
Importing data from Other Data Sources into Access
00:18:00 -
Linking Tables from Other data Sources into Access
00:10:00 -
Exporting data from Access to other data types
00:03:00 -
Creating and Managing Table Relationships
00:10:00 -
Database Tools
00:05:00 -
Sort and Filter a Table
00:06:00 -
Basic Queries
00:22:00 -
Prompting the user for the criteria
00:05:00 -
Creating Calculated Fields in a Query
00:10:00 -
Creating Totals Queries
00:08:00 -
Multiple table Queries
00:12:00 -
Viewing the SQL code for an Access Query
00:06:00 -
Using the Query Wizards
00:09:00 -
Creating Subqueries
00:03:00 -
Creating Make Table, Append, Update and Delete Queries
00:19:00 -
Displaying a certain number of records
00:01:00
-
Assignment – Microsoft Access Tables and Queries
00:00:00