Access Templates


What is a template? A template is a preformatted design and build of a database. Templates are found in the File and New area of the Access backstage view. There are many pre-loaded Access templates which are always good to look at to get ideas or use if you have understanding of how Access works.

Saving a template

You can create your own template. The process is to either create a database structure from scratch or import a database structure which has already been created. Once it is ready, save the database as a template. This is just a file save as and then selecting the database option.

Using a Template

To use a template, select File then the new option. Navigate to your template, which should appear in the personal area. When you click on it, it will ask you if you want to name it. It is important to name the database at this stage, otherwise it will be called database 1 or something similar. Once the database is open it is a copy of the template and not the original.

Training Courses

Access training courses can be found here.

Check out other videos on our YouTube channel here

Online courses for Microsoft Access can be found here

Leave a Reply

You must be logged in to post a comment.


“Steve’s background in IT training clearly provided him with great organisational and managerial skills which he put to good use at Second Chance Enterprises. His ability to see the long term strategy as well as manage the day to day management is one of his biggest strengths.”

Chriss Graham
Project Coordinator at Daisy Group

“The course was really thorough and Steve was very knowledgeable and explained things very well. I’ve not used Microsoft Project before but now I feel very confident that I’ll be able to use it for what I need to do in my job”.

Craig Forster
Estimator, John F Hunt Regeneration Ltd

“I studied with Steve when we completed our CiPD CTP together. During the course I found Steve to be very personable and also very professional.  Steve was first on my list of suppliers. Steve was very competitively priced and very accommodating.”

Simon Snowdon
European Training Manager at HP Enterprise Services

“Steve delivered a number of Microsoft Office Training Sessions to a range of employees across Newcastle College. The service provided by Steve is second to none. I have no hesitations in recommending him to other employers.”

Christine Jackman
Learning Manager(North) - Winner of Training Programme of the Year NECCA