Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
 
Home > Courses > Access > Seminars > Web Sync >
 
Access Web Sync Seminar

Use Access to Power your Web Site, Collect Data


 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark Buy Now

Welcome

This seminar covers integrating your Microsoft Access database and your Web Site. You will learn how to use Access to feed your Web Site with data and use Access to read information from the Web.

Resources

Main Seminar Goals

  • Use Access to pull information off of Web pages
  • Collect data on your Web site and download it into Access
  • Update your Web site with data from your Access database

Topics Covered

You will begin by learning how to pull information from different Web pages into your Access database. We'll see how to read the current temperature, and how to pull down current stock prices.


 

Next, you will learn how to create a customer data collection database on your web site. You will collect names and email addresses and then pull that information down into your Access database.


 

Then you will learn how to use Access to maintain a product database and upload that information to your Web site. The benefit is that someone with absolutely no skills with Access or Web design can maintain and update your Web site with just the click of one button.


 

You will learn how to use the Microsoft Web Browser control inside of Access so you can use it to load and analyze any page on the Web.


 

We'll program a timer event to make your Access database automatically go out to the Web every couple of minutes to download real-time stock quotes and store them in your database for analysis.


 

Next you will learn how to create a form on your Web site to collect user information: name, email address, etc.


 

Then we'll learn how to use Access to download that data from our Web site so we can collect the names and addresses every day - or whenever there is new data.


 

Next we'll learn how to use our Access database to control the content of our Web site. We'll store the text for each of our Web pages in our Access database and then with the click of a button be able to update our Web site. This way, someone who doesn't know Web design can easily update the content on your Web site.


 

Finally, we'll do the same thing with a product database. We'll create a local product table and form in our Access database, and then with the click of a button update our Web site with all of the product information that has recently changed. Again, it's one-click maintenance of your Web site, and it allows you to synchronize the data between both databases.


 

This seminar is for anyone who wants to work with their Access database and the Web. Whether you're pulling information down from your Web site, collecting data from other sites, or even pushing information back up to the Web, this seminar is for you.

This seminar is long (over five hours) but it's broken up into 30 easily managed lessons of about 8 to 15 minutes each. You can sit down, watch a lesson, review the material, test the code out yourself, and experiment. Do a little bit each day. It's long, but it's comprehensive - you won't miss a single step as I've recorded everything from start to finish.

All of the sample database files are available on the Web site. There is also an optional printed (or PDF) handbook you can purchase to go with the course that has full screen shots and source code listings to follow along with - or refer back to afterward.

You can use the information from this seminar to gather data from Web sites, collect data from your own site, keep your Web site information up-to-date, etc. The list goes on, and the sky's the limit. Of course, if you have any questions about whether or not this seminar is for you, please contact me.

 

Pre-Requisites

This is a Developer-Level Seminar. There will be a lot of VBA. It is strongly recommended that you have completed my entire Access Beginner and Expert series. My Developer 1 class is highly recommended so you understand the basics of programming in VBA. If not, at least watch my free Intro to VBA video.

Version

I am using Access 2007 in this seminar. The version of Access that you have doesn't really matter. This will work with anything from Access 2007 up. I use Classic ASP for the web site. That's perfectly fine too. My site still runs on it. I used Expression Web as a web page editor. That's no longer available. I recommend EditPlus now. Also, some of the web sites mentioned in this seminar may no longer be available.

Important Notice: Keep in mind also that this seminar is OK for anyone who has real simple data needs. If you want to get serious about powering your web site with a database, I strongly recommend my Access SQL Server Online Seminar instead.

Enroll Today

Enroll now so that you can watch these lessons, learn with us, post questions, and more.

Questions?

Please feel free to post your questions or comments below. Thanks.

Keywords

microsoft web access, microsoft access web form, microsoft access web based, web based microsoft access, Get Data From the Web into Access, Get Data From the Internet into Microsoft Access, Capture Data From the Web into Microsoft Access, Using Microsoft Access to post data into Web sites, Collecting and Using Data from Your Website Visitors, Publish your Access database online, Setting up an Access Database for Your Web Site, microsoft access real-time stock quotes, microsoft access stock quotes, microsoft access online database, microsoft access online product database, microsoft access online customer database, webbrowser control

 

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

You may want to read these articles from the 599CD News:

5/27/2022Add Anything
5/26/2022List Items Edit Form
5/25/2022Column Colors
5/24/2022Multi-Table Forms
5/23/2022Variables
5/21/2022Access Developer 39
5/21/2022Access Developer 39 Lessons
5/21/2022Access Developer 39
5/21/2022Select Items in Related Table
5/21/2022Clear List Box
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access seminar microsoft web access, microsoft access web form, microsoft access web based, web based microsoft access, Get Data From the Web into Access, Get Data From the Internet into Microsoft Access, Capture Data From the Web into Microsoft Access, U  Page Tag: whatsnew  PermaLink  Microsoft Access Web Sync Seminar