Database Structure, First time use and other information
In order to properly run this database on a computer that does not
have the full version of Microsoft Access 2000 loaded you must load the
runtime version. However, currently the runtime version operates properly
in Windows XP only... Note: While we have not extensively tested this under Vista, the
database does seem to run just fine...
If you do not have Windows XP, you must
purchase/install Microsoft Access (2000) and although the database works
under later versions of Access, we have not completed the conversions.
If you run this under later versions and are prompted to "convert"
do not convert. You must configure the Access Module References as shown here.
To do this, press F11 to access the main database windows, move to the
Modules tab, select "design" on any one of the modules, then from the
Tools menu, select References... |
 |
The database is split to a “front-end” “back-end” database where
Lionsdata.mdb holds the actual data and _Lions.mdb is the front end holding the
forms, reports, etc.
It is the _Lions.mdb you will open and work
from.
Notes:
- If upon opening you receive a macro error, “halt” the macro then run the
Tools menu > Database Utilities > Link Table Manager and reconnect to the
lionsdata.mdb.
- If you want to experiment with data, make a backup copy of the lionsdata.mdb file!
- While the front end - back end tends to hamper performance slightly, it
does make it easier to experiment with date, modify reports, share the data
database, etc...
Do not change
the structure or relationships of any table and extreme caution should be used
when editing tables directly. Because of dependencies between
tables, removing or editing a record in one table may have adverse affects on
other the table’s data.
- You will be prompted to locate and select the data – database. Use
the browse button to locate then “open” the Lionsdata file.
- Open the Club’s records form (from the forms menu) and modify the
information to include the club’s quarterly dues amount.
- Enter the membership information from the main form.
- Open the checking account register
and enter your checking account starting balance. We suggest using a
description like Beginning Adjustment.
This simple database tracks the club’s dues and expenses. Like any
program, the key is to entering data correctly, remember, garbage in – garbage
out. Think of database storage as a table where each row is a record and
each cell is a field:
| Record1 Name |
Record1 Address |
Record1 Phone |
Record1City, etc |
| Record2 Name |
Record2 Address |
Record2 Phone |
Record2 City, etc |
Although the data is stored in the above basic format, it is presented to you
through various forms that control and check data entry.
Back a page |
Home page