Access Tables and Queries – 2 – Using Design view to create and edit tables

Access Tables and Queries – 3 – Using the lookup wizard

Access Tables and Queries – 4 – Importing data from Other Data Sources into Access

Access Tables and Queries – 5 – Linking Tables from Other data Sources into Access

Access Tables and Queries – 6 – Exporting data from Access to other data types

Access Tables and Queries – 7 – Creating and Managing Table Relationships

Access Tables and Queries – 8 – Database Tools

Access Tables and Queries – 9 – Sort and Filter a Table

Access Tables and Queries – 10 – Basic Queries

Access Tables and Queries – 11 – Prompting the user for the criteria

Access Tables and Queries – 12 – Creating Calculated Fields in a Query

Access Tables and Queries – 13 -Creating Totals Queries

Access Tables and Queries – 14 – Multiple table Queries

Access Tables and Queries – 15 – Viewing the SQL code for an Access Query

Access Tables and Queries – 16 – Using the Query Wizards

Access Tables and Queries – 17 – Creating Subqueries

Access Tables and Queries – 18 – Creating Make Table, Append, Update and Delete Queries

Access Tables and Queries – 19 – Displaying a certain number of records

Exercise Materials