Actually, I use Excel more frequently than using Access. Because my parents are the small business operator. We will have many orders from different corporations in each week. I think the access is extremely important for the whole sale distributors. First of all, like those Whole Sale Companies, they have to take care thousands of present customers, therefore, they need to know who they are doing business with .Second, the Whole Sale Company has to have a smart commercial system which is able to contain a very large amount of data, for instance, the customers’ business name, location, cellphone numbers and the categories that the typical customer interests. In general, it is a rational database processing system; therefore, the Access is the best choice for the Whole Sale Companies.
According to my own experience , when I was calling for orders , the sales representative would always ask my cellphone numbers first , because they could use my phone numbers to track my business profile and information in a second , using access improves the business efficiency in a new level .
Xingbei Jin
I would have to agree with Xingbei. Access is really useful for large databases, and not so much for small businesses. If your client list is less than 1,000 your honestly better off just using excel. However for mid-sized to large business, Access should be your main choice. It can handle and sort what Excel cannot.
That’s interesting to see Microsoft programs actually being used to help businesses because most of my experience with these programs is really basic and used mostly for school work.
I really like the comparison you made between Excel and Access, but most of all how you were able to highlight the use you give to Excel and the difference it makes to your parent’s business. You are right when you say that Access makes the work more efficient to storage huge data. I found very interesting the part that you just have to provide your suppliers with your phone number and they quickly get the rest of your information.
you can download the plug-in feature in excel that add functionality such as the ability to list top 10 percent of customers, based on sales.. I found it very cool