Filemaker Bookings and Reservation System
In this course we will learn to create a Filemaker system used for making reservations and booking items within a date range. In this example we will be using a hotel room as an example but this can equally be used for car rental, equipment rental, studio rental, library lending. In other words any system where you have items that are in use for specific periods of time.
What this system allows you to do is simply enter a start and end date and time and then the system returns a list of hotel rooms that are available within that period.
These free rooms can them immediately be booked or guests that walk in can immediately check in.
Included in the course are the original FIlemaker File plus extra Filemaker manuals.
Take this course if you want to simplify your business by creating an application that does all your administrative work exactly the way you want it. Completely tailored to your needs.
What are the requirements?
You don’t need to have any prior knowledge of Filemaker or database systems. We take it all one step at a time.
There is no need to buy a copy of Filemaker. You can simply download a demo version and try it out to see if FIlemaker is something that works for you.
What am I going to get from this course?
Create a complete Filemaker database for any business that needs to rent, lend or hire items for a period of time.
Create a complete solution for a hotel, motel or any kind of B&B situation.
Use relationships to search for date related conflicts.
What is the target audience?
This course is meant for people who want to simplify their administration that includes room, equipment or car rental.
People who like to have a centralised system in place for all their paperwork.
People who enjoy automating boring, repetitive tasks.
|Section 1: Tables and Layouts|
Intro + Files
Rooms table and Layout
Guest Table and layout
|Section 2: Bookings and Reservations|
Finding free rooms
Refreshing our Rooms list
Booking a free room + Check in
Detailed Booking View
Check in and Check Out
A few extra checks
Solving a few problems and making some improvements
Easily finding Checked in and arriving guests
Amount of available beds
|Section 3: Billing and Invoicing|
Bills or Invoices
Room Pricing Part 1
Room Pricing Part 2
Choosing the price while booking a room
Making the actual Bill or Invoice item for the room
Showing the Bill details on the Bookingsdetail layout
Adding totals and calculations to our room price list
Adding a breakfast to the booking
Adding the breakfast to the Invoice Details
Effectively making the Bill Part 1
Effectively making the Bill Part 2
Invoice List Finds
Invoice Tweak and Vat
Invoice Print Layout
Invoice Print Layout Part 2
Printing a Bill
Making a Pdf Bill
Mailing a Bill
|Section 4: Other Hotel related additions|
Breakfast List Finds and Checklist
Add Breakfast Script
Add Breakfast check
Getting the Laundry items on our Invoice Details
|Section 5: Bar|
Setting up our Bar section
The Guests in our bar
Dwindling Value List
Bar Price List
Bar Price List Part 2
Clearing the guest list for the next day
Guy Stevens, Filemaker freak
For years I was trying to figure out a good system that would be flexible and allow me to do some proper invoicing and stock management. After years of messing around with Excel files I finally had had enough and went looking. I found Filemaker and discovered a great tool that was packed with great functionality. I dove right in, started to learn everything I could. What started as a simple invoicing database became two and I was always looking to add more and more. I kept running into problems which forced me to find solutions and slowly I started to get to know Filemaker like the back of my hand. Now years later I have taught loads of people how to work with Filemaker and how to solve difficult problems. I have created very complex setups which have taught me everything I need to know about Filemaker.
- Lectures 0
- Quizzes 0
- Duration 50 hours
- Skill level All level
- Language English
- Students 444
- Assessments Self