In this video, I start a series to teach TechTrax members how to take their Word forms and connect them to databases.
Why would you want to do that? Well...you could then collect data in forms and with just a click, send that data into a database for further analysis, or into a spreadsheet for that matter. Or query a database right from a Word doc to have forms filled in automatically with client information from that database. It's a great way to create a customized database that's simple to use because you create the front end the way you want it!
Or...you could make a career out of creating custom data solutions for others...I did. To see some of the advanced Word <--> data projects I've created, see this page: MouseTrax Solutions. The majority of those projects were created with Word AutoForms serving as custom front ends for a back end database. It's like creating your own, custom software program! And yes, you can do it. In this series, I'll teach you how! Even better, once you learn how to do it with Word, you can pretty easily transfer your knowledge over to the Internet to create dynamic pages that access database information on web sites. Later I'll show you some of those processes, such as creating your own web site guest book.
This first video is an introduction to the process. I'll cover some of the basics of what you will need to know before you can tackle these types of projects. Then I'll give you an overview of how it works. I'll also show you some samples of what you can do with this knowledge so you can start thinking about how you'll want to use these skills...get you thinking about what type of application you would like to build.
Note! This series will use Word 2003, but you can use 2002 and 2000, also. Due to the new XML development format in 2007, that version is not yet covered in this DB connectivity series.
Members, click to view this video lesson...
Not a TechTrax Member yet? Get the skills you need to get a better job...for a price you won't find anywhere else. Just $36 for an annual membership to view exclusive training content!.
Note: The above rating is for the Video content and not this small intro article.