Results 1 to 4 of 4
  1. #1
    lizziew71 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    1

    Beginner with Big Project

    Hi. I am an average Access user, but a beginner at building databases. I need help with, what I think is a big project. Currently, all of my tracking and reporting is done in Excel (using at least 8 different files). I would like to consolidate this in Access, keep and import data to multiple tables, generate reports, and build forms to enter my data.

    For example:
    Spreadsheet 1 = Table 1: Active part numbers - to generate reports
    Spreadsheet 2 = Table 2: New part numbers - I want to be able to feed this information into Table 1 as I update
    Spreadsheet 3 = Table 3: Customer request for information on part numbers - I want this to feed into Table 2 then I can generate a response with specific information in a report
    Spreadsheet 4 = Table 4: List of Suppliers - I want this to link to Tables 1 and 2 and export
    Spreadsheet 5 = Table 5: Overseas supplier Request for Quote - I want to pull from Table 2 to generate report to send to suppliers for quotes then upload back into Table 2 for updates
    Spreadsheet 6 = Table 6: Local suppliers (4 - their form is different than overseas) Request for Quote - I want to pull from Table 2 to generate report to send to suppliers for quotes then upload back into Table 2 for updates
    Spreadsheet 7 = Table 7: Comparison sheet - once I receive quotes back and they upload to Table 2, I need to look in Table 1 for certain criteria (+ or - 3% variance of same kind of part) and pull existing (Active) part numbers prices to compare

    Is this even possible? I can picture what I want, but I don't know how to create it.

    I would be so grateful for any help someone can give me.



    Thanks
    Liz

    My version is MS Office Professional Plus 2019

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,070
    What you've written is subject to interpretation for sure, but it suggests to me that you need to learn what normalization is when it comes to databases. An Excel brain is a liability here, not a help. As an example, Suppliers would not "link" to Customers.
    Beginning with normalization, here's a few links worth looking in to before you start anything.

    Normalization Parts I, II, III, IV, and V
    http://rogersaccessblog.blogspot.com...on-part-i.html
    and/or
    http://holowczak.com/database-normalization/

    Entity-Relationship Diagramming: Part I, II, III and IV
    http://rogersaccessblog.blogspot.com...ng-part-i.html

    How do I Create an Application in Microsoft Access?
    http://rogersaccessblog.blogspot.com...cation-in.html

    Important for success:
    Naming conventions
    http://access.mvps.org/access/general/gen0012.htm
    https://www.access-programmers.co.uk...d.php?t=225837

    What not to use in names
    http://allenbrowne.com/AppIssueBadWord.html

    About Auto Numbers
    http://www.utteraccess.com/wiki/Autonumbers
    http://access.mvps.org/access/general/gen0025.htm

    The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
    Table and PK design tips - http://www.fmsinc.com/free/newtips/primarykey.asp
    About calculated table fields - http://allenbrowne.com/casu-14.html
    About Multi Value Fields -http://www.mendipdatasystems.co.uk/multivalued-fields/4594468763
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  3. #3
    Bullschmidt's Avatar
    Bullschmidt is offline Freelance DB Developer
    Windows 10 Office 365
    Join Date
    Mar 2020
    Location
    USA
    Posts
    64
    Spreadsheet 1 = Table 1: Active part numbers - to generate reports
    Spreadsheet 2 = Table 2: New part numbers - I want to be able to feed this information into Table 1 as I update
    I would suggest putting both of these into one Access table with a yes/no field for if the part is new. And then at any time you could uncheck the field for a part that is no longer considered new.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,852
    I agree with Micron's comments and 'reference materials".
    I also have a number of articles in the Database Planning and Design link in my signature than you may find useful.
    Whatever you do, review Normalization and some database concepts before getting too deeply involved in physical Access.

    Good luck with your project.

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

Similar Threads

  1. Help here please for beginner!
    By markpastoril in forum Access
    Replies: 9
    Last Post: 07-08-2019, 01:53 AM
  2. Beginner looking for help
    By abztaffyboy in forum Database Design
    Replies: 18
    Last Post: 10-12-2018, 07:00 AM
  3. Replies: 2
    Last Post: 10-17-2016, 09:29 PM
  4. Replies: 8
    Last Post: 07-16-2014, 12:51 PM
  5. Help a DB beginner
    By adquinn in forum Access
    Replies: 0
    Last Post: 02-08-2011, 08:25 PM

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 - Senior Forums