Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Naming convention

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Naming convention

Resolved · Low Priority · Version 2003

Reply Mon 13 Jun 2011, 10:55Delegate Joe said...

Joe has attended:
Access Advanced course

Naming convention

Tips on naming convention

For upcoming training course dates see: Pricing & availability

Reply Thu 16 Jun 2011, 09:09Trainer Simon said...

RE: Naming convention

Hi Joe,

Thank you for your question and welcome to the forum.

Here are some naming conventions for access:

1. Field Names with no spaces and initial caps.

2. When naming tables use tbl as a prefix and then a number followed by the table name.

e.g. tbl10Customers

3. Then each field in the customers table will have a prefix of fld followed by the table number and letter and then the name of the field.

e.g. fld10aCustomerID
fld10bCustomerName

4. Use prefixes such as frm for forms, qry for queries and rpt for reports.

I hope this helps.

Regards

Simon

Access articles

· How To Use Concatenation In Access To Create A Custom Lookup
· How To Make Access 2010 Databases Compatible With Access 2007
· Some Simple Database Questions Answered
· How To Use Calculation Fields In Microsoft Access
· Working With Multiple Workbooks In Excel

Please browse our web site to find out more about
access training london in and other Microsoft training courses.

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips