Access 2003 programming by example with VBA, XML, and ASP /
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Plano, Tex. :
Wordware Pub.,
2005.
|
| Subjects: | |
| Online Access: | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=130650 |
Table of Contents:
- Procedures and modules
- The Visual Basic editor (VBE)
- Variables, data types, and constants
- Passing arguments to procedures and functions
- Decision making with VBA
- Repeating actions in VBA
- Working with arrays
- Custom collections and class modules
- Debugging VBA procedures and handling errors
- Accessing data using ADO
- Creating and accessing tables and fields with ADO
- Setting up indexes and table relationships with ADO
- ADO techniques for finding and reading records
- Working with records
- Creating and running queries with ADO
- Using advanced ADO features
- Implementing database security with ADOX and JRO
- Database replication
- Creating, modifying, and deleting tables and fields
- Enforcing data integrity and relationships between tables
- Defining indexes and primary keys
- Database security
- Views and stored procedures
- Using form events
- Using report events
- Events recognized by controls
- Access and active server pages
- XML features in Access 2003
- Creating and manipulating databases with DAO.