Student Grades in Microsoft Access: Proper Data Entry, Spreadsheet-Like View, Part 3

In this Microsoft Access tutorial, I will show you how to create a spreadsheet-like view for student grades using crosstab queries. We will go through setting up the crosstab query, adding student and assignment names, and making the view more user-friendly. This is part 3.

Silver Members & up get access to an Extended Cut of this video. In the extended cut, I will show you how to make an editable crosstab form using VBA, temporary tables, and additional SQL. This allows for interactive data entry directly within the crosstab view, despite its usual read-only limitation.

MEMBERS-ONLY EXTENDED CUT VIDEO:

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

LINKS:

RECOMMENDED COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Editable Crosstab Form, Student Grades in Microsoft Access, Data Entry in Access, Spreadsheet View in Access, Creating Crosstab Queries, Access Crosstab Query Tutorial, Microsoft Access Gradebook, Joining Tables in Access, Assignment Grades in Access, Automated Grade Tracking Access, Student Form Navigation, Access Junction Table

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[AH_World_bh]

I watched all three videos, thanks for sharing

[Shadow.Dragon]

Richard, thanks for the great series!

[BrockLivingston-ou]

Greetings Richard, I really enjoy your videos. I have a suggestion that would not require "training" for the user. For both the student and assignment fields use the "Display as Hyperlink" property (this will underline the text in the field and turn it blue (just like a website). Then instead of the "Double Click" event use the same code you showed in the "Click" event. You will get the same functionality without having to use special colors to denote an additional function. I know, from watching your videos, that you do not like hyperlinks, but this is not a hyperlink only the user won't know that. Again, thank for all you do and Live Long and Prosper.