Go Back   Computer Forums > General Computing > Programming
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 09-11-2013, 08:49 AM   #1
Daemon Poster
 
YoungIT's Avatar
 
Join Date: Apr 2013
Location: USA
Posts: 669
Default Program for entering Info into Access

Hey guys, I have a cousin that owns a Meat Market in the town I live in, and he asked me to make a complete Database, Server, and a chain of Computers for his meat market. Now, how do I make a program that he can use on the front counter to enter customer information that would send it straight into the Microsoft Access Database?
__________________

__________________
"Difficulties mastered are opportunities won" -Sir Winston S. Churchill
YoungIT is offline   Reply With Quote
Old 09-11-2013, 09:59 AM   #2
Site Team
 
berry120's Avatar
 
Join Date: Jul 2009
Location: England, UK
Posts: 3,434
Default Re: Program for entering Info into Access

Wouldn't an access form just be the easiest thing for this (presuming the database is already in access?)
__________________

__________________
Save the whales, feed the hungry, free the mallocs.
berry120 is offline   Reply With Quote
Old 09-11-2013, 02:39 PM   #3
Daemon Poster
 
YoungIT's Avatar
 
Join Date: Apr 2013
Location: USA
Posts: 669
Default

Quote:
Originally Posted by berry120 View Post
Wouldn't an access form just be the easiest thing for this (presuming the database is already in access?)
No, he wants an external program to enter it in, and have a database in the network that this program enters the information into, an holds inventory, animals that have been slaughtered an their information..... Just a bunch of jargon
__________________
"Difficulties mastered are opportunities won" -Sir Winston S. Churchill
YoungIT is offline   Reply With Quote
Old 09-11-2013, 08:11 PM   #4
Fully Optimized
 
strollin's Avatar
 
Join Date: Mar 2011
Location: USA
Posts: 2,617
Default Re: Program for entering Info into Access

I have to agree with berry120, you should be able to accomplish what he wants using Access forms which will allow him to enter the data while the Access DB will hold the data. You can then design reports for him to check his inventory and such.

No external program should be needed, Access was designed to do exactly what you're talking about.
__________________
strollin is offline   Reply With Quote
Old 09-12-2013, 05:54 AM   #5
Fully Optimized
 
ssc456's Avatar
 
Join Date: Jan 2007
Posts: 4,279
Send a message via MSN to ssc456
Default Re: Program for entering Info into Access

Agree with the other guys you should be able to do this with an Access Form . . .HOWEVER

If you are insistent it has to be an external application the easiest route may be a .net WinForms application, or perhaps a web application in .net or PHP.

It depends on what you are looking for?
__________________
He who has never failed has never attempted anything worth succeeding at.

Dont Eat Animals, Its Not Good For Them And They Dont Like It!
ssc456 is offline   Reply With Quote
Old 09-12-2013, 06:02 AM   #6
Site Team
 
berry120's Avatar
 
Join Date: Jul 2009
Location: England, UK
Posts: 3,434
Default Re: Program for entering Info into Access

Quote:
No, he wants an external program to enter it in, and have a database in the network that this program enters the information into, an holds inventory, animals that have been slaughtered an their information..... Just a bunch of jargon
The problem is, while what you describe is of course possible, it's a relatively big task and you're asking from the perspective of someone who doesn't really do much, if any programming since your question is quite broad (and also, you jumped to using Access which, putting it very kindly, isn't the database of choice for anyone really if they're not using the forms / graphical side of it!)

The route of choice if you're using access would be a web application in ASP.Net most likely, since that will, I assume, have the best interoperability with access. Beyond that I'm afraid you'll have to just bite the bullet, sit down and do some hard research on this stuff to then decide whether it's worth doing - "how do I build it" is a question that people have written large books on!
__________________
Save the whales, feed the hungry, free the mallocs.
berry120 is offline   Reply With Quote
Old 09-12-2013, 10:18 AM   #7
..m.0,0.m..
Site Team
 
iPwn's Avatar
 
Join Date: May 2010
Location: USA
Posts: 3,926
Default Re: Program for entering Info into Access

I'm actually deploying my project today that manipulates SQL databases and does some other cool stuff. As an example of what berry120 is trying to say; I have 15 years experience in IT and this 'simple' project took almost 3 months of solid 8-5 M-F work. It's a big task bud.

You can certainly get dirty with it and try it out, but without immediate resources, I think you'll throw your hands up before long.

Perhaps check into SaaS (Software as a Service) options? I am confident that you/he can find the appropriate vendor to easily change an existing product to accomplish this. It may get pricey, but that's relative to how bad/soon he wants this.
__________________
Me: You'd think as the dominant species we wouldn't be so effing stupid.
J: We're just intelligent enough to be completely effing stupid.
iPwn is offline   Reply With Quote
Old 09-12-2013, 10:35 AM   #8
Fully Optimized
 
ssc456's Avatar
 
Join Date: Jan 2007
Posts: 4,279
Send a message via MSN to ssc456
Default Re: Program for entering Info into Access

On that note, I don't know if this is frowned upon on this forum or not? But . . . .

I'm happy to design some software for you from scratch to your specification that will meet all of your needs, writing information to a database, reading and reporting from it for a small fee. Depending on the exact requirements probably in the region of $100 - $400.

Of course there are two things I will say to almost defend myself against that.

1) The reason that price is as it is (which is extremely under market value) is because i'd like to use the project in a portfolio of mine and gain some project / contract experience.

2) This is of course a completely free forum and if you decide to tackle this yourself (which I would encourage) then I and the other members here will always be happy to offer advice, tips and solutions to problems.

Finally the other members are right, if this were a project for a relatively large business that had to work for a couple of dozen users then this may take a lot longer, require project management, several specifications, QA testing etc etc but in my personal experience a product for 1 - 5 users which the "owner" is very clear about the specification this can be achieved in a much shorter timescale probably 1 - 5 weeks, again depending on exact spec.

P.S i'm currently working as a C# and MS SQL Developer for a Software House based in the UK.
__________________
He who has never failed has never attempted anything worth succeeding at.

Dont Eat Animals, Its Not Good For Them And They Dont Like It!
ssc456 is offline   Reply With Quote
Old 09-12-2013, 08:43 PM   #9
Daemon Poster
 
YoungIT's Avatar
 
Join Date: Apr 2013
Location: USA
Posts: 669
Default

Quote:
Originally Posted by ssc456 View Post
On that note, I don't know if this is frowned upon on this forum or not? But . . . .

I'm happy to design some software for you from scratch to your specification that will meet all of your needs, writing information to a database, reading and reporting from it for a small fee. Depending on the exact requirements probably in the region of $100 - $400.

Of course there are two things I will say to almost defend myself against that.

1) The reason that price is as it is (which is extremely under market value) is because i'd like to use the project in a portfolio of mine and gain some project / contract experience.

2) This is of course a completely free forum and if you decide to tackle this yourself (which I would encourage) then I and the other members here will always be happy to offer advice, tips and solutions to problems.

Finally the other members are right, if this were a project for a relatively large business that had to work for a couple of dozen users then this may take a lot longer, require project management, several specifications, QA testing etc etc but in my personal experience a product for 1 - 5 users which the "owner" is very clear about the specification this can be achieved in a much shorter timescale probably 1 - 5 weeks, again depending on exact spec.

P.S i'm currently working as a C# and MS SQL Developer for a Software House based in the UK.
Haha, good luck sticking the pry bar in my wallet! I've been saving all summer for a rifle and I ain't starting again! I just wanted to know if I should do it in VB or something, because he says he wants this application to be touch screen only because you obviously do not want a keyboard on a meat counter lol
__________________
"Difficulties mastered are opportunities won" -Sir Winston S. Churchill
YoungIT is offline   Reply With Quote
Old 09-12-2013, 09:29 PM   #10
Fully Optimized
 
strollin's Avatar
 
Join Date: Mar 2011
Location: USA
Posts: 2,617
Default Re: Program for entering Info into Access

Again, Access has a forms designer built-in that will allow you to create forms with large buttons that will work well with a touch screen. Access also uses VBA as it's macro language so I don't understand your reluctance to use it.
__________________
strollin is offline   Reply With Quote
Old 09-12-2013, 09:55 PM   #11
Fully Optimized
 
OhSnapWord's Avatar
 
Join Date: Jan 2012
Location: USA
Posts: 1,853
Default Re: Program for entering Info into Access

If he wants to keep is separate, you could make an Access program that is just a form that links to the database on the network via linked tables.
__________________
FX-8350 @ 4.7 cooled by H80, 32GB Mushkin Enhanced Blackline 2133, Asus Sabertooth 990FX, 2x Radeon HD 7850 2GB in X-fire, 500GB Samsung 850 Evo, 4TB Seagate, 3TB WD Black, 2x 1TB WD RED in RAID 0
OhSnapWord is offline   Reply With Quote
Old 09-13-2013, 02:40 AM   #12
Fully Optimized
 
ssc456's Avatar
 
Join Date: Jan 2007
Posts: 4,279
Send a message via MSN to ssc456
Default Re: Program for entering Info into Access

Quote:
Originally Posted by YoungIT View Post
Haha, good luck sticking the pry bar in my wallet! I've been saving all summer for a rifle and I ain't starting again! I just wanted to know if I should do it in VB or something, because he says he wants this application to be touch screen only because you obviously do not want a keyboard on a meat counter lol
Can't blame a guy for trying

You could also consider Excel to design it in?

Excel has forms and VBA which can be rather powerful, and it makes reporting and such like very easy because well it's Excel . . . .
__________________
He who has never failed has never attempted anything worth succeeding at.

Dont Eat Animals, Its Not Good For Them And They Dont Like It!
ssc456 is offline   Reply With Quote
Old 09-13-2013, 05:34 AM   #13
Site Team
 
berry120's Avatar
 
Join Date: Jul 2009
Location: England, UK
Posts: 3,434
Default Re: Program for entering Info into Access

Quote:
Haha, good luck sticking the pry bar in my wallet! I've been saving all summer for a rifle and I ain't starting again! I just wanted to know if I should do it in VB or something, because he says he wants this application to be touch screen only because you obviously do not want a keyboard on a meat counter lol
If you *should*? Well, you *could*... just as you could do it in near enough any language out there. As to whether VB has some special ability to create forms with large buttons, well, no. It's no different from anything else in this respect (I could knock you up a form with large buttons in *any* graphical framework I've touched.)

I've yet to hear a compelling reason why you don't want to use an access form - you can still use them remotely and the buttons can be as big as you want. You seem to be hell bent on creating a heck of a lot of work for yourself for no reason!
__________________
Save the whales, feed the hungry, free the mallocs.
berry120 is offline   Reply With Quote
Old 09-13-2013, 08:29 AM   #14
Daemon Poster
 
YoungIT's Avatar
 
Join Date: Apr 2013
Location: USA
Posts: 669
Default Re: Program for entering Info into Access

Should I use FreeNAS to host the database? I don't plan to have the database on the computers in the meat processing room and the front counter. What should I do about that?

---------- Post added at 09:29 AM ---------- Previous post was at 09:29 AM ----------

Quote:
Originally Posted by OhSnapWord View Post
If he wants to keep is separate, you could make an Access program that is just a form that links to the database on the network via linked tables.
Thank you! Again this not me, this is my Cuz who wants it seperate! Don't ask me :/
__________________
"Difficulties mastered are opportunities won" -Sir Winston S. Churchill
YoungIT is offline   Reply With Quote
Old 09-15-2013, 02:07 PM   #15
..m.0,0.m..
Site Team
 
iPwn's Avatar
 
Join Date: May 2010
Location: USA
Posts: 3,926
Default Re: Program for entering Info into Access

Quote:
Originally Posted by ssc456 View Post
On that note, I don't know if this is frowned upon on this forum or not? But . . . .
There's a difference between spam and offering a service
__________________

__________________
Me: You'd think as the dominant species we wouldn't be so effing stupid.
J: We're just intelligent enough to be completely effing stupid.
iPwn is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 05:45 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0
×