| |
|
Courses - Microsoft
Access 320 |
| Description: |
Advanced Access
Recordsets |
| Running Time: |
93 minutes |
| Pre-Requisites: |
Access 313 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 7/7/2009 to
get a FREE upgrade to our 2007 version when released!
|
|
|
|
|
| |
|
Full course details with screenshots coming soon.
Access 320 - Course Outline
1. Recordset Basics
What is a Recordset?
Why use Recordsets?
Example Uses For Recordsets
Turn Off VBA Project Explorer
Tools > References
What is a Library?
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library
DAO vs. ADO, Brief Discussion
2. Our First Recordset
Create a Database Object
Create a Recordset Object
OpenRecordSet
db.Name, rs.Name
Closing Our Objects
Freeing Memory (Set to Nothing)
Creating a Status Box
Display Field Data: FirstName
When to use ! vs .
Ways to Refer to Fields
rs!Fieldname
rs("Fieldname")
rs(Index)
rs![First Name]
Create Unbound Text Boxes
Store RS Data Into Text Boxes
3. Moving Around, Part 1
MoveNext
MovePrevious
MoveFirst
MoveLast
Move X
EOF End of File
BOF Beginning of File
Endless Loops
Create a Counter
Dim Variables Outside of Subs
Variable Scope
Opening Recordset With Form Opened
Closing Recordset When Form Closed
4. Moving Around, Part 2
Buttons to Move Around Recordset
Dealing with Hitting EOF/BOF
RecordCount Property
5. Finding Records, Part 1
FindFirst
Types of Recordsets
dbOpenTable
dbOpenDynaset
dbOpenSnapshot
dbOpenForwardOnly
NoMatch
6. Finding Records, Part 2
Wildcard Search
Dynamic SQL For FindFirst
Do Loop
FindFirst
FindPrevious
|
|
 |
Huge Discounts Available
When you purchase multiple classes together
Huge savings up to 50% off! Order Now. |
|
| |
Student Interaction:
Microsoft Access 320
|
Richard on 1/1/2008:
Recordset basics, creating a recordset, moving around in recordsets, finding records. |
|
BRYAN binkerd on 7/1/2009: on lesson 02, first recordset time frame 0736, I understand the StatusText = S & vbnewline but I don't understand the "& StatusText" that follows the statement. |
|
Richard Rost on 7/2/2009: Bryan, that's just to continue with whatever previous StatusText was there before. It's like saying:
X = A + X
It takes X, adds A to the beginning, and then whatever X was there before. It's so you can keep a long listing of continuous "status" information. |
|
bryan binkerd on 7/3/2009: thanks for the clarification. You rock. |
|
Richard Rost on 7/3/2009: Thanks, Bryan. I try. :) |
|
|
| |
| |
|
You may want to read these articles from the 599CD Blog: |
|
| |
|
 |
Need
Help? |
| |
|
| Do you have
questions about
Word, Excel, Access, Web Design, or computers in general? Just
ask us anything you'd like. |
|
|
|
|
|
| |
|
CLICK HERE for a FREE
lesson |
Order
your first 599CD course now.
Your Satisfaction is Guaranteed!
|
|
|
|
|
|
| |
|
|
