Create Desktop Database Based on Access Template

What are the benefits of creating a desktop database in Microsoft Access using a template?

Watch the video below:

How to use a Template to Create an Access Desktop Database
If we want to organize and manage our data with Access but do not want to spend time creating a database from scratch, we can use a desktop database template.

What is an Access template?
An Access template is a file. When we open it, it creates a complete database application. It contains all the tables, forms, reports, queries, macros, and relationships that we need to start working. The templates are designed to be complete end-to-end database solutions. We can save time and effort and can start using our database right away. After we create a database by using a template, we can customize the database to suit our needs.

How to select a template
Each template is designed to meet specific data management needs. We can either use one of the templates included with Access or find one online.
How to start with a template from our computer
On the Access startup screen, we can click ‘Suggested’ searches.
We can also search for templates based on category like businesses.
Click an icon to select a template and enter a File Name.
To change the default database file location (C:\Users\Your name\Documents), click the folder icon next to the File Name > Create.

How to start with an online template
If we are connected to the Internet, we can search for online templates:
On the Access startup screen, enter the type of template you want in the Search box.
Access shows you the available online templates.
Click the icon to select a template and add a File Name.
To change the default database file location (C:\Users\Your name\Documents), click the folder icon next to the File Name > Create.
Before you start using some templates
Depending on the template that we use, we might see the following messages as shown in the table below. This is the action we can take:

If we seeAction to be taken
SECURITY WARNING message in the message barIf we trust the source of the template, we click Enable Content
Login dialog with an empty list of usersClick New User and fill in the User Details form
How to deal with different messages of databases

Click Save & Close.
Select the username you just entered and click Login.

Getting Started page
Click links on that page to learn more about the database or click other buttons and tabs to explore the database.

Example:
How to use the Contacts Access Database template
This template is available in Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010 and Access 2007
We will use the Access Contacts Database template to keep track of names, addresses, telephone numbers, and other information.
Getting Started
Let’s cover the basic steps of using the Contacts Database template.
When we first open the database, Access displays the Welcome form. To prevent this form from displaying the next time we open the database, we clear the ‘Show Welcome’ check box.
We close the ‘Welcome’ form to begin using the database.
To make sure all the database content is enabled, click ‘Enable’ this content in the Message Bar.
Add contacts from Microsoft Outlook
If we use Microsoft Outlook, we can add contacts from that program without having to re-type the information.
On the Contact List form, click Add from Outlook.
In the Select Names to Add dialog box, we can select the names that we want to add to the database.
Click Add, and then click OK.
Search for a contact
The Quick Search box lets you quickly find a contact on the Contact List form.
On the Contact List form, in the Quick Search box, type the text you want to search for and then press ENTER.
Access filters the list to show only those records that contain the text we searched for. To return to the full list, click Clear the current search.
Show or hide columns
On the Contact List form, some fields (columns) are hidden by default. To change which fields are displayed:
Click Show/Hide Fields.
In the Unhide Columns dialog box, select the check box beside each column, for example ID, that we want to show. Clear the check box to hide the column.
Display contact details
The Contact Details form lets us see and enter more information about each contact. To display the Contact Details form:
On the Contact List form, click Open next to the contact that you want to see.
Add a picture
On the Contact Details form, we can add a picture for the contact.
In the Attachments dialog box, click Add.
In the Choose File dialog box, browse to the folder that contains the file.
Select the file we want to add, and then click Open.
In the Attachments dialog box, click OK.
Note: We can attach multiple files to each contact, including different file types such as documents or spreadsheets.
Display a map of a contact’s address
On the Contact Details form, if you have entered a street address for the contact, you can display a map of that location:
Click to Map.

Click 'Click on Map' on form
Click ‘Click to map ‘ on Form to view location of address in Bing Maps

Address diplayed in map
Address displayed in map

To display a report:
In the Navigation Pane, under Reports, double-click the report you want to display.
To display the macros (Autoexec) code right-click the macro item and view in design-mode .

Autoexec macro
Autoexec Macro

To see the module VBA code right-click on the module (modMapping) and view in design mode.

VBA code of module modMapping
VBA code of module modMapping

Further reading:

Create Desktop Database Based on Access Template

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.