How To Create New Database In Access Using Template

Download Article

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

i

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

Select Blank database . It'due south the offset option in the "New" section. The other options are templates that are set upwards for specific purposes, such every bit contact management.

Advertisement
iii
Enter a filename into the box. The default file name begins with the discussion "Database" and ends with ".accdb." You'll want to go on the ".accdb" role, only you tin supervene upon the rest of the file name with whatever you lot'd like.
- For example, if you lot're creating a database that contains an employee list, you could call it Employees.accdb.
- If you want to salvage the database in a specific binder, click Browse and select that folder.
four
Click Create . This creates your new blank database, likewise as a new empty tabular array called Tabular array one.
- All tables in your database will appear in the left panel. As yous add more than tables, you tin can click the table names to switch to that tabular array's view.
five
Add tables to the database. Tables are places that store data in your database. You tin can enter your data straight 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.^[ane] If you're familiar with Excel, think of tables like private worksheets in a workbook. Data in a table is organized in rows and columns. You tin fifty-fifty import information from an Excel spreadsheet into a table. To add a tabular array:
- Click the Create tab.
- Click Table in the "Tables" group. You'll see that in that location's now a table called "Table 2" in your database.
- To rename a tabular array, right-click its name in the left column and select Rename.
- If you desire to delete a table, right-click its proper noun and select Delete.
6
Enter data into your tabular array. The first empty cell under "Click to Add" is where your cursor appears automatically.
- To start entering data and allow Excel choose the field type, but start typing into the offset cell nether "Click to Add." Press the Enter key to move to the side by side field.
- To select a field type, click the Fields tab if information technology'southward non already selected, then click ane of the field types on the "Fields" panel in the toolbar. If you lot don't see what you demand, click More Fields to display boosted options. Yous can also click Click to Add together to open the quick menu, which contains common field types.
- You lot tin drag fields around to movement them. You tin can also drag columns to other positions.
- To rename a column, double-click its heading, enter a new name, and then printing Enter.
7

Advert

1

Open Microsoft Access on your reckoner. Yous'll find it in the Windows Start menu or your Mac's Applications folder.
two
Browse the available templates. Several templates volition announced on the initial screen. Yous can as well check out other templates online by clicking More options or Suggested searches: Access databases, depending on your version.^[2]
- When searching for online templates, y'all 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 yous don't like the way the template looks, click the Ten at the tiptop-right corner to return to the template list. Continue clicking through templates until you notice the i y'all want to employ.
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, merely you can replace the rest of the file name with whatever you lot'd like.
- For example, if you're creating a database that contains an employee list, you could call it inventory.accdb.
- If yous want to save the database in a specific folder, click the Scan push 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 employ this panel to switch between dissimilar elements of the database.
- Depending on the template, you lot may automatically exist brought to a form that allows you to enter data into the database. Other templates may not have data entry forms, instead requiring y'all to enter data directly into the table.
6

Click Enable Content if prompted. Depending on the template, you may encounter a security alarm in the message bar. Every bit long as you trust the source of the template (it'due south fine if you download it from Access, only non recommended if you download from 3rd party websites), click Enable Content to kickoff editing.
7

Create a login if prompted. If you come across a login dialog with an empty user list, you lot'll need to create a user for the database. Click New User, make full out the class, click Salvage & Close, and so click Login to sign in with your new user business relationship.
viii
Delete sample data. Depending on the template, some data may already be filled in. When you're gear up to input your own data, you'll desire to remove the sample data. Here'southward how:
- Click the shaded box to the left of the tape you want to delete.
- Click the Dwelling tab if you aren't already there.
- Click Delete in the "Records" console on the toolbar.
9

Save your new database. Once yous start entering data, you'll want to make sure yous don't lose your changes. Click the File bill of fare and select Save to salvage your progress.

Advertisement

Add together New Question

Question

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

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

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

Open up the desired tabular array. Click on Pattern View. Type the field names in all caps at this betoken.
Question

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

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

How do I insert a film in MS Admission?

In Forms and Reports, you tin. On the Blueprint tab, there is an selection to insert image. If it is grayed out, then an prototype cannot exist placed in that location, so click elsewhere until the pick is bachelor.
Question

Can photos exist added?

Yes, but just in the Forms and Reports. On the Pattern Tab, information technology has an choice to insert image. If it is grayed out, and then an epitome cannot be placed there, then click elsewhere until the option is bachelor.
Question

I would like to create grooming profile database for our employees at our department so I can runway their training activities and status at whatever time. What tin I practice?

Yous might want to bank check out Airtable instead of working with MS Access. In that location is a college 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 tin I create a password and a username for an Admission database?

You tin't create a username and password for an Admission database from Admission 2007 onward. Even so, you lot can encrypt a database with a countersign past opening a database in exclusive fashion and so going to File > Info > Encrypt With Password.
Question

I want to build a database that I tin can apply for my logistics company. How do I offset?

Step 1 is to identify the results you desire. For example, if you want 5 reports, then sit and mock up your reports (you may already be doing reporting using Excel or Discussion for example). The results of the reports will lead you lot to the fields yous demand in your tables. So 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 information entry forms for each table. So the reports. The a 'report criteria screen' (which is a course) for supplying criteria to the reports prior to running the reports.

Inquire a Question

200 characters left

Include your e-mail accost to get a message when this question is answered.

Submit

Video

Almost This Article

Article Summary 10

one. Open Access.
2. Click Bare database.
three. Enter a file name.
4. Click Create.
v. Add tables.
6. Enter information 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 557,563 times.

Is this article up to date?