Results 1 to 2 of 2
  1. #1
    Dewey1128 is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    1

    Creating the correct tables


    Im new to access. I have an excel sheet that I am using to track statistical information regarding our lead sources. Each sheet is for a seperate lead source and each sources has the same column headings such as....Sent, Prospects, Qualified Prospects, Contacts, Qualified Contacts, Sets, Leads, Appointments, Demos, Sales, Installs. In addition, there are columns for tracking financials for each lead source such payroll, list cost, out going Postage, return postage, etc. How many tables should be used.....I was thinking one table for Lead sources, with Source Category, Source Name, and Source Location? Then A second with all the other above stated columns. Is this correct or should I create additional tables. Any Help would be appreciated

  2. #2
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Before proceeding I suggest that you research NORMALISATION.

    There are may articles on the web for you to read.

    Once you have a grasp of that then post your table design for people to comment and help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Creating an expression with two tables
    By dssrun in forum Queries
    Replies: 3
    Last Post: 12-21-2010, 07:56 AM
  2. Creating tables from scripts
    By accesscoder in forum Import/Export Data
    Replies: 6
    Last Post: 10-18-2010, 04:42 PM
  3. Replies: 1
    Last Post: 07-27-2010, 08:02 AM
  4. trouble creating correct criteria
    By pshawk in forum Queries
    Replies: 1
    Last Post: 02-12-2010, 01:52 AM
  5. Creating Form from Normalized Tables
    By heathers in forum Forms
    Replies: 2
    Last Post: 09-10-2009, 03:43 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums