+ Reply to Thread
Results 1 to 3 of 3

large database, structure and software q's

  1. #1
    Registered User
    Join Date
    08-25-2013
    Location
    Epsom
    MS-Off Ver
    2013
    Posts
    59

    large database, structure and software q's

    Hi,

    Im trying to build a new database out of what we've got at the moment we have a big database of 6000 retail stores divided into 4 divisions, 21 regions and 110 areas with each of them managed by a divisional, regional, and area managers. Each store holds a number of fields of information. all this is kept in one excel sheet, so 6000 rows down, therefore i'm not happy with it and trying to find ways of improving. im thinking splitting database in smaller parts and linking them together in access, however i am not sure what an efficient way of making changes to stores would be. i.e a regional managers wants to move some of his/her stores from one area manager to another,in excel that could be done using vlookup to filter relevant stores, but how can this be done in access? should i still keep an excel database for convenience of changing multiple stores? Im new to databases so any help is appreciated and sorry if my question is ambiguous, will give more details if needed. and would the best practice of moving, creating database be?

    Thanks
    Rome wasn't built in a day

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: large database, structure and software q's

    Do you understand what database normalisation is? If not, start there, you can't come up with a design before you understand the fundamentals.

    Some good intros to databases:
    http://www.studytonight.com/dbms/dat...malization.php
    http://forums.aspfree.com/microsoft-...es-208217.html

    How you structure the database really depends on the business process. For example, you may start with the following 5 tables:

    Please Login or Register  to view this content.
    So a store has a single area, which belongs to a region, which belongs to a division. Each of these has a manager.
    Moving a store area simply means changing the Area in the storeDetail table, that will effectively change the division and region to whatever the new area is.

    This may not be flexible enough for your requirements, but it could be a starting point

  3. #3
    Registered User
    Join Date
    08-25-2013
    Location
    Epsom
    MS-Off Ver
    2013
    Posts
    59

    Re: large database, structure and software q's

    Hi Kyle,

    Thank you for your response. At this point is a bit too much to do, to move all the data from excel to access, so instead im trying to link tables together and you perhaps would know if its viable, as I'm strungling to make this happen.

    i have two small excel databases that i want to link together via access, because when creating linking formulas in excel, they take too much time to process. So my idea is to create a linking table in access of one excel database and have it linked back to another excel database. in this way someone can have changes to the first database and its reflected in another, so you got the idea.

    whats not working at the moment, i can't export linked excel table from access, but surely there's got to be a way of doing it. i tried researching bu went nowhere. also in general is this a good idea, should i even move forward with it, will it be efficient in terms of processing speed and updates?

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Connection Between Excel and Other Database software
    By BS Singh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2015, 03:38 PM
  2. Creating a Pyramid Hierarchy structure from a flat structure
    By thegamerulez in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2014, 01:28 AM
  3. Accounting Software through Access Database question
    By stevetothink in forum Access Tables & Databases
    Replies: 0
    Last Post: 05-23-2013, 09:52 AM
  4. How to structure database
    By todmac in forum Access Tables & Databases
    Replies: 2
    Last Post: 04-05-2012, 02:16 PM
  5. Large Database
    By jwaldmann in forum Excel General
    Replies: 4
    Last Post: 02-10-2012, 10:52 PM
  6. [SOLVED] Database Structure
    By ianmaggy in forum Access Tables & Databases
    Replies: 1
    Last Post: 02-02-2011, 08:59 AM
  7. VBA lookup into large database
    By erikhs in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-29-2006, 02:36 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1