There is no real template feature as such.
On the other hand, there is a defense between a car, and a Plane.
While you been using cars (Excel, and Word), ms-access is more of a plane.
Thus, you are kind of asking how can you put a steering wheel in a plane.
Or, the reverse being how come a car does not have wings?
But what I want to understand is how do I store tham in the folder in my
PC
as a template.
If you are able to use windows, then you can create a folder, and in side
that folder simply place your databases that you want to use. When you need
a new database, the you can simply go to that folder and copy it.
The other thing you have to remember is that ms-access is not a document
system at all. While word, and excel are applications that let you create
documents, ms-access is in fact a tool to CREATE software. ms-access is NOT
a document based system. Typically, in word, for each customer letter, you
would create a new document, and often that document will be based on a
template. In ms-access, you build, design, write code, and develop a
application. The idea that you "copy" the application over and over as a
template does not make sense. This would be akin to copying word (the
software) every time you needed to add a new customer. In other words, with
ms-access, you are not creating documents, but in fact are now a developer
of
software. Typically, for each new customer, you would add a new record, and
the "concept" or "idea" of template would be the form that you design. So,
you can most certainly think of a ms-access form as template that you fill
in, and each new record you add to that form could be considered a document,
but we are stretching things here.
Applying document concepts such as a document template to programming
systems like VB, vb.net, or ms-access simply does not fly. You need to
complete change your approach here, and realize that ms-access is a
development system, and not a document system like word, or excel.
If you don't change your conceptual approach here, you will have
great difficulty in understanding ms-access. It is a VERY
different tool then word, or Excel.
You can most certainly copy the structure of a EXISTING mdb application, and
leave the DATA behind. This is accomplished by using the import option, and
there is a check box to leave the data behind.
file->get external data->Import
You then can browse to the database of your choice, and import parts of that
application (forms, reports, tables...etc). And, there is the ability to
import the table structures..and NOT the data. So, you can (and will)
certainly raid other mdb files to grab code, forms, and tables. So, you can
certainly shuffle around parts, and pieces of applications. However, it
again
needs pointing out that we are talking about a application development
system..and not simply a bunch of documents like Excel, or word has.
