Software

Ask something
Question Locked

Database Help

0 helpful
3 replies

by vaccardi

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to create a database that keeps track of various invoices, cash receipts, customers, and projects. I've taken a couple of classes on DB design and I'm trying to make one myself. I have completed a normalized database but I don't know the best way to go about making it user friendly. I was considering creating a GUI using VB .NET because I have a little experience with it. However, I was hoping to be able to use the forms in Access but I haven't had any exposure to this area. Is there a way to search for and update particular records using forms or can you just add new records?

3 replies

by slayer_

Everything you have said is possible.

Do you have a specific question? At the moment you have not mentioned which database provider your using

by tony hopkinson

You can do it even using a DBMS, (like an access front end to say SQL Server.

Bear this in mind though Access is a desktop, it does not scale, it's fragile, high volumes of data or transactions will kill it, and the further away you go from basic and simple, the more and more hoops you have to jump through.

That said there's nothing wrong with prototyping with it and then using it as a spec for writing something with .Net.

Might be wise to buy an Access book, and maybe a VBA with access book. It will run you all the standatrd stuff like master detail, look ups and such.

This discussion is closed to new replies.