Need to create a manufacturing data base in access anyone have samples or a link just to get familiar with it?

Question

Need to build a data base within production process which has 17 seperate processes start to finish

Answer 1

Klausy makes some valid points, but I'm assuming you want to use Access because that is what you have available without buying new software or systems.

MS includes a sample database with Access. do a search on your computer for "Northwind.mdb". It's a full working database with forms, reports, queries, etc that should give you some familiarity.

Hope that helps

Answer 2

Seriously - forget coding this in Access.

A production DB with 17 seperate processes. You should consider using a real database like SQLServer. There are free editions for personal use etc. The benefit of being able to run transactions, encapsulate logic in stored procedures and straight out performance should be value enough. Also you are more likely to find examples on open source code libraries using SQLServer or MySQL than in Access.

http://msdn.microsoft.com/vstudio/express/sql/default.aspx

Not to mention you could then code the UI in .NET (Free versions also available), and make use of proper logic and flow control features, workflow, messaging etc.

http://msdn.microsoft.com/vstudio/express/default.aspx