About This Course
Course Curriculum
-
Tour of the screen00:11:00
-
Using Design view to create and edit tables00:45:00
-
Using the lookup wizard00:09:00
-
Importing data from Other Data Sources into Access00:18:00
-
Linking Tables from Other data Sources into Access00:10:00
-
Exporting data from Access to other data types00:03:00
-
Creating and Managing Table Relationships00:10:00
-
Database Tools00:05:00
-
Sort and Filter a Table00:06:00
-
Basic Queries00:22:00
-
Prompting the user for the criteria00:05:00
-
Creating Calculated Fields in a Query00:10:00
-
Creating Totals Queries00:08:00
-
Multiple table Queries00:12:00
-
Viewing the SQL code for an Access Query00:06:00
-
Using the Query Wizards00:09:00
-
Creating Subqueries00:03:00
-
Creating Make Table, Append, Update and Delete Queries00:19:00
-
Displaying a certain number of records00:01:00
-
Assignment – Microsoft Access Tables and Queries