Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Q & A - Forums _ Newcomer's Reading List

Posted by: CyberCow Jan 20 2013, 11:44 AM

A good data model is the first step to realizing any database and has several free models on which to base a business concept for getting some ideas to match what may closely complement your business model.
The concepts of database building are best conceived when thoroughly planned . . .

And the following links on normalization cannot be stressed enough . . .
Tutorials, KB Articles and Demos that can assist a new Access developer are found here: (NOTE: the links followed by a green asterisk - * - are connected to - a very dynamic site that seems to be under constant growth and the links here may break from time-to-time. We do our best to stay on top of them, but please don't hesitate to !Report a broken link. Thanks!)
Finally, these links on other design considerations are also very helpful:
Access Web Apps are in a bit of a different realm. Here's some resources to get you started and keep you going:

And always avoid using ANY special characters (even spaces) in your object, control and field names.
Always avoid the characters: ! @ # $ % ^ & * ( ) ? > < + = ' "; : - ~ `\ | [ ] { } in naming conventions.
The underscore _ is usually OK, but can get interesting in certain code circumstances.
See and/or will help with mark-up tags. is the general Help link. - are the guidelines by which we do our best to manage & navigate this community. - is an article on how best to post questions.
Finally, a note on UtterAccess Member Ranking:
New Member0
UtterAccess Enthusiast50
UtterAccess Addict100
UtterAccess Veteran300
UtterAccess Guru500
UtterAccess Ruler1,000
UtterAccess Certified!5,000
UtterAccess Leader20,000