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?
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
