Tuesday, February 24, 2015

How Steps to Program with Visual Basic Business Database ...?


The write idea arose when I was in the shower ha..ha

Here I am not going to explain how theories Design Analysis done by the system analyst. But just make existing programs in the head then implemented. So was the program ....
Remember the first time learn to program dah many books and learned codes.

But unfortunately still confused as well how the hell do I create a database program such as program sales business?

Huf ... ya confused because they do not have the experience of making the program would start where also do not know. Well time around the year 2002, I am still as IT Network Administrator at once Helpdesk at a company.

The company put on a program created by the central office. Incidentally time implementation of two programmers cabaang down to where I work as an IT Network Administrators and Helpdesk her.
Because it being a hobby and learn program kepinginnya I do not hesitate to ask directly to its programmers. Mas Incidentally this is his senior programmer. I asked to him.
Sir,  what is the first  to do to make the databases software?
Incidentally Mas want to answer my question:
1. First Hold the reports of what I will be made
2. Create tables and queries according to a report to be generated in the database
3. Create the form data processing (add, edit, delete, insert, search, etc.).
4. Follow the rules of the Standard Operating Procedure (SOP) program.

Well the answer is very simple Mas and frankly I was still confused mo create reports how, create tables and queries it how?
Over time I became trying to get out of the company and apply to the software manufacturer (software house) in the hope it could be a programmer (he he .. fight).

OK. After some time working in Corporate Software Developer, in a manufacturing company and making a freelance program, it turns out this is done the same as above.

Back to the last step ya:
1. Hold the first reports of what I will be made
You can create a report with Crystal Report, datareport or active report.
To make existing sources report that makes the data source of the table there is also what makes the data from the query or View

 2. Create tables and queries according to a report to be generated in the database
If memakasi databae access you can create a table and its query ms-access program. If you use a SQL Server table or query can be made with the enterprise manager or SQL Query analyzer

3. Create the form data processing (input, edit, delete, insert, search, etc.).
You can create a form of data processing can be with SQL Server database or
form data processing with MS-Access or other database.


4. Follow the rules of the Standard Operating Procedure (SOP) program.
A simple example of this SOP is for example the sales program, the rules are there 10% discount for buyers who already have a membership card (member). Staying use Logic (branching)
ok