DB-Guru's Portfolio

Below are some sample forms to give you an idea of the style and forms available, however they can be customized to suit your business's needs and preferences. Forms can be customized to enable access however you need it. If you, or someone in your company wants to be able to change the forms, reports, etc., that access can be enabled. However; user access can also be restricted to only certain fields and buttons to enter and run necessary reports to maintain database security as needed.

In our typical development, unless the Client has a preference List and Detail forms are created. Left/above is one sample of a List form. These forms provide a lot of flexibility for the user to sort and filter the records very much like an Excel Spreadsheet. This sample database has 698 records but the data has been hidden to protect client confidentiality. When the user clicks the Open link on the left of the form the Detail form is opened for ease of data entry and to view all fields. These List forms can easily be modified to show as little or as many fields as desired by scrolling the form to the right. They can also be programmed to flag certain parameters as shown with the Extended Term Status at the top, and the Open buttons that meet that parameter are color coded yellow. Multiple parameters may be setup.

Another sample List form with some less sensitive data showing, so you can see the rows more clearly. They are almost identical to an Excel Spreadsheet. Most data can be sorted and filtered by each of the columns. Unless increased security is enabled the columns may be dragged and dropped into the order preferred by each user.

Access List Form Sorting and Filtering Text Data

Sorting and Filtering Text data is a simple process on the list forms by clicking the caret next to the field that you wish to sort or filter. Advanced filter options are also available.

Each different field type has different options to filter the data. As shown left/above the Date field has many options to filter out the data needed.

Currency or numerical data also has it\'s own parameters to filter data.

On the previous List form when you click on the Open command at the left of the form for your selected record, a Detail form opens with an easy to use interface to Add or Edit data. Multiple tabs are available if more entry space is needed for related information, or to show reports or related data. Required fields are highlighted, and the grayed out fields are automatically populated from the data entered.

Multiple tabs may be kept open as needed for ease of entry, and can be switched between as desired. The Detail forms are updated each time you open a different record on the List form, or manually by clicking the Refresh button.

A Detail form for entering and modifying Board information with multiple tabs containing related information

A Detail form used for entering and ordering Equipment with a tab that tracks the quotations sent for the particular piece of equipment.

This form is part of a database that is used to track payments and debtors for Judgements.

This database is a simple Contact database with a call log. The sub-form Offerings at the bottom left of the form links to multiple forms containing extended information related to this contact.

This is a sample of a Dynamic Inventory Form/Report that updates automatically based upon current data entered and shows a six month sales forecast. (Built in Access 2003).

A Dynamic Product Order Entry Form/Report that updates automatically based upon current data entered and shows a six month sales forecast. (Built in Access 2003).

For drop-down buttons with many entries a simple form similar to this one is used that the user can edit on the fly. These forms can be opened from the drop-down box within the Detail forms as needed for new entries or from a menu selection, and are added at no charge.

A Microsoft Access Detail form to add new Attorney or Law Firm information. (Built in Access 2003).

Microsoft Access Order Detail form to track payments sent to Attorneys. (Previous system involved many spreadsheets and months to coordinate the data). (Built in Access 2003).

This form shows how several related forms can be nested to show more details related to the contact. (This is not the recommended or optimal design, but Client requested. See the Microsoft Access Board Details Form above for a better design.)

This is an older interface with commands to import data from a COGNOS system and generate reports. (Built in Access 2003).

A database design that is formatted to the Client's specifications to ensure that a tractor trailer drivers do not exceed the maximum hours allowed.

DB-Guru's Portfolio

Our database development team can develop user interface forms and menus in any style.

Click on any of the images below to see a larger version.

Microsoft Access Sample List Form

Microsoft Access Sample List FMLS

Access List Form Sorting and Filtering Text Data

Sample List FMLS Date Filter

Sample List FMLS Currency/Number Filter

Sample Appointee Detail Form

Sample FMLS Detail Form"

Microsoft Access Board Details Form

Microsoft Access Equipment Detail Form"

Microsoft Access Database Sample Detail Form Judgement

Microsoft Access Database Sample Form Contact with Call Log

Microsoft Access Dynamic Inventory Form

Microsoft Access Product Order Form

Microsoft Access Simple DropDown Add Form

Microsoft Access Attorney Database Form

Attorney Database Check Entry Form

Microsoft Access Database Sample Form Nested Judgement Form

Imported Booking Data Interface

Microsoft Access Driver Time Entry Form

Tags

Categories

DB-Guru's Portfolio

Our database development team can develop user interface forms and menus in any style.

Click on any of the images below to see a larger version.

Microsoft Access Sample List Form

Microsoft Access Sample List FMLS

Access List Form Sorting and Filtering Text Data

Sample List FMLS Date Filter

Sample List FMLS Currency/Number Filter

Sample Appointee Detail Form

Sample FMLS Detail Form"

Microsoft Access Board Details Form

Microsoft Access Equipment Detail Form"

Microsoft Access Database Sample Detail Form Judgement

Microsoft Access Database Sample Form Contact with Call Log

Microsoft Access Dynamic Inventory Form

Microsoft Access Product Order Form

Microsoft Access Simple DropDown Add Form

Microsoft Access Attorney Database Form

Attorney Database Check Entry Form

Microsoft Access Database Sample Form Nested Judgement Form

Imported Booking Data Interface

Microsoft Access Driver Time Entry Form

Share this:

Tags

Categories