Skip to Main Content
Alison Balter's Mastering Access 97 Development, Second Edition
book

Alison Balter's Mastering Access 97 Development, Second Edition

by Alison Balter
January 1997
Intermediate to advanced content levelIntermediate to advanced
1168 pages
26h 17m
English
Sams
Content preview from Alison Balter's Mastering Access 97 Development, Second Edition

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 NameTypeSize (Bytes)
ClientIDNumber (Long)4
CompanyNameText50
AddressText255
CityText30
StateProvinceText20
PostalCodeText20
CountryText20
ContactFirstNameText30
ContactLastNameText50
ContactTitleText50
OfficePhoneText30
FaxText30
CellularText30
HomeText30
EMailAddressText30
ReferredBy ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Alison Balter’s Mastering Microsoft® Office Access 2007 Development

Alison Balter’s Mastering Microsoft® Office Access 2007 Development

Alison Balter

Publisher Resources

ISBN: 0672309998Purchase book