1.   Introduction to VB Access	13. Details on Data Entry
	2.   Objects and Collections	14. Data Entry and Built-In Functions
	3.   Data Types and Variables	15. The Queries of a Database
	4.   DAO, ADO, ADOX, and SQL	16. Printing
	5.   Procedures and Functions	17. Relationships and Data Integrity
	6.   Conditional Statements	18. Data Joins
	7.   Error Handling	19. Details on Creating Queries
	8.   The Tables of a Database	20. Data Analysis
	9.   The Columns of a Table	21. Using Queries
	10. The Forms of an Application	22. Introduction to Record Sets
	11. The Windows Controls of a Form	23. Data Views and Stored Procedures
	12. The Records of a Database

	Time Sheet
	This is an example of locating a record in a table and taking action accordingly. For example, it checks if a record exists already. If so, it would be updated. If it doesn't exist yet, then a new one is created.
	Georgetown Cleaning Services
	This is a better version of the application of the same name referred to in the lessons. This time, we use the DateTimePicker control to help the user specify when the cleaning items and dropped and when they are expected.
	Payroll
	This application simulates the calculation of overtime in a payroll simulation
	Survey Creation
	This exercise is an approach to creating a survey using (only what is available in) Microsoft Access. We also cover creating a sample (pie) chart.
	Compound Interest
	This is an example of calculating the interest accrued on a loan. The calculations are performed depending on an interest rate and the type of frequency (monthly, annually, etc).

Exercises: These are the files supposed to accompany the lessons of this site. If something is wrong with them, please let me know because I haven't checked them for a while. Download

 

Databases Created

Database	Start	Continue	End

Department of Records and Statistics	Lesson 1		Lesson 14
Exercise1		Lesson 2, Lesson 3	Lesson 4
Exercise2		Lesson 3	Lesson 5
Exercise3			Lesson 6
GCS1	Lesson 8	Lesson 9	Lesson 10
GCS2	Lesson 11		Lesson 12
College Park Auto Shop1	Lesson 12		Lesson 13
Solas Property Management	Lesson 14		Lesson 16
ROSH		Lesson 15, Lesson 16	Lesson 22
Yugo National Bank	Lesson 16	Lesson 17, Lesson 19	Lesson 21
Car Inventory			Lesson 18
Solas Property Rental	Lesson 20		Lesson 21