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.

General	Interface	Design Objects
Fundamentals	The Ribbon	The Properties Window
Help	The Navigation Pane	Input Box
MCAS Topics		Message Box

Tables

Forms

Reports

Queries

Introduction	Introduction	Introduction	Introduction
Datasheet View	Dialog Boxes	Grouping Records	As a Record Source
Column in Datasheet		Print Invoice
Column in Design View

Data Import/Export

Records

Relationships

MS SQL Server	Data Entry
Microsoft Excel	Find/Replace
Text Files	Create With SQL
XML \| HTML	Update
Mail Merge	Delete

Sorting

Filtering

SQL/Filter Operators

Introduction	Introduction	Introduction to SQL
Sorting on Forms	Sorting/Filtering Numbers	AND	AS	BETWEEN
Sorting Strings	Filtering Strings	IN	IS	LIKE
Sorting Date/Time	Filtering Date/Time	NOT	NULL	OR
	Sorting/Filtering Boolean	ORDER BY	UNIQUE	WHERE
	Filtering By Form

SQL Operations

CREATE TABLE

ALTER TABLE

INSERT INTO

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

Splitting a Database	Pseudo-Variables	Order Entry Form

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

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	MS Access 2003	SQL Server	C++	Managed C++	Delphi	C#	HTML	MySQL .NET	VBScript	Win32
Windows	VBA For MS Access	ASP.NET	Visual C++	MS Word	Object Pascal	Visual C#	MS Excel	MS PowerPoint	JavaScript	Visual Basic


	Copyright © 2008, FunctionX, Inc.	Contact
	Last Update: Thursday, 15 May 2008 16:47