Database Creation and Maintenance- Microsoft Access
Microsoft Access database creation and data input experience includes:
Dinkum Energy
Invoicing database to create invoices and track payments.
Fire Service Professionals
Customer/Premises Inspection and Testing report data entry:
Setting up new customers/premises and their equipment, inspection and testing requirements.
Capitalcorp Finance and Leasing
Microsoft Access Client Deals and Banking database administration:
Importing of deals via Excel spread sheets supplied by branches;
Uploading of spread sheeted commission payments;
Manual inputting of commission rebates, debt recoveries and write offs; Running analysis reports for branches, banking reports and reconciliations;
Creating queries for easier database searching and retrieving of required information;
Allocation of payments to deals per bank statements;
Introducer payments and creation of new introducers.
Pacific Brands
Expenses Database creation to track Purchase Requisitions, Purchase Orders, Delivery Dockets and suppliers' Invoices and the processing of payment thereof with aim of reporting monthly cost centre and divisional expenditure totals:
Prepare standard Purchase Orders;
Create new queries and reports and input data as required by Office Manager;
Finalise database and create a new version with new budget data for beginning of new financial year.
Employees Database created to track employee details at Newmarket site:
Input data of any new employees and update existing data;
Take photos and add to employee data;
Print out Emergency roll calls per department per employee changes.
Value Adding Database creation to track movement of product to suppliers for customer orders requiring extras:
Product and order requirement details for dispatch to suppliers for logo and name embroidery;
Product and order requirement details for dispatch to suppliers for reflective taping;
Tracking of product movement for estimated time of return.
Suncorp
A staff training/workshop database creation for approximately 500 line management staff:
This database tracked training sessions, notices to relevant staff, groupings of maximum numbers, attendances and rescheduled sessions.
