Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
 
 
Microsoft Access Expert 15
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   8 years ago

Microsoft Access Expert Level 15 is 1 hour, 57 minutes long. This tutorial will continue our focus on Append Queries to add data to tables, and we'll begin learning about how to use Delete Queries to delete records from tables. We will learn how to track student attendance in classes, and archive old contacts into a history 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

Click here for more information on Access Expert Level 15, including a course outline, sample videos, and more. This course was recorded using Access 2013, but is also valid for Access 2007 and 2010 users. This class follows Expert Level 14. The next class in the series is Access Expert 16.

AttendanceSubF Upload Images   Link 
Neal Groeling 
14 months ago
Richard,

I am pulling out my hair! I can not get the AttendanceSubF to work. I have followed the video to the "T" several times, even going all the way back to Expert 14 and starting all over with the Attendance lessons. The AttendanceSubF, residing in the AttendanceF doesn't seem to know where to pull any information from. I have set the record source to AttendanceQ, and have even rebuilt that query several times. Can you point me in the right direction? In addition, because AttendanceF is unbound there are no "link Master/Child fields." -- is that correct?
Richard Rost
14 months ago
I'd really have to see your database to tell you where the problem is. That lesson was recorded in 2013, so it's been about 7 years since I made that database. In that time nobody else has complained about this problem, so it's got to be something in your database. Without seeing it, I really can't say what's wrong. Make sure you've got everything spelled right.
Richard Rost
14 months ago
I remember while I was recording it I spelled "Attendence" wrong a few times. LOL
Add a Reply
Hard To Follow Upload Images   Link 
Michael Larsen 
5 years ago
Hi Richard

I am sorry to have to tell you that this class, in my view, appears messy.
You change your mind several times and it makes it hard to follow your train of thought.
Please make a plan ahead of recording and stick to it.
Add a Reply
Greetings Expert 15 Lesson 1 ClasXCustomerSubF Upload Images   Link 
Tim Florio 
5 years ago
Greetings, Expert 15, Lesson 1, ClasXCustomerSubF, CustomerID Combo Box. I followed the steps in the video when creating the combo box, deleted it two times, remade it three times and in fact went back through the entire lesson to double check everything looking for a mistake. The issue; the subject combo displays the CustomerID instead of NewName. If I hit the drop down arrow it displays the NewName but when I click on it only the CustomerID is displayed again. I hid the CustomerID column when built the combo box so that's even more confusing. Everything on both forms appear to work with the exception of the subject combo box. Read More...
Add a Reply
The CustomerID field in the ClassXCustomerT Upload Images   Link 
Katheryn Hartig 
5 years ago
The CustomerID field in the ClassXCustomerT technically should be type Number. I get that in this example it doesn't really matter as long as you only put numbers in the field but just thought I'd let you know. Read More...
Add a Reply
Date Choice Upload Images   Link 
vicki H 
6 years ago
I changed the DateTime default value in AttendanceT to =Date() as opposed to =Now() and it asked to update 2 queries and I said yes and that fixed it.  Your just awesome Alex! Made me think about it :-) Read More...
Add a Reply
Date Choice Upload Images   Link 
vicki Hudson 
6 years ago
Where did I go wrong?  When I change the date in the ClassF to a date I know I have no Students then click on Attendance button, In my AttendanceF the Student names are all there and the same "Present" boxes checked. Read More...
Add a Reply
Sharepoint Upload Images   Link 
GeorGE jOHNSON 
6 years ago
I'm looking to upload my database to Sharepoint where it can be used by other staff.  Which course is best to teach me how to do this?


Reply from Alex Hedley:

There hasn't been a course yet but you can vote for it on the Waiting List Read More...
Add a Reply
Multi-Valued Field Upload Images   Link 
Frank Fish 
7 years ago
Richard, I created copies of the tables as explained in the lesson.(CopyOfContactsT; ArchiveCopyOfContactsT)I created a query that would select all records in the "Active" field (true/false)that were not active (false). when I ran the query it showed the (7)records. I then followed your instructions to append those records to the archive table; when I ran it I got this error: "SELECT* cannot be used in an INSERT INTO query when the source or destination table contains a multi-valued field." Read More...
Add a Reply
can i have the tutorial video of this access 2013 Upload Images   Link 
David 
7 years ago
can i have the tutorial video of this access 2013 expert 15? the project that my prof gave me is exactly like this please help me. may completion due is nearer. hoping for your help.


Reply from Rick Rost: Read More...
Add a Reply
modal popup lockup Upload Images   Link 
Lynda Chase 
7 years ago
Hi Richard

It seems when I make the attendanceF modal and popup, it causes access to freeze up. so when I go to classF and click on the attendance button, a bell sounds, and then I have to shut down access and reopen.  This also happened with an earlier class where modal and pop up were switched on.  If I turn them off, it all functions perfectly - is this a glitch with my access, or with me? :o) Read More...
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

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

9/17/2021Overlapping Windows
9/16/2021Inventory
9/10/2021Benefits of Access
9/10/2021Access on a Phone
9/5/2021Prevent Deletion
9/4/2021Booklet Template
9/4/2021Inspections Template
8/29/2021What is Microsoft Access?
8/27/2021Union Query
8/24/2021Navigation
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access expert 15 append query delete query student attendance archive contacts  Page Tag: whatsnew  PermaLink