Thread: Normalization
View Single Post
  #4  
Old March 12th, 2010, 06:00 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Normalization

On Fri, 12 Mar 2010 09:24:10 GMT, "sys_analyst47 via AccessMonster.com"
u58607@uwe wrote:

Thanks for your quick revert, well may i send you a copy of my database. if i
will keep separate vehicle table, sales table, customer table & Loan amount
table. How a user in one go will input the information .... can you please
suggest me on that. Please provide me your email so that i will send you a
copy of my database have a look into this and suggest me. I would really
appreciate your help


You would use appropriate Forms with Subforms. There are some tutorials and a
good video for how to get started posted below.

I'm sorry, but designing your database for you goes beyond what I'm
comfortable doing as an unpaid volunteer on these newsgroups. I do provide
fee-based consulting services but my time is fully booked up at present. You
may want to see if you can find someone locally or use a jobs forum to request
someone's paid services.


Here are those resources:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials


--

John W. Vinson [MVP]