| |
|
Courses - Microsoft
Access 321 |
| Description: |
Advanced Access
Recordsets |
| Running Time: |
79 minutes |
| Pre-Requisites: |
Access 320 very strongly recommended |
| Versions: |
|
We use Access 2003 in this course,
but most of the lessons are valid for all versions of Access from 95 to 2003.
There are cosmetic changes in Access 2007. Order before 2/7/2012 to
get a FREE upgrade to our 2007 version when released!
|
|
|
|
|
| |
|
Full course details with screenshots coming soon.
Access 321 - Course Outline
1. Customer ListBox, Part 1
Open Recordset with SQL
SQL WHERE Statement
Adding Items to a ListBox
AddItem
Row Source Type: Value List
Access 2000 Users: No AddItem
2. Customer ListBox, Part 2
Add the ID
Column Widths
Clearing Your List Box
ListCount
RemoveItem
Combo of Unique States
3. Edit Records
Editing One Record
rs.Edit
rs.Update
Editing Multiple Records
Loop Through And Edit
4. Multi-Select List Boxes
Simple v. Extended
Loop Through Items With ListCount
.ItemData(x)
.Column(1,Row)
.Selected Property
For Each
Object Collections
5. Adding & Deleting Records
Adding a Record
AddNew
Sorting Our Customer List
Deleting Records
rs.Delete
Always Have an Are You Sure? Prompt
6. Execute
db.Execute
INSERT INTO SQL Command
|
| |
|
You may want to read these articles from the 599CD Blog: |
|
| |
|
 |
| |
| Do you have
questions about
Word, Excel, Access, Web Design, or computers in general? Just
ask us anything you'd like.
Click here
for assistance. |
|
|
|
|
|
|
|
|
|
| |
|
|