Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-10-2019, 05:27 PM   #1
cannystanny
Newly Registered User
 
Join Date: Sep 2019
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
cannystanny is on a distinguished road
Supplier Database Assistance

Good Evening, I am trying to figure out if it is possible to create a database of all of my departments suppliers and their contact info, brands they carry, types of industries they serve, person of contact, address, phone number etc and be able to search on a form any one of the categories and to have a list populate of the closest matches from the table data. The goal is to have someone to be able to search a particular brand if that is all they know and for the search tool to be able to pull up all suppliers that offer it and list their contact info. Any assistance is welcomed because I am a novice at Access.

cannystanny is offline   Reply With Quote
Old 09-10-2019, 05:56 PM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,586
Thanks: 50
Thanked 1,050 Times in 1,031 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Supplier Database Assistance

Hi. Welcome to AWF! An Access database can easily handle something like that. What have you done so far? Have you started designing your tables? If so, please post your table structure, so we can give you our thoughts.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 09-10-2019, 06:26 PM   #3
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,369
Thanks: 21
Thanked 893 Times in 878 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: Supplier Database Assistance

Perhaps this will get you started...
https://www.access-diva.com/dm12.html

__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Training Database Assistance bdmang83 Theory and practice of database design 9 02-12-2014 01:31 PM
Question Access database assistance minsals General 3 08-24-2013 07:24 PM
Database Assistance Needed eolson30 Theory and practice of database design 28 06-12-2012 08:20 PM
New Parts and Supplier Database hullstorage Tables 9 02-18-2012 11:44 AM
Database Lilnking help and/or Formula Assistance musekul Crystal Reports 2 05-03-2007 10:19 AM




All times are GMT -8. The time now is 09:56 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World