Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
 
 

< Previous: Access Expert 23

Next: Access Expert 25 >

Access Expert Level 24

Expert Microsoft Access Tutorial - 1 Hour, 33 Minutes
 
 
In Access Expert 24 we will learn how to import real-time data from web sites using their RSS feeds. We will display current news and weather conditions. Then, we will learn how to share our Access data with others over the Internet by setting up an inexpensive and easy-to-use online SQL Server database that will host our tables. Topics include:
 
  - Import RSS Feed Data
  - Download Latest News from Web Sites
  - Display Current Weather Conditions

  - Use the WebBrowser Control
  - Display Images from a Web Page
  - Program Timer Events
  - Launch a Macro at Timed Intervals
  -
Setup Online SQL Server Database

  - Create ODBC Connections & DSN Files
  -
Share Access Data via the Internet

Order Now

If you would like a preview of what's covered in this class,
click here to watch the first and last lessons of this course (free of charge), or scroll down for more information.




 

Access Expert Level 24
Description: Access Expert Level 24
Versions: Recorded with Access 2013. Most of the material should work with 2007 and 2010 but I'm not absolutely positive. These lessons definitely will not all work with Access 2003.
Pre-Requisites: Access Expert Level 23 strongly recommended. This class builds on the import/export topics covered in the last couple of classes.
Running Time: 1 Hour, 33 Minutes
Cost: $26.99


Today we will begin by importing RSS feed data from web sites. This allows you to pull in any data that the web site decides to share, and that can include current events, news, weather conditions, blog posts, etc. Many popular web sites offer RSS feed (news feed) data via XML files that you can find by searching their site. Look for the RSS logo:

rss feed logo

 

We will pull in the Latest News feed from MSNBC.com and the Tech News feed from CNN.com. Once you have it imported into your database, you can do whatever you like with it. These lessons will show you how to import it.

Next, we will learn how to display current weather conditions using the same technique. There are a couple of free weather feeds out there, including Weather.com, but if you want the best (free) source of weather data, you need to use Weather Underground. I'll show you how to register for a free API key (so you can use their site) and pull down all of the weather data you can imagine.

current weather conditions

 

We'll make a button that you can click once to update the data, and you'll learn how to use a form event timer to have the data automatically refresh itself every couple of minutes. We'll also use the WebBrowser control in an Access form so we can display a picture from their web site (the little logo for the current weather conditions).

weather form webbrowser control event timer

 

Finally, we'll cover one of the most requested topics that people email me about: how to share your Access data with people over the Internet. Everyone wants to know how to take your Access database, upload the tables to the Web somehow, and then share the database with others in different locations. I will show you how to set up an SQL Server database on a web server. I will use GoDaddy for this. They are my ISP and I've been with them for about 5 years right now (it's currently July 2014). As of the time of this class, you can get web hosting with unlimited SQL Server databases for about $5 per month, so it's an easy, inexpensive solution if you want to share data.

sql server access

 

I will show you how to configure the SQL Server database on GoDaddy's site (most other ISPs that I've worked with are very similar). We will then connect to the database from our Access application, upload our tables, delete the local tables, and then link to the tables on the SQL Server. Once that's done, you can then share your Access front-end file with anyone you want (and trust) and they can use your data. You can both share information no matter where you are. It's a quick-and-dirty way to allow remote access to your data via an Access database.

linked sql server tables

 

This is the 24th class in the Access Expert series. There are a lot of highly-requested topics in this class: importing live data from the web, using the WebBrowser control, launching timer events, and sharing your Access data over the Internet. Of course, if you have any questions about whether or not this class is for you, please contact me.
 

 

Complete Outline - Access Expert Level 24

00. Intro (9:47)

01. Import RSS Feed Data (14:21)
Pull News from Web Site
RSS Feeds are XML Files
Really Simple Syndication
Get the 599CD News Feed
External Data > Import XML
ImportErrors Table
Channel and Item Tables
GUID: Globally Unique Identifier
Field truncation
Can't Save Import Steps if Error
Import Latest News from MSNBC.com
Import Tech News from CNN.com


02. Import Real-Time Weather (14:02)
How to find an RSS Feed not advertised
Weather.com RSS Feeds
Weather Underground API
Register for an API key
Import Weather XML Feed
03. Display Real-Time Weather (20:56)
Convert RFC822 to Access DateTime Value
Query Sorted by Observation Date
Form to Display Current Conditions
Button to Run Macro for Import
RunSavedImportExport
Requery Form Data
WebBrowser Control
Display Images from a Web Site
Event Timer
Timer Interval
On Timer Event

04. Online SQL Server Database (28:39)
Share Access Data via Web Server
Use Access Front End, SQL Tables
Set up SQL Server DB on GoDaddy
Database Friendly Name
Username and Password
Export to ODBC Database
File Data Source
Machine Data Source
User Data Source
Create New Data Source > SQL Server
Set up a File DSN
Complete Export of CustomerT
Link to the CustomerT on SQL Server

05. Review (5:47)

 


 
Keywords: Import RSS Feeds from Web Sites, Display Real-Time Weather, Share Data with SQL Server Online Database, microsoft access tutorial, microsoft access tutorial, microsoft access training, access 2007, access 2010, access 2013, Pull Data from News Feed, Import XML Web Data, Get News from MSNBC and CNN, Weather Underground, RunSavedImportExport, WebBrowser Control, On Timer Interval, Timer Event, Share Access Data via Web, SQL Server on GoDaddy, ODBC Database, DSN Data Source Name
 

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

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP