Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Q & A - UtterAccess.com 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 http://www.databaseanswers.org/data_models/index.htm 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 functionx.com - 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 http://www.UtterAccess.com/wiki/index.php/Naming_Conventions and/or http://www.UtterAccess.com/wiki/index.php/CamelCase.
http://www.UtterAccess.com/forum/index.php?s=&act=legends&CODE=bbcode will help with mark-up tags.
http://www.UtterAccess.com/forum/Helpp.html is the general Help link.
http://www.UtterAccess.com/forum/boardrules.html - are the guidelines by which we do our best to manage & navigate this community.
http://www.UtterAccess.com/forum/askgoodquestion.html - is an article on how best to post questions.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Finally, a note on UtterAccess Member Ranking:
TitlePosts
New Member0
Member20
UtterAccess Enthusiast50
UtterAccess Addict100
UtterAccess Veteran300
UtterAccess Guru500
UtterAccess Ruler1,000
UtterAccess Certified!5,000
UtterAccess Leader20,000