Database
Design starts with a solid table structure which will determine
the foundation of the information that is being tracked.
It is imperative that your program is easy to use. We develop
all of our database applications so that an inexperienced
computer user can sit down and understand how to use the
program without extensive training.
Try
adding information to the administration form below.
Membership
Database Administration
The
data you entered automatically updates the Membership List
seen online by all users. If this were a live database,
the data you inserted would continuously be added to the
end of the list. Using a similar form as the one above,
you can also edit and delete any entry from the form. All
changes appear immediately.
Internal Membership List
Name |
Address |
Phone
Number |
Dues
Paid |
Joe
Smith |
123
Main St |
Somewhere,
St 00000 |
|
800-555-1212 |
Yes |
Sally
Jones |
456
Some Blvd. |
Aplace,
St 11111 |
|
888-123-1234 |
No |
|
|
|
|
You can
let your users have access to selected records based on access
permissions. Thus the accounting department can modify the
accounting sections using the assigned user id and password.
If you want to display a list of the members and their phone
numbers only for public viewing, the information would appear
as shown below and gathered from the same database.
Public
Membership List
Name |
Phone
Number |
Joe
Smith |
800-555-1212 |
Sally
Jones |
888-123-1234 |
|
|
|