-
Advanced Microsoft Access Workshop 7-20-2013
Below is the link to the Access database file developed in class: Advanced Access 7-20-2013 It has been provided so you can review Make Table query, Append query, Update query, Crosstab query, Delete query, Union query, basic SQL manipulation, and the Expression Builder.
-
Intermediate Access 7-13-2013 forms (subforms), reports, macros
It was a nice working with the group on Saturday July 13. Below is a copy of the database developed during the workshop. You can use it to practice and review the activities covered in class. Creating a one to many relationship Creating a form Creating a form with a subform Creating a report Adding…
-
Introduction to Access 6-29-2013
Below is a link to the database developed in class. Introduction to Access 6-29-2013 To access the database, download the zip file and then right click that “zip” file to extract it. You can use this file to review: Tables Queries Reports
-
Advanced Excel 6-22-2013
Below are links to the three files developed in the advanced excel class: Advanced Excel 6-22-2013 vehicle, shoes, grade book Advanced Excel 6-22-2013 scuba ratings in pivot table Advanced Excel 6-22-2013 links They have been provided to review the work done in class. Recording a Macro Review vlookup Summarizing data with Pivot Tables Links using…
-
Intermediate Excel (6-15-2013)
Below is a copy of the worksheet developed during Saturday’s 6/15/2013 workshop. You can use it to review the activities covered in class: vlookup, pivot table, sorting, name range, conditional formatting and filtering. The group did a nice job! Intermediate Excel 6-15-2013
-
Advanced Microsoft Access 2010 (5-4-2013)
Below is the link to the Access database file developed in class: Advanced Access 5-4-2013 It has been provided so you can practice the exercises with setting up relationships, designing a database, using SQL to create a union query, creating subforms, and to review the report tool.
-
Advanced Excel 5-5-2013
Below are two files developed in the second class. advanced excel 5-5-2013 macro and what if analysis advanced excel 5-5-2013 various examples They have been provided to review the work done in class. Recording a Macro Review vlookup What if analysis pmt( ) function
-
Advanced Excel 4-28-2013
Below is the file developed in class. Advanced Excel 4-28-2013 It has been provided so you can practice the exercises done in class: Working with a pivot table Showing details Using name ranges Grouping Filtering pivot table results Interpreting pivot table results Nested functions Shortcuts Linking worksheets Pasting name range Refreshing pivot table and chart…
-
Advanced Microsoft Access 2010 (4-27-2013)
Below is the link to the Access database file developed in class: IceCreamHeaven 4-27-2013 (Small business Ice Cream Store Staff) It has been provided so you can practice the exercises with update, make table, and append queries. I look forward to seeing you all in the next class!
-
Intermediate Excel 4-21-2013
It was nice working with the group on Sunday April 21th. Below is a copy of the worksheet developed during the workshop. You can use it to practice and review the activities covered in class: vlookup, pivot table, sorting, and filtering. Intermediate Excel 4-21-2013
-
Intermediate Access 4-13-13 (Movies)
It was nice working with the group on Saturday April 13th. Below is a copy of the database developed during the workshop. You can use it to practice and review the activities covered in class. Intermediate Access 4-13-13
-
Intermediate Excel 4-14-2013 (Scuba Diving)
It was nice working with the group on Sunday April 14th. Below is a copy of the worksheet developed during the workshop. You can use it to practice and review the activities covered in class. Intermediate Excel 4-14-2013
-
Intermediate Access 4-6-13
Below is the link to the “Movie List” database developed in class. It has been provided so you can practice the activities done in class. It contains tables, a report, a data form, and macros developed in class. To access the database: Download the zip file below. Open the folder containing the zip file from…
-
Advanced Excel 4-7-2013
Below is the link to the file developed in class: Advanced Excel 4-7-2013 It has been provided so you can practice the exercises done in class. It contains macros, a pivot table, and a custom Excel function created with VBA.
-
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.
