Creating an Access 2013 Database from Scratch

of 05

Getting Started

Many people choose to create their first database using one of the many free Access 2013 database templates. Unfortunately, this isn't always an option, as you sometimes need to create a database with business requirements that aren't met by one of the available templates. In this article, we walk you through the process of designing your own Access database without the use of a template.

To begin, open Microsoft Access. The instructions and images in this article are for Microsoft Access 2013. If you're using an earlier version of Access, see Creating an Access 2007 Database from Scratch or Creating an Access 2010 Database from Scratch.

of 05

Create a Blank Access Database

Once you've opened Access 2013, you will see the Getting Started screen shown above. This presents the ability to search through the many templates available for Microsoft Access databases, as well as browse the databases that you've recently opened. We won't be using a template in this example, however, so you should scroll through the list and locate the "Blank desktop database" entry. Single-click on this entry once you locate it.
of 05

Name Your Access 2013 Database

Once you click on "Blank desktop database", you'll see the pop-up shown in the illustration above. This window prompts you to provide a name for your new database. It's best to choose a descriptive name (such as "Employee Records" or "Sales History") that allows you to easily identify the purpose of the database when you later browse the list. If you don't want to save the database in the default folder (shown below the textbox), you may change it by clicking on the folder icon. Once you've specified the database file's name and location, click the Create button to create your database.
of 05

Add Tables To Your Access Database

Access will now present you with a spreadsheet-style interface, shown in the image above, that helps you create your database tables.

The first spreadsheet will help you create your first table. As you can see in the image above, Access begins by creating an AutoNumber field named ID that you can use as your primary key. To create additional fields, simply double-click on the top cell in a column (the row with a grey shading) and select the data type you would like to use. You may then type the name of the field into that cell. You can then use the controls in the Ribbon to customize the field.

Continue adding fields in this same manner until you've created your entire table. Once you've finished building the table, click the Save icon on the Quick Access toolbar. Access will then ask you to provide a name for your table. You can also create additional tables by selecting the Table icon in the Create tab of the Access Ribbon.

If you need help grouping your information into appropriate tables, you may wish to read our article What is a Database? that explains the structure of database tables. If you're having difficulty navigating in Access 2013 or using the Access Ribbon or Quick Access toolbar, read our article Access 2013 User Interface Tour.

of 05

Continue Building Your Access Database

Once you've created all of your tables, you'll want to continue working on your Access database by adding relationships, forms, reports and other features. Visit our Microsoft Access Tutorials section to get help with these Access features.

mla apa chicago
Your Citation
Chapple, Mike. "Creating an Access 2013 Database from Scratch." ThoughtCo, Mar. 4, 2017, Chapple, Mike. (2017, March 4). Creating an Access 2013 Database from Scratch. Retrieved from Chapple, Mike. "Creating an Access 2013 Database from Scratch." ThoughtCo. (accessed May 21, 2018).