Results 1 to 2 of 2
  1. #1
    stan101 is offline Novice
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Posts
    1

    assistance with database to connect to excel frontend


    Hi All, I am looking for some guidance on a basic database to use as a back end for an Excel frontend. I currently have a complex spreadsheet with tables that I use to populate cascading drop down lists. The tabes contain different timber and sizes. When I get a new range of timber, I copy and rename the spreadsheet and then change the tables. I would like to have the ability to have a userform with pages for each timber type so I can turn on the different sizes and grades.

    I have some ability with VBA in Excel so I am sure I can handle the userforms. What I am not sure about is designing the database. Attached is an example Excel workbook with two sheets. sheet "tables" is an example of the way the timber is currently used. Sheet "working sheet" is a simple example of the front end. There will be a few more entries and in time I would like to create a new userform to create new Access tables as new types of timber may be called for in future. I really want to use Excel as the front end for various reasons.

    Am I correct that each column in my "tables" sheet should be table in the access database. Example: Access Table 1 called "Material" and first field will be "MaterialID" and field two would be range A2:A5. The same for all other columns in my "tables" worksheet. I assume I will also need to have an Access Table called "Customer" with a 'customerID" field and a "customerName" field.

    Could anyone give me some advice on how best to plan the access database and then I can go ahead and create it. I could then upload what I create to then discuss the relationships.

    Also, does anyone have a similar style Database I could look at as an example?

    Thank you in advance.
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    You're on the right track,
    youd make a table for all your lookup tables,
    clients,
    orders,
    orderDetails

    create it and working on it is the best way to learn what you need.

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

Similar Threads

  1. Locking Down Frontend Database
    By data808 in forum Access
    Replies: 6
    Last Post: 10-07-2015, 08:51 AM
  2. Replies: 2
    Last Post: 02-16-2013, 12:35 PM
  3. Replies: 1
    Last Post: 06-12-2012, 03:01 PM
  4. Replies: 2
    Last Post: 03-28-2012, 11:35 AM
  5. 2 SQL Database sources one frontend
    By kevinharding in forum Programming
    Replies: 3
    Last Post: 03-22-2006, 06:34 AM

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