Establish warehouse management system, how to use the Access to realize the query, the summary

CodePudding user response:

First of all, you should first clear demand, like so (for example) :
1. Man: warehouse who operate the system? What are the docking with warehouse department? What information need to report to the warehouse?
2. Material: material classification? In and out of time? Multistage library?
3. Internal: leadership requirements? Its bottleneck?
4. External: the customer information? Supplier information?
And then start to build table, e-r diagram;
After considering the interface express (forms, queries);
According to the form you want, then add button and control, the program or macro binding to the buttons/controls;
Debugging,,,
Through the main function can be used after, at that time according to need to do again log in access control, etc.;
And then according to the need to do assembly and Taiwan before and after separation,
Daemon (or Access the background SQL backend) upload server
Or the front desk program (. MDB file. Accdb) release to the user
Training training ~ ~
Finally, the finished version 1.0 development!
Behind according to demand correction had little correction of 1.1 1.2, and so on and so on,
Take big directly on 2.0.,,,,,,,
End

CodePudding user response:

Build table, you will first need to report contains information and style of painting, then separate the format and information,
To be classified information, after the summary outline information categories, such as: employees, customers, suppliers, materials, semi-finished products,,,,,
That this is what you need to build several categories corresponding Table (Table), and the below information, such as: employee's name, customer name, telephone, address, name of material and so on,,,,
As the fields in the table,
Format is you build Report (Report) on the basis of late,

CodePudding user response:

Refer to ACCESS library build warehouse management system, support local area network users

CodePudding user response:

General access enters sells saves the books mentioned, warehouse management implementation, how also get twenty or thirty pages

CodePudding user response:

First you have to set up a table;
Second, put in storage table, outbound table,
Moreover, there is a inventory list,
Each outbound inbound modified corresponding inventory,
This is generally a business process

CodePudding user response:

Provide the interface entry goods such as basic data,
Provide input interface of GRN and outbound order
Provide related query interface, such as inventory query, query summary for ins and outs of
Other functions can be gradually expand, the core of the entire first
Such as the simple and easy to use inventory management software
Unzip the downloadable reference

CodePudding user response:

http://download.csdn.net/download/top_sc/9799204

CodePudding user response:

Refer to this: http://blog.csdn.net/top_sc/article/details/52823758

CodePudding user response:

Do you have any can free editable version