Create database from Template

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

I am going to create a database and find that one of the
existing template provided by Microsoft is quite useful.

However, I would like to change the name of some fiels,
like Category to Type. Is there any easy way to change
the name in Form / Table / Label ?

Besides, for those fields I don't use, is it necessary for
me to delete it OR just leave them there ?

In addition to MS, is there any web site can I find MS
Access template that is free of charge ?

Thanks
 
If you are sure that some columns are not needed, then better to drop
them

Madhivanan
 
I am going to create a database and find that one of the
existing template provided by Microsoft is quite useful.

However, I would like to change the name of some fiels,
like Category to Type. Is there any easy way to change
the name in Form / Table / Label ?

Besides, for those fields I don't use, is it necessary for
me to delete it OR just leave them there ?

In addition to MS, is there any web site can I find MS
Access template that is free of charge ?

Thanks
Click to expand...

There is no problem changing the name of a field, as long as you find
and change all references to it elsewhere in the database. In other
words if you change a table field name, you must find all the forms,
queries, reports, coding, etc. which refer to that field and change
that name also.
The same applies to deleting a field. Find and delete all references
to that field also.

NOTE... regarding your wanting to change the name of the Category
field to TYPE.
Type is a reserved Access/VBA/Jet word and should not be used as a
field name.
See the Microsoft KnowledgeBase article for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'
 
Back
Top