[AccessD] OT Quick Question

Jürgen Welz jwelz at hotmail.com
Sun Feb 22 10:50:03 CST 2004


>From: "Martin Reid" <mwp.reid at qub.ac.uk>

>You just starting out with Access, bit of experience but want to know more.
>No programming just basic skills.
>
>What would be the top 5
>
>
>Martin

Most problems I see with amateur databases arise from 6 general areas:

- Table structure/relationships/3NF basics (and use a numeric unique key)
- Queries, understanding the different joins, union, append, update, make 
table (you need to know most of this before you can do your database table 
structural design)
- Indexes, cost/benefit and performance (that numeric key again)
- Understand the datatypes and sizes, table record field limitations and 
type delimiter issues (delimiters for beginning coders-especially 
datetime-input mast and formatted display v storage)
- The hows and whys of cascade updates/deletes
- Understanding concurrency:  Bound v Unbound, connected v disconnected



Ciao
Jürgen Welz
Edmonton, Alberta
jwelz at hotmail.com

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus&pgmarket=en-ca&RU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca




More information about the AccessD mailing list