Basic Resources?

  • Thread starter Thread starter Lee Brown
  • Start date Start date
L

Lee Brown

I am new to Access and lack a proper understanding of some of the basics of Database design, for example how to keep records with no changes allowed and updating with new records in a different format. I expect even with my description you can see the trouble I am in.
Can anyone tell me some resources where I may learn the design principles.
I have several large books with all sorts of information on using Access but not the principles.

Books and or web sites would be very useful

Rgds

Lee
 
You'll get some useful book lists but to answer one of your questions
generally, the way to stop people changing records is to use forms. With the
form's Properties (which you see by going into the form's Design view and
pressing the Properites button) there are many options which will let you
control exactly what users can and can't change about a record.

You can hide your actual tables and let the Switchboard addin help you to
make a form with buttons on it that lets your user open only those things
you want him to open.

Use forms to input and view data, use tables only to store data, use queries
to sort, filter and calculate data (plus a few other tricks) and reports to
view and print out data.

If you are very new to Access there are a few free courses online which will
just get you started.
http://tutorials.freeskills.com/index/category/104

Evi


I am new to Access and lack a proper understanding of some of the basics of
Database design, for example how to keep records with no changes allowed and
updating with new records in a different format. I expect even with my
description you can see the trouble I am in.
Can anyone tell me some resources where I may learn the design principles.
I have several large books with all sorts of information on using Access but
not the principles.

Books and or web sites would be very useful

Rgds

Lee
 
Back
Top