Instant Access Databases Book

	Acknowledgments	xi
	Book Structure	xii
	Final Note	xv
Section 1	Access Programming Basics	1
Chapter 1	Intro to Access	3
	Creating Efficient and Effective Access Databases	3
	Creating Tables	3
	Field Names and Description	4
	Data Types	5
	Primary Keys	10
	Indexes	11
	Field Properties	12
	Table Properties	19
	Relationships	20
	Defined	20
	Relationships Dialog	21
	Summary	23
Chapter 2	Access Programming Techniques	25
	Beyond Wizards	25
	Designing Forms, Reports, and Controls	25
	Sections	25
	Form Properties	29
	Report Properties	32
	Control Properties	33
	Creating Code	35
	Creating Code Through a Wizard	35
	Learning Through Macros	37
	Visual Basic Editor and the Code Window	39
	Events	40
	Form Events	40
	Report Events	42
	Control Events	42
	Data Access Objects	44
Section 2	Instant Access Databases	47
Chapter 3	Employees	49
	Databases to Manage Employees	49
	Sample Walk-through	50
	Table Definitions and Relationships	55
	Field Specifications	56
	Forms	60
	Reports	69
	Employee Testing Database	70
	Sample Walk-through	70
	Table Definitions and Relationships	74
	Field Specifications	76
	Forms	78
	Report	89
	Job Application Database	89
	Sample Walk-through	90
	Table Definitions and Relationships	91
	Field Specifications	92
	Forms	94
	Report	100
Chapter 4	Company Management	101
	Databases to Solve Internal Business Needs	101
	Purchase Order Database	102
	Sample Walk-through	102
	Table Definitions and Relationships	115
	Field Specifications	117
	Forms	119
	Reports	125
	Equipment Check Out Database	126
	Sample Walk-through	126
	Table Definitions and Relationships	132
	Field Specifications	133
	Forms	136
	Reports	144
Chapter 5	Databases for Managing Networks	147
	Keeping Track of Software and Hardware	147
	Software Documentation Database	148
	Sample Walk-through	148
	Table Definitions and Relationships	155
	Field Specifications	157
	Forms	162
	Reports	177
	Code Library Database	178
	Sample Walk-through	178
	Table Definitions and Relationships	182
	Field Specifications	183
	Forms	186
	Report	193
	Software - Hardware Profiles Database	194
	Sample Walk-through	194
	Table Definitions and Relationships	200
	Field Specifications	202
	Forms	208
	Reports	214
Chapter 6	Events	215
	Working with a Venue and Its Events	215
	Events Database	216
	Sample Walk-through	216
	Table Definitions and Relationships	220
	Field Specifications	222
	Forms	224
	Reports	240
Chapter 7	Working with Customers	243
	Managing Customers, Orders, and Contacts	243
	Customers Database	244
	Sample Walk-through	244
	Table Definitions and Relationships	251
	Field Specifications	254
	Forms	262
	Reports	274
	Contact Manager Database	275
	Sample Walk-through	275
	Table Definitions and Relationships	279
	Field Specifications	280
	Modules	283
	Forms	283
	Reports	289
Chapter 8	Products	293
	Managing Inventory and Warehouses	293
	Products Database	294
	Sample Walk-through	294
	Table Definitions and Relationships	301
	Field Specifications	302
	Forms	308
	Reports	327
Chapter 9	Help Desk	329
	Managing Customer Problems and Resolutions	329
	Help Desk Database	330
	Sample Walk-through	330
	Table Definitions and Relationships	339
	Field Specifications	342
	Forms	349
	Library Notes Form	363
	Reports	368
Chapter 10	Project Management	371
	Working with Projects, Milestones, and Steps	371
	Project Management Database	372
	Sample Walk-through	372
	Table Definitions and Relationships	380
	Field Specifications	382
	Forms	390
	Reports	404
Chapter 11	Students, Teachers, and Courses	411
	Managing the Functionality of an Educational Institution	411
	Students, Teachers and Courses Database	412
	Sample Walk-through	412
	Table Definitions and Relationships	423
	Field Specifications	426
	Forms	435
	Reports	452
Chapter 12	Company Specific	455
	Databases That Meet the Needs of Specific Companies	455
	Room Reservations Database	456
	Sample Walk-through	456
	Table Definitions and Relationships	462
	Field Specifications	465
	Forms	470
	Report	489
	Property Manager Database	490
	Sample Walk-through	490
	Table Definitions and Relationships	494
	Field Specifications	495
	Forms	497
	Reports	504
Chapter 13	PIM	507
	Personal Information Manager	507
	PIM Database	508
	Sample Walk-through	508
	Table Definitions and Relationships	512
	Field Specifications	513
	Forms	515
	Report	542
Chapter 14	Working with MS Office	543
	Using Word, Excel, and PowerPoint to Enhance your Database Applications	543
	Word Form Letters Database	547
	Sample Walk-through	548
	Customers Table	550
	Customers Form	552
	Word Table Database	560
	Sample Walk-through	560
	Word Table Form	561
	Using Excel Database	568
	Sample Walk-through	568
	Using Excel Form	570
	Using PowerPoint Database	583
	Sample Walk-through	583
	Using PowerPoint Form	584
Section 3	Advanced Topics	589
Chapter 15	Creating Add-Ins and Wizards	591
	Extending the Functionality of Access with Your Own Tools	591
	DBInfo Database	592
	Sample Walk-through	592
	Creating the Add-In Database	594
	UsysRegInfo Table	595
	GeneralProcs Module	597
	DB Info Form	597
	Form Dialog Wizard	598
	Sample Walk-through	599
	USysRegInfo Table	601
	GeneralProcs Module	602
	Create a Dialog Form	602
	My Table Wizard Database Add-In	611
	Sample Walk-through	611
	USysRegInfo Table	614
	GeneralProcs Module	616
	Table Builder Form	616
Chapter 16	Creating Static Web Pages from Access	627
	Building Simple Web Pages Based on Your Access Database	627
	Exporting to HTML	628
	HTML Templates	632
	Hyperlink Data Type	637
	Creating Custom Static Pages Through Code	639
	Instructors Form	643
	HTML Table Form	648
Chapter 17	Creating Dynamic Web Content	657
	Working with Data Access Pages	657
	IIS and PWS	658
	Data Access Pages	663
	Defined	663
	Creating Data Access Pages with Wizards	664
	Data Access Page Properties and Controls	670
	Data Access Page	670
	Sections, Sorting, and Grouping	672
	Controls	677
	Record Navigation Control	677
	Expand Control	678
	Bound HTML Control	679
	Scrolling Text Control	680
	Bound Hyperlink and Hyperlink Controls	681
Chapter 18	Using Active Server Pages (ASP)	683
	Creating Dynamic Server-Side Internet Solutions	683
	What Is ASP?	684
	How ASP Works	685
	Advantages of Using ASP and Server-Side Scripting	686
	Simple ASP Samples	687
	Simple Hello Web	687
	An ASP That Tells Time	689
	ASP Object Model	691
	The Request Object	693
	The Response Object	699
	GLOBAL.ASA and the Application and Session Objects	703
	The Server Object	705
	Creating ASPs for the Students, Teachers, and Courses Database	705
	Sample Walk-through	706
	Creating a DSN	710
	Active Server Page Application	711
Appendix A	Upsizing to SQL Server	727
	Index	733