Member Avatar for Zahid_6

Hi there,

I am running a small business and want to build a database in Access. To keep record or my stock, invoice and payments (inward/outwards).

Can you guys help me with it.

I am not expert wih access but know a little of it.

  • 6 Contributors
  • 6 Replies
  • 208 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by zahidmehmood
Member Avatar for hericles

You'd be better off finding a free/cheap inventory management system or accounting package. Then all of the creation work has already been done for you by people in the business. Plus you'll gain access to all of the features, reporting and the like, that you're database won't have.

Member Avatar for JorgeM

I'd agree with hericles' suggestion and based on your description, it sounds like something like QuickBooks would solve your problem.

Even if you use Access, you are going to have to build forms and you dont have reporting built-in. you'd have to create the necessary SQL queries and if you want to display the results graphically using charts, you'd have to build that as well.

Member Avatar for rch1231

Another option is the free downloads available from Microsoft for Access. They are templates for databases and systems created by other users that you can download for free. You just need to make sure you get one compatible with the version of access you are running (i.e. 2003, 2007, 2010, etc.)

Here is a link to templates for Access 2007 databases and the one at the top is for Inventory Control:

http://office.microsoft.com/en-us/templates/desktop-inventory-TC010206882.aspx

Member Avatar for zahidmehmood

thanks a lot guys.... much appreciated for your helping words....

Member Avatar for Alicera Nz

I can build it for you, just send the concept and the format of the inventory

Member Avatar for zahidmehmood

thanks Alicera Nz,
We are distributor for a confectionary company, received goods from company, then our sales team market it, receive orders, create invoices and transport it to customers address. some of invoices are paid in cash and some are credited for agreed period mostly weekly basis.

I want to make a database to keep eye on inventory, paid invoices and our standing invoices, and some other features which mostly database have like account reports, product list, sales perfrmance, top 10 selling products etc....

if you can help me wit this, I will be grateful.

zahid

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.