-
Introduction to Microsoft Access 2010 (3-16-2013)
I am pleased to announce that below is the link to the “Summer List” database developed in class. It has been provided so you can practice the activities done in class. It contains tables, queries, a crosstab query, report, and data imported from Excel. To access the database: Download the zip file below. Open the…
-
Advanced Microsoft Excel 2010 (3-17-2013)
I am pleased to announce below is the link to the “30 Year Interest Rate” file developed in class: Advanced Excel 3-17-2013 It has been provided so you can practice the exercises done in class. It contains macros, a pivot table, conditional formatting, date and conditional functions.
-
Intermediate-Excel-03-10-2013 (Party List)
It was nice working with the group today. Below is a copy of the database developed during the workshop. You can use it to practice the activities done in class. Intermediate-Excel-03-10-2013
-
Introduction to Access 3-9-13 Summer List
It was a pleasure working with the group. Below is a copy of the database developed during the workshop to practice the activities done in class. To access the database: Download the zip file below. Open the folder containing the zip file from the previous step. Right click that zip file to extract it. Once…
-
Intermediate Excel 03-03-2013, day 1 of 2
I am pleased to announce that below is the link to the workbook that was developed in the workshop today, 3/3/2013. Intermediate Excel 03-03-2013 It has been provided so you can practice the features covered in class. I am looking forward to our next class!
-
Advanced Microsoft Access 2010 (12-1-2012)
I am pleased to announce below is the link to the Access database file developed in class: Advanced Access 12-01-2012 (vacation list and union query) It has been provided so you can practice the exercises done in class.
-
Advanced Microsoft Excel 2010 (12-2-2012)
I am pleased to announce below is the link to the “Baseball Stats” file developed in class: Advanced Excel 12-2-2012 It has been provided so you can practice the exercises done in class.
-
Advanced Access 12-1-2012 (Day 2 of 2 “Vacation List database”)
Objective: Show all columns and rows from a table. SQL Example 1: Start with the basic example below. Select * From T01_VacationList Objective: Filter rows and show all columns. SQL Example 2: Filter and show all columns. Also use “V” to write SQL code more compactly. Select * From T01_VacationList as V Where V.Category =…
-
Intermediate Microsoft Excel (11-18-2012)
I am pleased to announce that below is the spreadsheet developed in class: Intermediate Excel 11-18-2012 It has been provided so you can review the activities done in class.
-
Advanced Microsoft Access (11-17-2012)
I am pleased to announce that below is the link to the “Course Coordination Application” project developed in class today Saturday 11/17/2012. Course Coordination Application (11-17-2012) It has been provided so you can practice the activities covered in day 1 of 2.
-
Learning Activity: “Course Coordination Application Project”
The instructor will guide the registered student with questions and encourage the student to be an active participant in their learning. The instructor will use the student’s prior knowledge (from Introduction to Microsoft Access and Intermediate Microsoft Access) and encourage the student to use all available resources first. The student is encouraged to write down…
-
Intermediate Microsoft Access 2010 (10-28-2012)
I am pleased to announce below is the link to the two database projects developed in class: Intermediate Access 10-28-2012 (two databases) It has been provided so you can practice the activities done in class.
-
Advanced Microsoft Excel 2010 (11-10-2012) – Day 2 of 2
I am pleased to announce below are the links to the files developed in class during “Day 2 of 2”: Advanced-Excel 11-10-2012-a (day 2 of 2) Advanced-Excel 11-10-2012-b (day 2 of 2) Advanced Excel 11-10-2012 custom function and two macros (day 2 of 2) They have been provided so you can practice the exercises done…
-
Advanced Microsoft Excel 2010 (10-27-2012) – Day 1 of 2
It was nice working with everyone in the Continuing Education workshop. Below are the links to the files developed in class: Advanced Excel 10-27-2012 a Advanced Excel 10-27-2012 b custom function It has been provided so you can practice the exercises done in class.
-
Introduction to Access 10-21-2012
It was a pleasure working with a very motivated group. I am excited to know that participants have requested a copy of the tables and queries developed during the workshop. To access the databases, you will need to download the zip file below: “Introduction to Access 10-21-2012 (two Access files)” and then right click that…
-
Advanced Microsoft Excel 2010 for Windows workshop (7-29-2012)
It was nice working with everyone in the Continuing Education workshop. Here is the link to the file we developed in class: Advanced Excel 7-29-2012. It has been provided so you can practice the materials created in class.
-
Intermediate Access 7-22-2012
I am pleased to announce the reports, forms, macros, and relationship exercises developed during the workshop are attached. To access the databases, you will need to download the zip file: Intermediate Access 7-22-2012.zip and then right click that zip file to extract it. Click the link below to access the review materials: Intermediate Access 7-22-2012
-
Introduction to Access 7-8-2012
It was a pleasure working with a very enthusiastic group today. I am excited to know many participants have inquired about the tables and queries developed during the workshop. Attached are the two databases. To access the databases, you will need to download the zip file: Introduction to Access 7-8-2012.zip and then right click that…
-
The vlookup function
The vlookup function searches for the value in the left-most column of a table. The vlookup function pulls information from a table (i.e. Name Range). It enables the user to find relevant information systematically.
-
Intermediate Excel 6-10-2012 for Windows workshop
Below is the link to the workbook that was developed in the workshop. It has been provided so you can practice the features developed in class. Intermediate Excel 6-10-2012
