Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts

    ? a Better Access approach to an Excel order sheet (Office 2003)

    Is there an access database structure with separate tables that would make this excel spreadsheet of customer demographics and items bought work better where I can find what a previous customer has bought and to print a receipt?
    Jerome

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: ? a Better Access approach to an Excel order sheet (Office 2003)

    Take a look at the Northwind database that comes with Access for a possible data structure.

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Re: ? a Better Access approach to an Excel order sheet (Office 2003)

    Hans
    Thanks I had forgotton about that. However it does not track payments or freight charges

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: ? a Better Access approach to an Excel order sheet (Office 2003)

    The Orders table does have a Freight field, but you are correct that Northwind does not track payments.

    For a sample database that includes payments:
    - Activate the New File task pane (File | New...)
    - Click 'General Templates' in the 'New from Template' section.
    - Activate the Databases tab.
    - Select 'Order Entry', then click OK.
    - Follow the instructions of the wizard.

    Also see the recent thread starting at <post#=440021>post 440021</post#>; Wendell posted a link to a useful site in his reply.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •