Texarkana College Home
BCIS Access Project 2 Video Tutorial
    Assignments to Print Handout (pdf)

Introduction to Queries AC74-76
    What is a query and why do we need them?
    Special instructions on printing and assignment names
Simple Query Wizard AC76-79
Using Criteria AC81-82
Create a Query in Design View AC83-86
Using Wildcards AC87
Using Criteria Not Displayed in Query Results AC88-89
Parameter Queries AC89-91
Numeric Criteria AC93
Numeric Criteria with Comparison Operators AC94
Compound Criteria (ANDs and ORs) AC95-96
Sorting the Results AC97-99
Omitting Duplicates AC100-101
Sorting on Multiple Fields AC101-102
Creating Top-Values Queries AC102-103
Joining Tables AC103-107
Changing Join Properties AC108-109
Creating a Report Based on a Join Query AC109-111
Using Criteria in Join Queries AC112
Calculated Fields AC113-115
Changing Captions (Column Headings) AC116-117
Calculating Statistics AC117-119
Using Criteria with Aggregate Queries AC120-121
Grouping and Aggregate Queries AC121-122
Crosstab Queries AC122-125
 
 
 Re: Lab 1 Step 1
 Re: Lab 1 Step 3
 
 Re: Lab 1 Step 5
 
 Re: Lab 1 Step 2
 
 Re: Lab 1 Step 4
 Re: Lab 1 Step 4
 Re: Lab 1 Step 7
 Re: Lab 1 Step 6
 Re: Lab 1 Step 7
 Re: Lab 1 Step 7
 
 
 Re: Lab 1 Step 8
 Re: Lab 1 Step 8
 Re: Lab 1 Step 9
 Re: Lab 1 Step 10
 Re: Lab 1 Step 11
 Re: Lab 1 Step 12