An investment in knowledge
pays the best interest.
-Benjamin Franklin
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
What's New

Click here to be notified
when this page is updated

This page only shows major headlines, new releases, and other significant items. For the latest up-to-date news, be sure to also read our full News Feed
06/06Microsoft Access Expert 29
Access Expert 29 is Part 5 of our Comprehensive Guide to Access Functions. Todays class focuses on Aggregate and Domain Aggregate (Lookup) Functions. You will learn about lots of different functions, such as Sum, Avg, Count, Max, Min, DLookup, DCount, DMax, DSum, and many more. Weve briefly covered some of these functions in previous classes, but only a little bit. Todays class dives deep into this very important topic. You will learn: - Aggregate Functions - Sum, Avg, Count, Max, Min, [more...]
02/05Asset Management Seminar Part 1
In the Microsoft Access Asset Management Seminar, Part 1 you will learn how to build a database to manage your assets. You will learn how to create grouped assets (with unlimited grouping levels), track locations, owners, values, and keep a complete log of changes to the assets history. - Develop proper asset management tables, queries, and forms - Create asset groupings (unlimited parent / child relationships) - Track asset owner, location, condition, values, serial number, more. - [more...]
01/20Access Advanced DateTime Seminar
In the Access Advanced DateTime Seminar, you will learn how to count the number of work days between two dates, determine if a date is a week day or a weekend day, calculate holidays, time stamp edited records, use event timers in your database to create popup notifications for reminders, generate recurring appointments, and calculate the number of a particular weekday (Friday) in any period (January). Topics include: - Calculate Work Days Between Two Dates - Duplicate the Excel [more...]
01/19Microsoft Access Expert 28
Access Expert 28 is Part 4 of our Comprehensive Guide to Access Functions. Todays class is part 2 of our focus on Date/Time Functions. You will learn about many new functions including WeekDay, DateAdd, DateDiff, DateSerial, DatePart, and more. Topics include: - Date/Time Functions Part 2 - Break Apart Dates with Day, Month, Year - Calculate Day of the Week with WeekDay - DateAdd - Whats 2 months from today? - DateDiff - How long until loan paid? - DatePart - Is order from last quarter? [more...]
01/02Microsoft Access Expert 27
Access Expert 27 is Part 3 of our Comprehensive Guide to Access Functions. Todays class is part 1 of our focus on Date/Time Functions. You will learn some additional tricks with the Date, Time, Now, and Format functions. We will build an Aged Accounts Receivable, and we will learn more about date/time math operations. Topics include: - Date/Time Functions Part 1 of 2 - More with Now, Date, Time Functions - Query Data in a Variety of Date Ranges - Date & Time Mathematics - Two Digit Year [more...]
11/24Access Open Other Programs Seminar
Have you ever wanted to build a database to store an unlimited number of documents or other file attachments with each record? Perhaps youd like to double-click on any of those files and have them automatically open up in the appropriate program? Open a Word document representing the employees resume, or automatically have an Excel spreadsheet open up for the clients purchase order. Perhaps youd like to click on a button next to the customers address and have your web browser open up directly [more...]
11/10Microsoft Access Expert 26
Access Expert 26 is Part 2 of our Comprehensive Guide to Access Functions. In todays class we will focus on Math and Type Conversion Functions. You will learn a bunch of new functions, and new tricks with some of the functions weve covered before. You will learn multiple functions for properly rounding numbers, use trigonometry to calculate the height of a building, display random customer records, build a dice roller, and much more. Topics include: - Math Functions - Abs, Sgn, Round, Int, [more...]
09/21Microsoft Access Expert 25
Microsoft Access Expert Level 25 is 1 hour, 33 minutes long. This is the first class in my Comprehensive Guide to Access Functions series. You will learn a bunch of NEW functions, and new tricks with some of the functions weve covered before. You will learn how to separate first, last, and middle names from a full name field, calculate overtime pay, and lots more. Topics include: - String Functions - Left, Right, Mid, InStr, InStrRev, Len - LCase, UCase, Trim, RTrim, LTrim - Replace, [more...]
07/16Microsoft Access Expert 24
Microsoft Access Expert Level 24 is 1 hour, 33 minutes long. In this class 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 [more...]
07/03Microsoft Access Expert 23
Microsoft Access Expert Level 23 is 1 hour, 40 minutes long. In this class we will build a database for remote data entry. This will allow our sales reps or service technicians to add contact records on the road. We will learn how to import bank transaction data. We will learn about multi-field composite keys, and how to transfer related tables using XML data. Topics include: - Remote Data Entry Database - View Info, Add Contacts Remotely - Synchronize With Main Server - Import Bank [more...]


  See our full News Feed  

Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
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