Disc Golf Access VBA Database

In the summer of 2003 I built a personal database in Access and VBA to keep track of my disc golf scores and my collection of frisbees.

In the summer of 2003, just for fun, I built a personal database to keep track of my disc golf scores and my collection of frisbees. Below you can see the table structure of my disc golf database.

 

Shows relatationships of tables and fields. Everything is properly normalized.

 

The next image is of the main page of the interface system, the Add New Game form with one of the popup forms displayed below that. Again, you can hover over portions of the image to view tooltips describing the functions of the various sections. Once you understand how I intended to use the database, you’ll see that it would have been a very efficient interface system…

 

Add new game form. Main form in my disc golf database.

…however, I wasn’t able to finish the database by the new school year. It turned out to be a bigger project than I had expected. However, for three months work while still learning VBA and reading a 900 page programming manual cover to cover, I feel I made good progress, probably more than halfway to completion of the total project. I learned a great deal about programming and came to realize how fun it can be.

The data entry systems are complete, save for a couple minor details. What remains is the data retrieval systems. Unfortunately I won’t finish this database, as I’ve found too many other programming and web development interests, but I feel it can still be an example of my ability for both programming and interface design. If you would like to download the database and explore it, or view the code, you will need MS Access installed on your computer. Start with the “frmAddGame” form.

 

Java and Visual Basic Examples

Some simple Java and VB examples from school in 2003.

Programming Examples from 2003 at Skagit Valley College. These are not compiled programs but are otherwise complete. Nothing fancy, just stuff I did for school a long time ago.

Java

Average – Calculates the average of a set of numbers.

Circle – Calculates the attributes of a circle, given two points.

Maturity – Calculates the amount of a certificate of deposit on maturity.

Paycheck – Collects name and income and calculates taxes.

Sum – Retrieves integers from a file and sums the odd and even.

 

Visual Basic

Gas Mileage – Calculates gas mileage.

Student Scores – Provides various search options on a list of students and scores.