Articles, Blog

Microsoft Access Irrigation Appointment Tracking Database Template

Hey everyone, it’s Blake Bundy here from Winning Solutions, Inc. and today I will be bringing you guys another Microsoft Access Expert template walk-through I will be showing you guys where to find the template database on our website how to download the template database demo and how to use the demo properly Most of our templates are not designed to be used on their own Instead, they are designed in a way that makes it simple and smooth to integrate it into an already existing database that you have already been using You can also build a more robust Microsoft Access database that is build around one of our templates If you would like to create a new database that is based off one of our templates and don’t know how or do not have the time to do so let us know and we would be happy helping you with getting the database that 100% fits your needs With most of our templates that we offer, there are 3 different versions that you can purchase a compiled runtime version one for internal use and one for unlimited developer use Our compiled runtime version is a run-as-is version without the paid full version of Microsoft Access using the free Access Runtime from Microsoft It can be integrated into your existing Access application but you would not be able to make any other modifications to the form, reports, modules, etc. This option is more for those of you who do not see any need to make any customization to the template Our internal use version allows you to use or modify the databases however you wish within the organization And last but not least, our unlimited developer use version allows you to use the database template however you wish for any applications you develop and distribute the template as part of a database you create Winning Solutions, Inc.’s templates have a strong advantage over shrink wrap software that you purchase from a store or website With our templates, you receive the source code along with your purchase so you are able to customize and update the database as you please With shrink wrap software, you do not receive the source code when purchasing the software which means that you cannot update or customize the database as you wish In our video today, we will be working on a demo version of our database template A demo is a simple way you can view and try out our database templates so that you can determine if you would like to purchase it or not This is great for customers due to the fact that all of our sales are final Our sales are final because we give you the source code when you purchase the template And once we give you the source code there is really no way you can return the code If you would like to test out our demos for multiple days you are free to do so All you have to do is leave the database open so that the data you enter will not be wiped That is because our demos are designed so that once you close the demo all the data you have entered will be wiped from that database You have to purchase the full version if you would like to save your data that you have entered Upon downloading a demo for one of our templates, you will have to unzip the file Zipped files make it much easier to send and download large files over the Web Unzipping a file is a very simple step All you have to do is extract the file so that you have access to the uncompressed file If you do not know how or do not understand how to unzip a file check out one of our YouTube channel and watch the “How to unzip one of our files” video tutorial to learn this simple step The link to that video will be in the description of this video So now, let us get into testing out one of our templates We’re going to start off here by going to our website at Ass you can see, I have been here before On the top of our website, there is going to be a tool bar will all the various ways that you are able to contact Winning Solutions, Inc. You’re going to want to click on the sidebar button on the left side of our homepage that is labeled database templates for sale A sub list then opens up and you need to select the database templates list button to view the list of all the templates that we offer The list is broken up into categories The different categories that we currently have are Our most popular ones appointment and scheduling database calendar databases reservation and booking databases contact and communications databases task management databases equipment and maintenance tracking databases sales databases employee databases education databases small business databases and last but not least database tools and miscellaneous templates And today we’re going to be taking a look at the Microsoft Access Irrigation Appointment Tracking Database So you’re going to want to scroll up here and you’re going to want to go to our appointment and scheduling section And you’re going to want to click on the Access Irrigation Appointment Tracking Database So go ahead and click that Once that loads You’re going to want to download the demonstration that correctly corresponds with the version of Access that you’re running on So I’m going to go ahead and download this one Once it downloads, begins and finishes, go ahead and open it Once you’ve opened it you’re going to want to extract all the file, so just go ahead and hit extract And once you’ve extracted all that file, you’re going to want to go ahead and open the file And with all of our database templates, since they do come from the Web You’re computer views it as a potential security risk or warning Now I can assure you that this database template is safe, so I’m going to go ahead and continue on and open the database And along with all of our database templates You get a pop-up box that shows all the different ways that you can contact us Feel free to contact us whenever you’d like However, I’m just going to close out of this for now So what this database template would be good for is if you owned an irrigation company or something like that and you needed to keep track of all your appointments, your contacts, and all that good stuff However, if you liked this database template, but you don’t own specifically an irrigation company You can contact Winning Solutions, Inc. and we can customize the database template to make it compatible for any company that you have So we’re going to start off this demonstration by we’re going to create a new customer Just going to create a fake one We’ll go Bill White And I’m not going to fill out all this information, but I will fill out a few sections I’m going to put in an email and I’ll put in a phone number why not But as you can see, you can fill out a lot of information You can fill out their address for their business, for their home, their IM address, their web page address A bunch of different types of phone numbers, they have a lot here as you can see And you can even fill out notes, their call history, your appointment history, and your payment history As well as a job title and a picture of the customer So this is a pretty detailed section, you can fill out a lot of stuff However, I’m just going to fill out this stuff for now for the sake of the demonstration I’m going to go ahead and click save and close now And now I can actually search for the customer, so I can search with all of these different criteria I’m just going make it easy, I’m going to search by the last name And there’s our customer Bill White, [email protected] is his email and you can actually double click the record to view it and or to edit However, we are not going to edit anything now but as you can see we have all this stuff still here Here you can even put in a picture like I said, you can edit any of the information We are not going to do that for now, so just go ahead and close that Close out of this So now we’re going to make an appointment, so if you view the schedule calendar As you can see, you can see it in daily form, weekly form, monthly form, I’ll show you what the monthly form looks like But we’re going to go with the daily form and we’re going to create a new appointment for today And we’re going to make one from 8am to 9am So just go ahead and double click that We’re going to make our customer Bill White Our employee on the job is Person 1 And the type, we’re going to put service and we’ll just make it easy, put Location 1 And now I’m going to go ahead and change the time from 8am to 9am And as you can see if you’re going to have multiple workers work on a project You can actually put in multiple workers, we’ll put Person 2, Person 3, etc. And you can even fill out the payment information, how they are going to pay for the appointment that you have So it’s pretty detailed And I’m actually going to select a custom color for this And reason being is that it make it orange here, but it also makes it orange on the calendar So if I were to have a bunch of appointments back to back to back, it would be hard to tell which time they are and how they’re separated Now if we change the color for each one, it would be really organized and you could really tell I have one from 8 to 9, 9 to 9:30, 9:30 to 10:15 and it would be color coded so it’d look really organized Go ahead and save and close that As you can see, service at Location 1 I’ll show you what it looks like in the monthly view There we go so, pretty cool And you can even view the schedule by day so if you have a ton of appointments on a specific day Or maybe you just want to know a ton of appointments at certain locations you can search for that And this would be really helpful so like I said if you had a bunch of appointments in one day And you wanted just a list of them instead of looking at the calendar this would be really helpful to keep it all organized So this is a pretty detailed database, it’s pretty handy So I’m going to go ahead and thank you guys for taking the time to watch this Microsoft Access Expert template walk-through brought to you by Winning Solutions, Inc. I hope you guys enjoyed the video If you did, please feel free to subscribe or like or YouTube channel for tons of other walk-throughs and tutorials As always, feel free to contact us for any of your IT needs whether it be programming that you need, you want to buy a template, you want to customize a template, anything Feel free to contact us whenever you’d like I’m going to go ahead and I’m going to post our contact information in the description below of this video Also, you can find us on about any social media website Feel free to follow us or like us on there, we post quiet frequently Once again, thank you guys for taking the time to watch this Microsoft Access Expert template walk-through And have a great day

Leave a Comment

Your email address will not be published. Required fields are marked *