A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Help needed with table design/layout for newbie



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old June 4th, 2010, 07:20 PM posted to microsoft.public.access.tablesdbdesign
jase118
external usenet poster
 
Posts: 4
Default Help needed with table design/layout for newbie

Hi, i have just joined the forum and have built a few DB's in the past but
found i have forgotten almost everything!
I do remember with a previous DB i layed the tables out incorrectly which
impacted on the flexibility down the line so would like advise before i start
in order to get a good foundation.
My dB is for our watersports centre to book people onto courses and retain
their details in a contacts table to be imported to Outlook for mailing info.
We run various courses which then run on multiple dates across the year. So
for example we may run a Powerboat Level 1 course, this then runs 4-6 jan, 4-
6 Feb and so on. I then need to add customers to each course date (i want to
retain the customer information for use on email or telephone marketing etc)
This is the basic concept, the additional functionality i require is:

-Add/ Remove courses - add/remove course dates

-view courses by type or date (ie view all power boat courses, or all courses
for January or all powerboat courses for January)

-view available spaces on courses (same search criteria as above)

-Add/ Remove people off courses

-Print bookings (same search criteria as above)

-view reserve space bookings (people who can fill cancellation slots on
certain courses at certain dates)

-View payments received /outstanding payments

This is my plan for the way i want it to work! I now need to start building
the tables.
For the contacts table i plan on using the same format as Outlook contacts so
i can import directly into outlook for emailing customers (i would be happy
to change this especially if i could send mails direct from access into
Outlook, rather than importing a contacts list every-time i add a new name)
I am very open to suggestions here as i am finding the first step a bit
daunting and dont want to waste lots of time making a DB that wont do what i
want a bit later down the line.
I have tried to give as much detail as i can, if you want to know anything
else please ask.

I will be grateful for any help with this

Cheers
Jase

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:55 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.