98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Identifying and navigating field and tables | Access forum
Identifying and navigating field and tables | Access forum
Resolved · Low Priority · Version 2003
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?
Tue 31 Aug 2010, 16:17Trainer Simon said...
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.
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. |
Access tip:Change caseTo change case from upper or lower case, highlight the text area, hold down the Shift key and pres F3 |
