Microsoft Office Access 2007 Lessons

Microsoft Access is an application used to create small and midsize computer desktop databases for the Microsoft Windows family of operating systems. It can also be used as a database server for a web-based application. It is also supported by ADO, ODBC, and the .NET Framework, etc.

This web site provides lessons on how to use Microsoft Office Access 2007 to create and manage databases. The lessons follow a step-by-step format with practical examples.

To follow these lessons, you must have Microsoft Office Access 2007 installed on your computer. The lessons are listed on the left side of this page. Below, the lessons are presented as topics.

The content of this web site is available for purchase as an ebook.

Databases Created in the Lessons

Database	Creation	1st Use	Continue	End
BCR1	Lesson 3
Cruise2		Lesson 3
Exercise2	Lesson 6
Real Estate1	Lesson 14
Real Estate2	Lesson 15
Real Estate3	Lesson 16
Real Estate4	Lesson 17
Danilo Pizza1		Lesson 9	12
Fun Furniture	Lesson 5
Altair Realtors1	Lesson 11		26, 26
Altair Realtors2		Lesson 15	19, 20, 22, 23, 24, 25, 26
Hotel Management	Lesson 8		9
Red Oak High School	Lesson 5		11, 15, 16, 18
Bethesda Car Rental1		Lesson 3	7, 9, 11, 12, 15, 20, 21, 26
Bethesda Car Rental5		Lesson 4
Clarksville Ice Cream1	Lesson 2		4, 5, 19
Clarksville Ice Cream2	Lesson 26
Rockville Technologies	Lesson 1
Contributor Fundraising	Lesson 5
Georgetown Dry Cleaner1	Lesson 13
Georgetown Dry Cleaner2	Lesson 16
Georgetown Dry Cleaner3	Lesson 17
Georgetown Dry Cleaner4	Lesson 18

Databases in the Exercises

Database	Creation	Continue	End
Yugo National Bank	Lesson 2	3,5,6,7,8,9,15,16,17,18,19,20, 21, 22, 23, 24, 25, 26
Watts a Loan	Lesson 2	3, 5, 7, 15, 16, 17, 18, 19, 20, 21, 23, 25, 26
World Statistics	Lesson 1	3, 6, 8, 9, 14, 15, 18, 20, 21, 22, 23, 24, 25, 26
US Senate	Lesson 7	8, 14, 15, 16, 17, 18, 20, 21, 22, 23, 24, 25, 26

The Navigation Pane	Microsoft SQL Server	Text Files
Getting Help	Microsoft Excel	HTML Documents
Splitting a Database	Microsoft Word	XML Documents
Pseudo-Variables
Order Entry Form	Strings	MCAS Topics

The Associates	Georgetown Dry Cleaner	Convenience Store
Countries Statistics	Yugo National Bank	Survey
	Watts A Loan	US Senate

Tables	Forms	Print Invoice
Columns	Reports
Records
Message Box	Input Box

Previous version of this web site.

Created on Monday April 21, 2008

Resources for the lessons

These databases were part of Microsoft Access 97 installation. They were released again with Microsoft Access 2000 but without the sample values. Then, they were not released anymore. They are good databases for learning various things in database development (of course you can open them with Microsoft Office Access 2007 and convert them (you should Enable the security on each file)).

Address Book	Household Inventory	Recipes
Asset Tracking	Inventory Control	Resource Scheduling
Book Collection	Ledger	Service Call Management
Contact Management	Membership	Students and Classes
Donations	Music Collection	Time and Billing
Event Management	Order Entry	Video Collection
Expenses	Picture Library	Wine List
	Workout


FunctionX Press	VBA For MS Access	C++	Managed C++	Delphi	C#	HTML	MySQL .NET	VBScript	Win32
Windows	ASP.NET	Visual C++	MS Word	Object Pascal	Visual C#	MS Excel	MS PowerPoint	JavaScript	Visual Basic


	Copyright © 2008, FunctionX, Inc.	Contact
	Last Update: Friday, 25 April 2008 08:24