|
Free ebooks
 Free database ebooks Access Access 2003 Programming by Example with VBA XML and ASP
|
||||||||
 Chapter 1 — Procedures and Modules - In this chapter you learn about types of Access procedures that you can write, and learn how and where they are written.Chapter 2 — The Visual Basic Editor (VBE) - In this chapter you learn almost everything you need to know about working with the Visual Basic Editor window, commonly referred to as VBE. Chapter 3 — Variables, Data Types, and Constants - In this chapter you are introduced to basic VBA concepts that allow you to store various pieces of information for later use. Chapter 4 — Passing Arguments to Procedures and Functions - In this chapter you find out how to provide additional information to your procedures and functions before they are run. Chapter 5 — Decision Making with VBA - In this chapter you learn how to control your program flow with a number of different decision-making statements. Chapter 6 — Repeating Actions in VBA - In this chapter you learn how you can repeat the same actions by using so-called looping structures. Chapter 7 — Working with Arrays - In this chapter you learn the concept of static and dynamic arrays that you can use for holding various values. Chapter 8 — Custom Collections and Class Modules - In this chapter you learn how to create and use your own objects and collections of objects. Chapter 9 — Debugging VBA Procedures and Handling Errors - In this chapter you begin using built-in debugging tools to test your programming code and trap errors. Chapter 10 — Accessing Data Using ADO - In this chapter you start your encounter with ADO objects by learning several ways of accessing data from various data sources (Microsoft Access,Excel, and dBASE, as well as text files). Chapter 11 — Creating and Accessing Tables and Fields with ADO - In this chapter you learn how to create, copy, link, and delete database tables programmatically. Chapter 12 — Setting Up Indexes and Table Relationships with ADO - In this chapter you learn how to write VBA code to add primary keys and indexes to your database tables. You also learn how to use objects from the ADOX library to create relationships between your tables. Chapter 13 — ADO Techniques for Finding and Reading Records - In this chapter you practice various methods of using programming code to open a set of database records commonly referred to as a recordset. Chapter 14 — Working with Records - In this chapter you learn how to perform essential database operations such as adding, updating, and deleting records. You also learn how to render your database records into three popular formats. Chapter 15 — Creating and Running Queries with ADO - In this chapter you learn how to use VBA code instead of the Query Design view to create and run various types of database queries. Chapter 16 — Using Advanced ADO Features - In this chapter you learn several advanced ADO features such as how to disconnect a recordset from a database, save it in a disk file, clone it, and shape it. Chapter 17 — Implementing Database Security with ADOX and JRO - In this chapter you learn how to secure a Microsoft Access database from VBA procedures by using various methods that are available in the ADOX and JRO object libraries. Chapter 18 — Database Replication - In this chapter you learn how to make a database available in various geographical locations by using database replication. Chapter 19 — Creating, Modifying, and Deleting Tables and Fields - In this chapter you learn special Data Definition Language commands for creating a new Access database, as well as creating, modifying, and deleting tables. Chapter 20 — Enforcing Data Integrity and Relationships between Tables - In this chapter you learn how to define rules regarding the values allowed in table fields to enforce data integrity and relationships between tables. Chapter 21 — Defining Indexes and Primary Keys - In this chapter you learn DDL commands for creating indexes and primary keys. Chapter 22 — Database Security - In this chapter you learn how to use DDL commands to manage security in the Microsoft Access database. Download free pdf ebooks on access: Access 2003 Programming by Example with VBA XML and ASP
|
| More free ebooks | |