access database courses - Template

The UK's most regular instructor-led training courses.
Training information: access database courses · Courses in microsoft access · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Template

Deborah has attended:
Excel Advanced course
Access Introduction course
Access Intermediate course

by - delegate Deborah [2 posts] (2007 Sep 19 Wed, 16:19) Reply

how to save a database as a template.

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Feb 5 Thu + 6 Fri	Southwark	4	book now	£475	£485
2003	2009 Mar 5 Thu + 6 Fri	Southwark	5	book now	£450	£485
2003	2009 Apr 8 Wed + 9 Thu	Southwark	7	book now	£345	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	7	book now	£345	£399
2003	2009 Jun 4 Thu + 5 Fri	Southwark	8	book now	£275	£399
2003	2009 Jul 9 Thu + 10 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 14 Access VBA course dates. Bookings currently available until 4th March 2010.

RE: template

by - trainer Richard platinum contributer [825 posts] (2007 Sep 21 Fri, 16:21) Reply

You are not able to do this as a standard option.

Simply create a database, and give it the name TEMPLATE.

Save it to the directory

C:\Program Files\Microsoft Office\Templates\1033

(this is different for different version of access).
To find where yours will be, do a file search for a name of any template you can see in Access

· The Benefits of Certified Microsoft Training in Access
· Want to Become the Office Hero? MS Project Training Could be the Answer
· Microsoft Access Courses
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips

Rate this page: