P.O. BOX 720193
OKLAHOMA CITY, OK 73172

FOR MORE INFORMATION CALL:
(405) 470-1913
Fax (405) 721-1897

E-mail: carol@macspecinc.com

FILEMAKER PRO DATABASE DEVELOPER

DESKTOP PUBLISHING AND FILEMAKER PRO TRAINING IN OKLAHOMA CITY

Classes Offered

Class Schedule

Enrollment

Developed Filemaker Databases

OKC Training Center Map

Hotels

MacSpec has developed several Filemaker Pro based databases for schools.

For pricing information, call us.

Budget Tracker Pro software is designed to assist in maintaining detailed records of requisitions, purchase orders, invoices and vendors. It is a FileMaker Pro 7.0 database that is based around the OCAS accounting codes used by the Oklahoma State Department of Education. Information and tracking in this software is centered around three fields: Project Code, Requisition Number and Purchase Order Number. It is a relational database that easily generates report summaries from a single data entry.

The main functions of Budget Tracker Pro are:

• Budget tracking by project code and departments.
• Tracking vendor information and amount purchased from each vendor
• Entering and tracking requisitions against budgeted project codes or departments.
• Entering and tracking invoices approved/paid.
• Generates reports for budget, requisitions and expenditures charged to each project code.

SOFTWARE & EQUIPMENT REQUIREMENTS

Budget Tracker Pro:

• Requires Filemaker Pro 7.0 and runs on either Macintosh or Windows operating systems supported by FileMaker Pro 7.0.
• Can be purchased and used as a FileMaker Pro 7.0 database, which requires a licensed copy of FileMaker Pro 7.0.
• Can be purchased as a stand-alone runtime version, which does not require a licensed copy
• of Filemaker Pro 7.0.
• Can be purchased for a single user or as a networked solution for several users.

CUSTOMIZATION

MacSpec, Inc. is available to work with your organization to customize the software to fit the individual needs of your school or district.

We also work on a contract bases to develop and design customized FileMaker Pro databases for network or web base access to help resolve day-to-day data management challenges.

The main functions of Budget Tracker Pro are: Technology Repair Requests and Maintenance Work Orders
Filemaker Pro Databases & Web Publishing Templates  
These FileMaker Pro database templates are designed to track and manage Maintenance Work Orders and Technology Repair Requests.
Save thousands of dollars and hours of development with these templates.
They are complete and ready to use.
If you already have a Filemaker Web server, simply install the templates
on your server and you are up and running in minutes.

• ACTIVITY FUND MANAGEMENT
• REQUISITION/PO MANAGEMENT
• EMPLOYEE\MONTHLY LEAVE
• FIELD TRIP MANAGEMENT
• SOFTWARE REQUIREMENTS
• CUSTOMIZE PROGRAMS

The activity fund accounting software enables elementary, secondary, and K-12 schools to manage and report information faster and more efficiently. This Filemaker Pro based database is based around the OCAS code of accounting as required by the Okla. State Dept. of Education. It provides for detailed tracking of requisitions, purchase orders, cash disbursement, cash receipts, ISF checks, redeposits, bank reconciliations, outstanding checks, and vendors. Transactions are entered once and will then appear on detailed reports, financial statements, and bank reconciliation worksheets. It will provide information that can be retrieved quickly and accurately. Information and tracking is centered around three fields: Project Code, Requisition Number and Purchase Order Number.

The main functions of this database are:

• Entering and tracking requisitions.
• Tracking amount of requisitions and purchases charged to each project code.
• Entering and tracking cash receipts and cash disbursements.
• Report 1099 vendors.
• Reconciling bank statements.
• Tracking vendor information and amount purchased from each vendor.
• Fund Transfer and Sub Account change forms.

GO TO TOP

This Requisition/PO database is designed to assist in maintaining detailed records of requisitions, purchase orders, invoices and vendors. This Filemaker Pro based database is based around the OCAS code of accounting as required by the Okla. State Dept. of Education. It will provide information from a single data entry that can be retrieved quickly and accurately. Information and tracking in this database is centered around three fields: Object Code, Requisition Number and Purchase Order Number.

The main functions of this database are:

• Entering and tracking requisitions.
• Tracking amount of requisitions and purchases charged to each object code.
• Entering and tracking invoices approved/paid.
• Creating budget comparison reports by object code.
• Tracking vendor information and amount purchased from each vendor.

GO TO TOP

This employee/monthly leave database is designed to maintain employee data such as hire date, salary, department, and grade. Personal information in the notes field and emergency contacts can also be entered. This Filemaker Pro based database will provide information that can be retrieved quickly and accurately. Monthly Leave information for accrued and used leaves can be maintained on each employee.

The main functions of this database are:

• Record and Track employee information.
• Track and report accrued and used leave time.

GO TO TOP

FIELD TRIP MANAGEMENT

This Filemaker Pro based Field Trip database is designed to assist school transportation departments to maintain records for field trips. It provides for tracking of bus drivers, buses, field trips and billing to various school/dept. A field trip is entered once from the completed trip request form. All other information such as bus driver assignment, driver's time and mileage are all tracked by an automatically assigned field trip number.

The main functions of this database are:

• Entering bus driver information.
• Entering bus information.
• Entering and track field trips.
• Assigning bus drivers.
• Creating invoices and tracking payments.

GO TO TOP

All these databases require Filemaker Pro 5.5 or later on either Windows or Macintosh.

Windows
Any IBM or compatible computer that supports Window 98.

Macintosh
Any Macintosh operating system software of 8.6 or greater.

GO TO TOP

One of the advantages of these databases is that MacSpec, Inc. can personally customization them to fit the personal needs of each school. If there is something different that your school requires or needs, we will work with you to provide customization of the databases to fit your needs.

If none of these databases met your needs, we will work on contract to develop any database that would provide the necessary data and information to meet your school's needs.

GO TO TOP