Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  

< Previous: Access Expert 14

Next: Access Expert 16 >

Access Expert Level 15

Expert Microsoft Access Tutorial - 1 Hour, 57 Minutes
This Microsoft Access video tutorial picks up where Expert Level 14 left off. In this class we will continue to learn how to use Append Queries to add data to tables, and Delete Queries to delete records from a table. Topics include:
  - Track Student Attendance
  - Put Customers / Students in Classes
  - Create a Daily Attendance Form
  - Use a Macro to Run Append Query
  - Disable System Warnings
  - Enable All Macro Actions
  - Attendance Reports by Student / Date
  - Delete Queries
Archive Old Customer Contacts

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 15
Description: Access Expert Level 15
Versions: This class was recorded with Microsoft Access 2013. The material is valid for Access 2007 up to 2021. Access has not changed that much over the years.
Pre-Requisites: Access Expert Level 14 strongly recommended
Running Time: 1 Hour, 57 Minutes
Cost: $25.99

This class picks up where Expert Level 14 left off. In Level 14 we started learning about Append Queries. In today's class we will learn two more great examples of when to use Append Queries. First, we'll begin with a very popular request: tracking student attendance. We'll set up a list of classes, and put students into those classes.


Next, we'll create the student attendance table and a form for entering daily attendance. Then, we'll create an Append Query that will take all of the students and add them to the current day's attendance automatically. We'll put a command button with an embedded macro on the attendance form to run this query, turning off all system warnings (temporarily) and then requery the form results. Now, all the instructor has to do is check the box indicating which students are absent.


We will create a button on the Class form so that the instructor can take attendance for ANY date. This way if he forgot to take attendance yesterday, or perhaps wrote it down on paper, he can go back and enter results from other days. We'll also set up a couple of attendance reports.


The first report shows each class, grouped by DATE, sorted by student. This allows you to easily see who was absent from each class on each date.


The next report is similar, but is grouped by STUDENT, so you can enter a range of dates and see how many days that student was absent in that date range.


Next we'll learn about Delete Queries. Use can use Delete Queries to remove data (delete records) from a table. They're very dangerous so make sure to back up your tables first. We will create an Append Query to copy old customer contacts from the Contact Table to a Contact Archive Table, and then we'll Delete them from the Contact Table.


This is the 15th class in the Access Expert series. There's a lot of great material in this class. Learning Action Queries will add tremendous power to your databases. Of course, if you have any questions about whether or not this class is for you, please contact me.


Complete Outline - Access Expert Level 15

00. Introduction (8:27)

01. Student Attendance 1 (20:12)
Types of Different Classes
Individual Class Sessions
ClassQ with Type Name
Track Customers in Each Class
Class Form with Enrollment Subform
Add Multiple Students to Class
Each Company Sends Multiple Students

02. Student Attendance 2 (31:12)
Create Attendance Table
Master Attendance Form
Student Subform
Modal Popup
Default Values from Other Forms
AttendanceQ With Supporting Data
Left Joins
Create Attendance Subform
Data Entry Property
Attendance Append Query
Add Static Date Value to Append Query
CDate Function
03. Student Attendance 3 (34:59)
Create Button to Run Append Query
SetWarnings OFF
Turn on Potentially Unsafe Actions
Show All Actions
Short Date Format for Date Picker
Show Attendance for Any Date
Attendance Report By Class By Date
Sorting & Grouping
Attendance Report by Student then Date

04. Contact Archive (15:37)
Backup Contact Table
Create Contact Archive Table
Remove Indexing Primary Key from Archive
Change AutoNumbers to Numbers

05. Review (6:31)


Keywords: Append, Delete Queries, Student Attendance, microsoft access tutorial, microsoft access tutorial, microsoft access training, access 2007, access 2010, access 2013, students, classes, cdate function, modal, popup, left join, setwarnings, show all actions, requery


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 7/25/2024 1:06:52 PM. PLT: 0s