Forum home » Delegate support and help forum » Microsoft Access Training and help » Identifying and navigating field and tables
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Identifying and navigating field and tables
Resolved · Low Priority · Version 2003
Reply Fri 27 Aug 2010, 12:33Delegate Simon said...
Simon has attended:
Access Intermediate course
Identifying and navigating field and tables
I have inherited a number of databases that I often find difficult to navigate as fields and table names are rarely in plain English. I realise this will become easier the more familiar/experienced I become with the databases, but Antony (at the intermediate training session 20th Aug) had a suggestion how I could simplify things. I don't recall what his solution was. Any suggestions?
For upcoming training course dates see: Pricing & availability
RE: Identifying and navigating field and tables
Hi Simon,
Thank you for your question.
I imagine he meant the following naming convention that is widely used:
Tables: tbl10Customers
tbl20Orders
fields: fld10aCustomerName
fld10bCustomerAddress
fld20aOrderID
fld20bOrderDate
Each field relates to the table number and add a unique letter to represent each field.
Forms: frm10Customers
Reports: rpt10Customers
I hope this helps.
Regards
Simon
Tue 7 Sep 2010: Automatically marked as resolved.
|