Hodges Custom Coding

Microsoft Access for small businesses

Here are some examples of the types of Forms and Reports we can make.

Main menu will all forms and reports for ease of use (or some functionality can be hidden for Admin users).

A screenshot of a menu Description automatically generated

(Multiple forms can be combined with side mini-menu).

A screenshot of a computer Description automatically generated

Split form with list of user selectable Order records on the right, Order data edit form in to left and Order details below.  Great for querying, sorting and editing Order records. Note: report button for current record.

A screenshot of a computer Description automatically generated

Simple form, users may find less busy for entering new order records).

A screenshot of a computer screen Description automatically generated

Customer data form with detail order info for that customer at the bottom.

A screenshot of a computer Description automatically generated

Split form with user selectable product records on the right, product data at the top left and list of order details for that product at the bottom.

A screenshot of a computer Description automatically generated

Split form with user selectable Employee records on the right, Employee data at the top left and list of order details for that Employee at the bottom.

A screenshot of a computer Description automatically generated

Run custom Order reports based on any of the fields (between dates) and limited to specific Customers and/or Employees if desired.

A screenshot of a computer Description automatically generated

Packing slip report for one order.

A screenshot of a product packing slip Description automatically generated

Employee Phone number report (to look up phone numbers).

A screenshot of a phone number Description automatically generated

Sales totals by product report.

A screenshot of a computer Description automatically generated

Sales by Month report.

A screenshot of a computer screen Description automatically generated

Monthly sales by employee report.

A screenshot of a computer Description automatically generated

Report to show sales of products at different price points (to find price for maximum profitability).

A screenshot of a computer screen Description automatically generated

Incomplete Orders report.

A screenshot of a computer Description automatically generated

Filtered Orders report. After right-clicking in this report, it can be modified with different filters and sort orders.

A screenshot of a computer Description automatically generated