How To Create An Online Database Using Access

Download Article

This wikiHow teaches you how to create your first database in Microsoft Access. If you want to start from scratch, you can create a blank database and design it yourself. If you're not as familiar with creating and working with databases, you can use one of Access's database templates to get started.

1

Open Microsoft Access on your computer. You'll find it in the Windows Start menu or your Mac's Applications folder.
2

Select Blank database . It's the first option in the "New" section. The other options are templates that are set up for specific purposes, such as contact management.
3
Enter a filename into the box. The default file name begins with the word "Database" and ends with ".accdb." You'll want to keep the ".accdb" part, but you can replace the rest of the file name with whatever you'd like.
- For example, if you're creating a database that contains an employee list, you could call it Employees.accdb.
- If you want to save the database in a specific folder, click Browse and select that folder.
4
Click Create . This creates your new blank database, as well as a new empty table called Table 1.
- All tables in your database will appear in the left panel. As you add more tables, you can click the table names to switch to that table's view.
5
Add tables to the database. Tables are places that store data in your database. You can enter your data directly into a table and Access will automatically create field names and types based on what you enter, or you can specify a field type before typing into the field.^[1] If you're familiar with Excel, think of tables like individual worksheets in a workbook. Data in a table is organized in rows and columns. You can even import data from an Excel spreadsheet into a table. To add a table:
- Click the Create tab.
- Click Table in the "Tables" group. You'll see that there's now a table called "Table 2" in your database.
- To rename a table, right-click its name in the left column and select Rename.
- If you want to delete a table, right-click its name and select Delete.
6
Enter data into your table. The first empty cell under "Click to Add" is where your cursor appears automatically.
- To start entering data and let Excel choose the field type, just start typing into the first cell under "Click to Add." Press the Enter key to move to the next field.
- To select a field type, click the Fields tab if it's not already selected, and then click one of the field types on the "Fields" panel in the toolbar. If you don't see what you need, click More Fields to display additional options. You can also click Click to Add to open the quick menu, which contains common field types.
- You can drag fields around to move them. You can also drag columns to other positions.
- To rename a column, double-click its heading, enter a new name, and then press Enter.
7

1

Open Microsoft Access on your computer. You'll find it in the Windows Start menu or your Mac's Applications folder.
2
Browse the available templates. Several templates will appear on the initial screen. You can also check out other templates online by clicking More options or Suggested searches: Access databases, depending on your version.^[2]
- When searching for online templates, you can select a category or enter a keyword into the search bar. Some examples are inventory, nutrition', and personal.
3

Click a template to see a preview. Each template has a screenshot you can use to help inform your choice. If you don't like the way the template looks, click the X at the top-right corner to return to the template list. Continue clicking through templates until you find the one you want to use.
4
Enter a filename into the box. The default file name begins with the word "Database" and ends with ".accdb." You'll want to keep the ".accdb" part, but you can replace the rest of the file name with whatever you'd like.
- For example, if you're creating a database that contains an employee list, you could call it inventory.accdb.
- If you want to save the database in a specific folder, click the Browse button and select that folder.
5
Click Create . This creates a new database based on the selected template.
- The navigation panel on the left side of the database contains all tables, queries, forms, and/or macros. You can use this panel to switch between different elements of the database.
- Depending on the template, you may automatically be brought to a form that allows you to enter data into the database. Other templates may not have data entry forms, instead requiring you to enter data directly into the table.
6

Click Enable Content if prompted. Depending on the template, you may see a security warning in the message bar. As long as you trust the source of the template (it's fine if you download it from Access, but not recommended if you download from third party websites), click Enable Content to start editing.
7

Create a login if prompted. If you see a login dialog with an empty user list, you'll need to create a user for the database. Click New User, fill out the form, click Save & Close, and then click Login to sign in with your new user account.
8
Delete sample data. Depending on the template, some data may already be filled in. When you're ready to input your own data, you'll want to remove the sample data. Here's how:
- Click the shaded box to the left of the record you want to delete.
- Click the Home tab if you aren't already there.
- Click Delete in the "Records" panel on the toolbar.
9

Save your new database. Once you start entering data, you'll want to make sure you don't lose your changes. Click the File menu and select Save to save your progress.

Add New Question

Question

How can I create a database for parts inventory? These parts have older p/n and replacement p/n and alternate p/n's also.

Create three columns and link all three together as shown in the article. (One employee can have many items and the item can belong to only one employee).
Question

How do I make a field name capitalized in MS Access?

Open the desired table. Click on Design View. Type the field names in all caps at this point.
Question

I want to make a database and sell it to offices, banks, and universities. What should I do?

Reconsider your platform. Whatever you build, build it with an enterprise database (e.g. SQL Server). If you absolutely, positively, cannot live without Access, build your solution as a SharePoint online app using Access Services.
Question

How do I insert a picture in MS Access?

In Forms and Reports, you can. On the Design tab, there is an option to insert image. If it is grayed out, then an image cannot be placed there, so click elsewhere until the option is available.
Question

Can photos be added?

Yes, but only in the Forms and Reports. On the Design Tab, it has an option to insert image. If it is grayed out, then an image cannot be placed there, so click elsewhere until the option is available.
Question

I would like to create training profile database for our employees at our department so I can track their training activities and status at any time. What can I do?

You might want to check out Airtable instead of working with MS Access. There is a higher learning curve with Access.
Question

How do I create a table in MS Access?

Click the Create tab and then pick either Table or Table Design.
Question

How can I create a password and a username for an Access database?

You can't create a username and password for an Access database from Access 2007 onward. However, you can encrypt a database with a password by opening a database in exclusive mode and then going to File > Info > Encrypt With Password.
Question

I want to build a database that I can use for my logistics company. How do I start?

Step 1 is to identify the results you desire. For instance, if you want 5 reports, then sit down and mock up your reports (you may already be doing reporting using Excel or Word for instance). The results of the reports will lead you to the fields you need in your tables. Then organize your tables. This will lead you to remembering additional information you want tracked/managed that isn't in the reports. After you've identified your tables, build data entry forms for each table. Then the reports. The a 'report criteria screen' (which is a form) for supplying criteria to the reports prior to running the reports.

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Video

About This Article

Article SummaryX

1. Open Access.
2. Click Blank database.
3. Enter a file name.
4. Click Create.
5. Add tables.
6. Enter data into your tables.
7. Click File and select Save.

Did this summary help you?

Thanks to all authors for creating a page that has been read 545,629 times.

Is this article up to date?