| |
|
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 1/9/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. |
|
| |
|
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!
|
|
|
|
|
|
| |
|
|
