Fast, Accurate, Professional Solutions in Microsoft Access

Gallery of Screen Shots

Microsoft Access is known as a Rapid Application Development (RAD) product – meaning that custom applications can be quickly developed, debugged, and deployed.

At Beach Access Software custom applications can be developed even more rapidly through the use of a library of already existing input forms, reports, queries, in addition to many pre-programmed functions. These libraries, accumulated over a period of years of development, ensure that our clients not only receive great value but that their applications are delivered quickly with a minimum of bugs. In other words -- fast, accurate professional solutions at an economical price.

Below you can see several screen shots of applications developed at Beach Access Software. The primary objective of each of these applications is to make the program so intuitive that the user can run it without reading a technical manual or needing training.

  • Toy Track Enter/Edit Parent and Child Data
    Toy Track ™ is an application built specifically for the local chapters of the national Toys For Tots program which collects and distributes toys to tens of thousands of children every Christmas. The application tracks parents, children, volunteers, donors and donations assisting the local chapters in every aspect of toy collection and distribution. View additional information about Toy Track
  • San Diego Chargers
    A log in form is the common opening form for many applications. It requires the user to enter a name and a password to gain access to the program and data. Access is commonly granted in three levels: 1) read only, 2) read write, 3) administrator. The forms and code to control this function exists in a library which makes it easy to copy and insert into any application.
  • Bear Tracks
    Occasionally it becomes necessary to implement a more detailed scheme of access ~~ granting read only or updating permission at the form, function, or even data field level. Here you see a permission form which grants access by action or function to the three levels of access.
  • Road Rebel
    Sometimes a record contains so much information that it cannot fit entirely on one screen. For example, to profile a hotel for a reservation application some 120 data items are needed. In that case, a tabbed form, as you see here, is used and the data is grouped logically onto separate pages.
  • Parking 1
    Another way to control access to functions in an application is to design separate main menus. Here the Admin menu gives a users with administrator permission access to all of the functions in UCSD’s very complex Parking Permit System.
  • Parking 2
    The Cashier menu is what appears to a user labeled as a cashier and allows them limited access to the system.
  • Emerald Seed Co. Main Form
    This is the main variety form from which the user can access variety and lot details on any seed variety and generate many different kinds of inventory status reports.
  • Emerald Seed Co. Lot Control
    From this form the user easily get the details on any lot of seed and can see inventory that has been received, sold, and shipped.
  • Emerald Seed Co. Status Listing
    An interesting feature in the Emerald Order System that the client requested is the changing of the background color of the main order entry form to signal the status of the order. The colors and statuses are user defined, giving them maximum flexibility.
  • Emerald Seed Co. Order Tracking
    Here, the blue background color (as well as the status box in the upper right) indicates that this order has been shipped.
  • SWS Report
    One of the most powerful features if Access is its ability to interact with the other components of Office. Called "Automation," it was used to great advantage in the H & M Landing accounting application. H & M books sport fishing charters for a number of boats. To render an accounting of money owed to and by the boats, the data in their Access mdb is exported to this spreadsheet where the numbers can be adjusted. All the code to generate the spreadsheet is in their application. When the spreadsheet is closed, some of the data from the spreadsheet is transferred back into their database using custom developed code behind the spreadsheet.
    Because there is a great deal of data entry required to record the time for each employee, the challenge was to create an input form that could be run entirely from the keyboard, without the use of a mouse. That way, the data entry operator could enter all the data, using almost exclusively their right hand, without having to switch from keyboard to mouse. This speeds entry and increases accuracy. It was accomplished by carefully modeling the preferred sequence of data entry operations and creating keyboard shortcuts (underlined letters in the command buttons).
Thumbnail panels:
Now Loading