Database Help

By vaccardi ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Suffice to say

by Slayer_ In reply to Database Help

Everything you have said is possible.

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

Collapse -

You can do all that

by Tony Hopkinson In reply to Database Help

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.

Related Discussions

Related Forums