Microsoft Access is software that helps Microsoft users to create and manage databases. Even without much computer experience it is relatively easy to use. It can even function as a very powerful small-database management tool with which you can do a great deal of database processing if you really want to learn how to program with it. Access also comes with options of templates that make getting started as easy as possible.
Microsoft Access is the database program which is included itself with Microsoft’s Office suite. Learning some basic steps will help you to make databases, tables, reports, forms and queries. And once you become familiar with the program, you can start to learn advanced techniques, such as creating mail merges and many more and then there is no looking back.
So the following steps will tell you how to build employee database with Microsoft access. You just need to follow the steps, which are as follows
Step 1:
First and foremost you have to Open Microsoft Access. The Microsoft Access startup window will open as soon as you click on it, and you will see options to create databases of different kinds. Along the right side, you will also see a list of recently opened databases. And On the left side of the screen you will see a window pane with “Template Categories” and “Templates from Microsoft Online.”
Step 2:
You need to click on the “Business” category under the “From Microsoft Office” template list. By clicking on it this will load a number of business templates in the main window.
Step 3:
Now click on the “Time Card” template near the bottom of the list. As The right windowpane load a preview and a filename for your database, click on the “Download” button in the bottom of the right window pane.
Step 4:
Microsoft Access will connect to the Microsoft’s servers and will start downloading the template for your use. When this is complete, a “Help” window will automatically appear on top of the Microsoft Access window that will tell you about the template and how to use it.
Step 5:
Now Close the “Help” window and start entering the required information about your employees in the appropriate fields of the tables that the Microsoft Access template has created. If possible Enter as much or as little data about your employees as you desire. The buttons which is across the top of the main window allow you to navigate your database and generate report.
Once you have put all your information is in your database, you can generate reports, lists and more. You can even consult the program’s “Help” feature for ideas and assistance.
When I tried my hands on this software, I was unable to move beyond step two. With these tips life at work is much easier than ever before. These steps have really made my professional life much easier. As now, I have time to focus on other tasks as well. Earlier, it used to be a tedious job to maintain database manually.
All these tips were truly very helpful for me! The step-by-step information is easy to understand and follow even by the new users like me. Earlier, it was a difficult task for me to use this software. Now, without facing any problems I can easily maintain the database and can easily generate reports in just a couple of simple steps.
I like software
I am look fort a leave access database to capture leave taken by employees. This leave is then printed in a report for anyone with more then 5 days type of leave taken, is one available. MS Access 2010 is the system i am working with
Now, earlier than I continue, it’s vital to state that PCMag would not condone illegally
streaming or downloading films.