Appendix A. Table Structures
This appendix gives you a complete listing of all the tables included in the Time and Billing application. Each table includes the following
A list of the field names, types, and lengths of each field in the table
A detailed list of the properties associated with each field in the table
The tblClients Table
This table stores pertinent information about each client, such as the company name, contact name, and phone numbers.
Table A.1. The tblClients Table
Field Name | Type | Size (Bytes) |
|---|---|---|
ClientID | Number (Long) | 4 |
CompanyName | Text | 50 |
ContactFirstName | Text | 30 |
ContactLastName | Text | 50 |
ContactTitle | Text | 50 |
ContactTypeID | Number (Long) | 4 |
ReferredBy | Text | 30 |
AssociatedWith | Text | 30 |
IntroDate | Date/Time | 8 |
DefaultRate | Currency | 8 |
Notes | Memo | (Varies) |
Miles | Number (Long) | 4 |
TermTypeID ... |
Get Alison Balter’s Mastering Microsoft Access 2002 Desktop Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
