Professor Gleason

Stetson UniversitySchool of Business Administration
Decision and Information Sciences
421 N. Woodland Boulevard (Unit 8398)
 386-822-7464
 pgleason@stetson.edu

 

Atomic Learning - Access Tutorial 3

Access Tutorial 3 – Maintaining and Querying a Database

Key #

Time

Working with Queries

 

 

Creating a Detail query

34570

2:22

Creating a Summary query

34571

2:32

Creating a query in Design view

34572

2:23

Creating a Multiple Table query

34573

2:41

Adding criteria to a query

34574

2:01

Using logical operators in queries

34575

1:59

Sorting query results

34576

1:48

Using a query to calculate a value

35751

2:52

Prompting for a value in a query

35752

1:10

Summarizing data with the Totals row

35753

1:52

Creating a Make-Table query

35754

1:36

Creating an Update query

35755

2:27

Creating an Append query

35756

2:36

Creating a Delete query

35757

2:53

Finding duplicate records

35758

1:49

Finding unmatched records

35759

2:12

Creating a Union query

37888

3:06

Creating a Crosstab query

37889

2:37

Concatenating two or more fields

37890

1:57

Using the Between And operator

37891

1:11

Using Wild Card characters

37892

1:15

Using the IIF function

37893

1:56

Databse Tools and Maintenance

 

 

Compacting and repairing a database

37939

1:07

Backing up a database

37940

0:36

Using the Database Documenter

37941

1:36

Checking object dependencies

37943

1:15