How to Build an Employee Database With Microsoft Access
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.
Things You'll Need
- Microsoft Access 2007
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."
Click on the "Business" category under the "From Microsoft Office" template list. This will load a number of business templates in the main window.
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.
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.
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.
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.