How to Build an Employee Database With Microsoft Access

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

Microsoft Access is software that helps you create and manage databases. It is relatively easy to use, so you do not need a lot of computer experience. At the same time, it can function as a very powerful small-database management tool with which you can do a great deal of database processing if you learn how to program with it. Access also comes with templates that make getting started as easy as possible.

Advertisement

Things You'll Need

Video of the Day

  • Microsoft Access 2007

Video of the Day

Step 1

Open Microsoft Access. The Microsoft Access startup window will open, and you will see options to create databases of different kinds. Along the right side, you will see a list of recently opened databases. On the left will be a window pane with "Template Categories" and "Templates from Microsoft Online."

Advertisement

Step 2

Click on the "Business" category under the "From Microsoft Office" template list. This will load a number of business templates in the main window.

Step 3

Click on the "Time Card" template near the bottom of the list. The right windowpane will load a preview and a filename for your database.

Advertisement

Step 4

Click on the "Download" button in the bottom of the right window pane. Microsoft Access will connect to Microsoft's servers and will download the template for your use. When this is complete, a "Help" window will appear on top of the Microsoft Access window that will tell you about the template and how to use it.

Advertisement

Advertisement

Step 5

Close the "Help" window and start entering information about your employees in the appropriate fields of the tables that the Microsoft Access template has created. Enter as much or as little data about your employees as you desire. The buttons across the top of the main window allow you to navigate your database and generate reports.

Advertisement

Tips & Warnings

  • Once all your information is in your database, you can generate reports, lists and more. Consult the program's "Help" feature for ideas and assistance.

Advertisement

Advertisement