Grover Park George : The best in MS Access Database Development	Grover Park George On Access: The Best in MS Access Books
Home\| About Us\| Training Solutions\| Data Management Solutions\| Customer Service\| Resources & Partners\| Frequently Asked Questions\| Free Downloads\| Reader Comments\| The REAL Grover Park\| Access Test Bed\| Privacy\| Request Info\| Solutions\| Case Studies\| Secure Shopping\| Tip of the Day\| Earn Money!\| Chandler Photos\| Venezuela Photos\|

Access Tip of the Day from Grover Park Consulting: Training & Database Design -- Building Smart Tools for Smart Business©

MS Access Database Design Grover Park Consulting

Grover Park George's
MS Access^© Tip of the Day

Use Standard Naming Conventions

What does it look like?

Most Professional Developers follow standard naming conventions for the objects in their databases: Forms, Reports, Tables, Queries, etc.
Here is a brief overview.

Prefix all names with a three (or four letter) designation: "tbl" for tables, "frm" for forms, "rpt" for reports, "qry" for queries.

-tblCompany
-tblLocation
-tblAddress

-frmCompany
-frmLocation
-frmAddress

-rptSalesbyMonth
-rptSalesbySalesRep

-qrySalesbyMonth
-qrySalesbySalesRep

Object names should NEVER have spaces between words.

-rptSalesbyMonth not Sales by Month

Feedback is welcome and appreciated. ghepworth@gpcdata.com

Grover Park George : The best in MS Access Database Development	Grover Park George On Access: The Best in MS Access Books
Home\| About Us\| Training Solutions\| Data Management Solutions\| Customer Service\| Resources & Partners\| Frequently Asked Questions\| Free Downloads\| Reader Comments\| The REAL Grover Park\| Access Test Bed\| Privacy\| Request Info\| Solutions\| Case Studies\| Secure Shopping\| Tip of the Day\| Earn Money!\| Chandler Photos\| Venezuela Photos\|

Grover Park George : The best in MS Access Database Development

Grover Park George On Access: The Best in MS Access Books

Grover Park George's MS Access© Tip of the Day