Re: Contact Info/ Phone Log for Families K -12

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

John,

Now this is a perfect example of what a thread should be. The OP has a
problem that obviously he/she can not solve alone. Through this thread the
OP now has two options. You provided some very good links for the OP to
begin getting up to speed with Access. The OP can choose this option if
he/she has an inordinate amount of time to spend on the Access learning
curve. If the OP wishes to get a database up and running as soon as
possible, the OP can choose to have me create the database for him/her for a
modest fee.

Steve



"John W. Vinson" <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:np9ob4p80mo4h3c09pkcbqb0nbiu1milp8@xxxxxxxxxx
On Mon, 1 Sep 2008 08:41:01 -0700, CJ Melo
<CJMelo@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

I am trying to design a simple to use, attractive database to enter
contact
information and keep a phone log for correspondance with parents regarding
their students in a K-12 environment.
I would need to have parent names (first and last), work phone, home
phone,
cell phone, student names (first and last), grades, cell phone, and a way
to
automatically time and date stamp any phone calls I made, as well as a
place
to put expanded notes.

I found a template for sales calls, but it's not quite what I need and I
don't know how to modify it. No one I know has experience with Access (I
am
using 2003) so I am on my own.

Any ideas? Database design is new to me, and I am confused by the
definitions of tables and forms. I tried using the wizard, but I don't
think
I am doing this right. HELP!

Here's some links to free resources that may give you a start. Crystal's
and
Allen's tutorials should give you an overview of how to proceed. The first
thing to get into your thinking is "Normalization" - proper structure and
relationships for your tables. The sales calls template may give you some
of
what you want but surely it doesn't incoroporate family relationships, so
you
will need to add some tables.

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
--

John W. Vinson [MVP]


.

Relevant Pages

  • Re: Change all Names: objects, fields, code, etc.
    ... to fint and replace the names of any objects in your database ... A couple of newsgroups I always recommend for Access newbies are: ... A list of priceless Access resources I cribbed from the frequent posts ... Roger Carlson's tutorials, samples and tips: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: tutorial, books
    ... Jeff Conrad's resources page: ... A free tutorial written by Crystal (MS Access MVP): ... MVP Allen Browne's tutorials: ... mailing list, see Idaho Code 9-348"). ...
    (microsoft.public.access.gettingstarted)
  • Re: My database is all messed up
    ... database off the help files alone. ... I fully agree with Jeff; you really need to step back, learn how Access works, ... Check out some of the resources at: ... A free tutorial written by Crystal (MS Access MVP): ...
    (microsoft.public.access.tablesdbdesign)
  • Re: I think I need a tutor
    ... The current project is to enter the data from a stack of questionnaires ... Access resources and tutorials: ... A free tutorial written by Crystal (MS Access MVP): ...
    (microsoft.public.access.tablesdbdesign)
  • Re: tutorial, books
    ... would like to set up a data base for dallas, ... Jeff Conrad's resources page: ... A free tutorial written by Crystal (MS Access MVP): ... MVP Allen Browne's tutorials: ...
    (microsoft.public.access.gettingstarted)