|
|
|
 |
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 |
|
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. |
|
|
|
|
|
|
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.
|
|
|
|
| Database Objects |
 |
These are fundamental concepts you
should know about databases in general and Microsoft Access in
particular.
|
| Tables |
Forms |
Data Access Pages
|
|
Queries
|
Reports
|
|
|
Last Update:
Wednesday, October 05, 2016 22:25
|
Mirror Site
|
|
|
Introduction to Microsoft Access
