how to create a ledger to add points instead of money

[Guest]

I am trying to create a table to keep track of points earned by date and then
add them to a form. Like creating a ledger but instead of money keet track of
the points. I have the tables and form for the database but I can't figure
out how to create the table and link it to the form for these points. Can
anybody help me?

 

[Joseph Meehan]

I am trying to create a table to keep track of points earned by date
and then add them to a form. Like creating a ledger but instead of
money keet track of the points. I have the tables and form for the
database but I can't figure out how to create the table and link it
to the form for these points. Can anybody help me?

"I have the tables"
"I can't figure out how to create the table"

How about trying the explication again. This does not seem to make
sense.

"keep track of points earned by date and then add them to a form"

Forms are used to capture or display data, generally one record (event)
at a time. Reports are generally used to display or print results.

I am not sure, but are you sure you want to use Access, the Microsoft
professional database? Microsoft Excel, the Microsoft spreadsheet program,
might be better for your project. Excel acts much like an automatic
spreadsheet and it usually easier for someone to learn to use. Access can
handle larger amounts of data and can do some things Excel can not, but it
does require a bit more knowledge to use it.

It sounds like you either need a lot more knowledge of how a database
works, or I am just having a difficult time understanding what your question
is. The basic concept of how a database works is not easy to understand at
first. It just takes a little experience.

 

[Brendan Reynolds]

I'm not quite sure what the question is here, because you say you 'have the
tables' and then you say that you 'can't figure out how to create the
table'. This seems to be a contradiction? If you can't figure out how to
create the table, then in what sense do you 'have the tables'?

To link (or 'bind', to use the customary terminology) a table to a form, set
the RecordSource property of the form to the name of the table, or to the
name of a query based on the table, or a SQL statement that selects from the
table. Then set the ControlSource property of each control (textbox,
combobox, etc) on the form to the name of the relevant column in the table,
query or SQL statement. You'll find the RowSource property on the 'Data' tab
in the Properties window in form design view when the form itself is
selected (choose 'Select Form' from the Edit menu) and the ControlSource
property also on the 'Data' tab when you select an individual control (just
click on the control).

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Guest]

Hello Joseph, let me try to expalin it again. I am puting together a database
for my work. We need to keep track of of a new program for juveniles place in
the program by court. The database will help us keep track of, who is the
juvenile, where he/she lives, which court put him/her in the program, who is
his/her Probation Officer among many other things. Every weekend the
juvenile will earn max of 14 points, 7 for saturday and 7 for sunday. I have
done everything but I am having problems figuring out how to keep track of
those points earn by date which can be from 4 weekends up to 20. In sum
accumulating the points by date and showing them on the form. do this help?

 

[Joseph Meehan]

Hello Joseph, let me try to expalin it again. I am puting together a
database for my work. We need to keep track of of a new program for
juveniles place in the program by court. The database will help us
keep track of, who is the juvenile, where he/she lives, which court
put him/her in the program, who is his/her Probation Officer among
many other things. Every weekend the juvenile will earn max of 14
points, 7 for saturday and 7 for sunday. I have done everything but I
am having problems figuring out how to keep track of those points
earn by date which can be from 4 weekends up to 20. In sum
accumulating the points by date and showing them on the form. do this
help?

OK. Let's start with tables to record the data.

One table for each juvenile and their demographic information. That is
their name and - or other ID information as well as things like birth date
(don't record age because that changes). You want to include all the
information about them that stays the same. Some things like address may
be included but in this case it is hard for me to guess. If they have
several or if it is often changed or shared by many others, then that would
mean a different way of recording it.

Next table would be for points. You will need an ID to relate this
information to the juvenile (If they already have a unique ID number you can
use that, or you can let Access assign them.) This ID needs to be the same
in both the Juvenile and the points tables for each individual. You will
also need a number field to record the numbers and a date field to record
the date earned.

Likewise you will need a table for the different courts again listing
things like contact person address phone number etc.

When you are done and have all the relations between tables set up you
can use "Forms" to enter data that will let you mix the different tables as
if they were all part of the same record. You can find all the juveniles
that have been assigned to that court and when they were assigned or find
how many points were earned by juveniles from that court during a given time
etc.

Take a look at the sample database (Northwind) to get some ideas to
start with.

Setting all this up takes time, but in the long run it is well worth it.