Project

Design Features

Sample Screen Shots

Create an Access database using Access 2007 that will manage a Parts Catalog used for a ecommerce web site.

Ease of use. Flexible searching capabilities. Design and build “where used” part relationships. Advanced VBA scripting. Excel import and export scripts.

Screen Shots

Create an Access database for managing eBay consignment store auctions.

Flexible searching capabilities. Tabbed page design. EBay and PayPal file importing/exporting with complex edits and SQL statements. Advanced VBA scripting with dynamic record sources. Includes Item Listing, Sales Tracking, Invoices, Purchase Orders, Receipts.

Screen Shots

Create an Access database for managing Sales Leads

Ease of use. Flexible searching capabilities. Tabbed page design. Advanced VBA scripting with dynamic record sources to support search. In-line combo box inserts to lookup tables. Export customer information to QuickBooks.

Screen Shots

Create an Access database for Client Contracts Management

This database featured user-level security and custom VBA scripting to enforce secure access to data. Word document merge using ODBC and Access Queries.

Client requested confidentiality

Create an Access database for tracking paper forms used in a medical study

Ease of use. Flexible searching capabilities. Tabbed page design. Advanced VBA scripting.

Client requested confidentiality

Create an Access Run-time database for scheduling Church Mass Intentions.

Ease of use. Perpetual scheduling calendar. Advanced VBA scripting. Email and Mail templates in English and Spanish. Flexible searching capabilities. Multi-user; multi-location; flexible Mass scheduling. Run-time version does not require any Microsoft Office software installed on computers.

Screen Shots

Create an Access database for tracking Financial Funds performance.

Advanced forms containing tab pages, pivot charts, pivot tables and complex calculations. Document management.

Sub forms with dynamic record sources. Advanced VBA scripting and SQL statements.

Screen Shots

Create an Access database for employee record keeping.

Built using Access Data Access Page (DAP) technology.

Accessible using Internet Explorer.

Screen Shots

Sybase Powerbuilder application.

Flexible searching capabilities. Dynamic PB Datawindows.

Screen Shots

Modify an Access database to import photographs and associate them with an asset.

Uses windows file dialog (Browse) object to pick the photo file.

Links the asset record to the photo.

Screen Shots

Create an Access database for mobile home park monthly invoicing.

Designed for novice computer users. Complex calculations of apportioned utilities. Advanced VBA scripting and SQL statements.

Screen Shots

Contact:

Phone: (928) 541-1287
E-mail: ray@clarsoftware.com

    www: clarsoftware.com

P.O. Box 628

Prescott, AZ 86302