Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Using a Custom Database Template

Instead of creating a database from scratch, you can also create a new database from an existing one you already have. If you have a database that is close to what you want to create, you can select it from the Start or New screen to create an untitled database with the contents of a database template. When you place a template in the default Access template folder, you can select the database template from the Personal tab (New!) in the Start or New screen to create a new database from an existing one.

Create a New Database from a Custom Database Template

  • yellow_1.jpg Start Access or click the File tab, and then click New.
  • yellow_2.jpg Click Personal (New!).

    • Default templates folder. C:\Users\user name\AppData\Roaming\Microsoft\Templates\Access.
  • yellow_3.jpg Click the custom template you want.
  • yellow_4.jpg Type in a name for the desktop database.
  • yellow_5.jpg Click the Browse button, click the Save in list arrow, select a save location, select an Access database format, and then click OK.
  • yellow_6.jpg Click Create.

    A new desktop database appears in the Access window.

View or Add Templates for Use in Access

  • yellow_1.jpg In the desktop, open the File or Windows Explorer.
  • yellow_2.jpg Navigate to the default Access templates folder

    • Default templates folder. C:\Users\user name\AppData\Roaming\Microsoft\Templates\Access.

    If the Access folder is not there, you can create one.

  • yellow_3.jpg To add a template to Access, copy and paste it in the default Access templates folder.

    • Office.com. You can download Access templates directly from Office.com using your web browser.
  • yellow_4.jpg To use the template in Access, click Personal in the Start or New screen.
  • yellow_5.jpg Click the custom template you want.
  • yellow_6.jpg Type in a name for the desktop database, specify a save location, and then click Create.

    A new desktop database appears in the Access window.

  • + Share This
  • 🔖 Save To Your Account