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