Can I get OSQL if I install SQL Server Client Tools?

Get me started on building a scheduling application in Base

• Building a small scheduling database application in OpenOffice Base. Needing some tips on getting started and pointers to tutorials. I'm helping out a charitable organization by creating a small scheduling database for the volunteer coordinator that will allow her to keep track of information on her volunteers and keep track of their work shifts from week to week. I'm an experienced programmer, but my expertise is with SQL Server, Coldfusion, and Java. I need something simple that I can install on the volunteer coordinator's laptop. My copy of Access is 10 years old and I'm not sure whether the coordinator even has Access on her computer, so I figured OO would be the way to go. I'm assuming that OO Base should be able to do what I need, but I'm having trouble wading through all the tutorials out there to locate the functionality I'm looking for. If it doesn't have the functionality I'm looking for, then feel free to recommend something that does. Designing the tables is no problem. I'm looking for some guidance in building the front end. Requirements follow: 1) Ideally, the end user would be shielded from the messing directly with the database and could just click on an icon which would open up a main menu screen which would provide options for entering volunteer info, scheduling shifts, viewing reports, etc. This isn't mandatory, but would make the whole thing much more usable. 2) The user will be using forms to enter information in the database, but the forms you can create with the forms wizard that directly link to records in the tables aren't sufficient. I need to be able to insert some sort of processing/validation rules in-between the data entry and the database. Example - the Volunteers table would have fields for VolunteerID, FirstName, LastName, ContactInfo, etc. The ScheduledShifts table would have LocationID, VolunteerID, Date, StartTime, EndTime, etc. When the coordinator goes to the form for scheduling a shift, I want her to be able to select the Volunteer Name (first + last) from a dropdown. Then when she saves the record, I want the VolunteerID to be saved in the ScheduledShifts table, not the actual name. Another example - I want to have some validation for start times and end times to avoid overlapping shifts. I want to be able to provide a user-friendly message when the user tries to enter data that doesn't make sense. I assume I'll need to use some sort of macro for this, but none of the tutorials I've found so far are on-topic for how to allow this sort of processing of form data. 3) Since this will be used for scheduling, it will be really useful to be able to convert dates to weekdays and manipulate them accordingly. One piece of functionality that has been requested is the ability to maintain a "generic" Monday-Friday schedule which can be copied to upcoming weeks and edited as necessary. If anyone can point me to tutorials which are on-target for addressing these requirements, I will be very grateful. If anyone wants to explain directly how to start with any of these or even suggest useful search terms, I'll be grateful for that as well. Suggestions for alternate tools to use are also welcome, as long as they are free and easy to install.

• Answer:

  BTW - it's been a while, but I do have some background in Visual Basic, which I understand is close to what OO uses for macros.