MS Access Fundamentals
Introduction to Microsoft Access
Introduction to Data Sheets
Intro to Forms and Reports
Database Fields On Sheet
Managing Data Fields
Data Fields on Forms and Reports
Data Field Design
Properties of Data Fields
Operators and Operands
Introduction to Data Types
Using Data Types
Introduction to Relationships
Managing Relationships
Referential Integrity
Introduction to Data Analysis
The Structured Query Language
Queries and Relationships
Exploring Data Analysis
Data Analysis With Charts
Formatting Charts
Action Queries
Data Maintenance, Import/Export
Tables and Queries Aesthetics
Characteristics of Forms
Windows Controls
Types of Forms
Subforms
Introduction to Expressions
Controls and Expressions
Built-In Functions
Series-Based Functions
Domain-Based Functions
Business-Based Functions
Finance-Based Functions
 
Constructive and well-planned work can lead to long term success.

 

Vue de Profil

Microsoft Access is a development environment used to create computer databases for the Microsoft Windows family of operating systems. This site provides lessons, examples, and links on how to use and explore MS Access. We also provide some guidance on VBA, the programming language that ships with Microsoft Access.

 

An electronic version of this site with additional VBA materials, as an ebook, is available for purchase. You can sample the demo version or get the full version.

Sample Solved Exercises
Don't let any body hold your key to success. Grab it yourself! 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).

Convenience Store

This exercise is inspired from watching how a convenience store is managed in a village or small town.

The Associates

This example examines a technique used in some communities to save money without involving a bank.

     Topics
 Fearing to open your (too many) bills will not make them go away. Find a way to deal with them. You know, they ain't going nowhere! Pseudo-Variables
The Command Button Wizard
Order Entry Form
Tax Amount Calculation
     How-To
Print an Invoice
Create Default Values
Add a New Record

This allows you to create a semi-independent form that a clerk can use to perform data entry 

Add New Item From a Combo Box
Pass Argument By Value
Call a Procedure
Update Many Records

Here are two examples of updating records. In one example, we update some records based on a criterion. In another example, we update all records of a particular column.

 
     Controls
Scroll Bars
Progress Bar
Up Down
     Resources
Exercises for this web site

These are databases you may need to follow lessons on this site. If an exercise is missing, please let me know.

 Annie's Carry Out 
Samples Databases

Some sample databases we work on some time to time. Some of them are not complete, meaning you can take over and correct them.
We have also included the sample databases that shipped with Microsoft Access 97 but that were not found in MS Access >= 2000

MOUS Topics

These are the same Microsoft Office User Specialist (MOUS) topics you can find on the Microsoft certification web site. They allow us to check on this site what topics we have covered or forgotten.

 

Experience

These are projects that can help you build your experience. While I plan to work on them, I may not have time. Therefore, you can work on them yourself. If you are attending a class, your teacher can also help you with these.

Motor Vehicle Administration

US Senate: Develop a database of the USE Senate. All information is available on the senate.gov web site.

US Senate1
US Senate2
US Senate3

English Premier League

Countries

Congress or National Assembly
      Examples
 Tick Counter
 CD Publisher
 Color Changer
 Progressive Clock
 
Database Objects
 Letting work pile on your desk can be annoying to others and can be very distracting.

These are fundamental concepts you should know about databases in general and Microsoft Access in particular.

Tables Forms

Data Access Pages

Queries

Reports

 
Handy External Articles
How to Display Images in a Form or in a Report Without Storing the Images in a Table
 

Last Update: Tuesday, March 15, 2011 07:43

Mirror Site

   
 
Other Tutorials
FunctionX Press
Windows
Networking
Access 2007
VBA For MS Access
ADO
ADO.NET
SQL
SQL Server
ASP
ASP.NET
MS Excel
StarCalc
MS PowerPoint
StarImpress
C++
C++/CLI
Managed C++
Visual C++
Visual C++ .NET
C++ Builder
VBasic
Visual Basic
Visual Basic .NET
C#
Visual C#
Java
J#
Visual J#
Object Pascal
Delphi
HTML
VBScript
JavaScript
Win32
XML.NET
 
Links
I am a MOUS Master
 
  

Copyright © 2000-2010, FunctionX, Inc. Version Française Contact