Using the Office Equipment Manager template


You can use the Office Equipment Manager template to track your company’s office equipment inventory. You can store the equipment by name, description, category, barcode number, serial number, and model number. In addition, you can track how much you paid for the equipment, the date it was acquired, and add comments about the equipment. You can also keep track of which employee the equipment is assigned to. In addition, you can look up a list of employees contained in the database to quickly and accurately add the information to a new record.


When you open the Office Equipment Manager template, a form containing an existing equipment record is displayed. You can then insert or delete records in the database. If you insert or delete records, the changes are stored in the Office Equipment Manger tables. In addition to adding new equipment records to the database, you can also add and remove employees in the database.


You can search through the equipment records. You can also generate a report based on the information found in the tables and then print the report.


To insert an item in the Office Equipment Manager template


1. Click Insert.

2. Type the item’s name in the Item name box.

3. Type a description in the Description box.

4. Type the items category type in the Category box.

5. Type the item’s barcode in the Barcode box.

6. Type the item’s serial number in the Serial number box.

7. Type the item’s model number in the Model number box.

8. Type the price paid for the item in the Price box.

9. Type the date (m/d/y) when the item was acquired in the Date acquired box.

10. Type an employee to which the item is assigned in the Employee ID box.


Tip

•          If you want to add notes about the item, type them in the comments box.


To delete an item from the Office Equipment Manager template


1. Choose an item in the Office Equipment Manager template.

2. Click Delete.


To move through the items the Office Equipment Manager template

 

•          Click Next - moves to the next item in the Office Equipment Manager template

•          Click Previous - moves to the previous item in the Office Equipment Manager template



To lookup an employee number


1. Click in the Employee ID box.

2. Press CTRL + SPACEBAR.

3. Click in the EmployeeId field of employee to which the equipment is assigned.

4. Click OK.


To add an employee to the Office Equipment Manager template


1. Click Employees.

2. Press F9.

3. Click Record, Insert.

4. Type an employee number in the EmployeeID field and press ENTER.

5. Type the employee’s first name in the First name field and press ENTER.

6. Type the employee’s last name in the Last name field and press ENTER.

7. Type the employee’s title in the Title field and press ENTER.

8. Type the employee’s phone number in the Phone field and press ENTER.

9. Type the employee’s phone extension in the Extension field and press ENTER.

10. Type the department where the employee works in the Department field and press ENTER.

To delete an employee from the Office Equipment Manager template


1. Click Employees.

2. Press F9.

3. Click in a field belonging to the employee you want to delete.

4. Click Record, Delete.


To generate a report

 

•          Click Report.


To print the report

 

•          With the report open, click File, Print.