I have now completed all your training throught Access 2013 Advanced Level 6. Love your presentation method and while at first thought things were moving too slow I now see why and feel the pace is excellent. Today I puchased 7-10. In which lesson will I see; How to move the sums found in my querries to a report, How to combine data from different forms, querries and reports to a singular leadership summary, Finally How to set up the database for users so they only see the Control/master form when they open the database? BTW the reviews you throw in...keep them in there. :-)

---

Reply from Richard Rost:

Thanks for the compliments. I assume you mean EXPERT Level 6, since the ADVANCED series is still in production.

Moving SUMS from a query to a report: calculated fields show up as regular fields when you bring them into a report. Just base the report off of that query and there's your data.

Combine data from different forms: what do you mean? You can show values from another open form with the notation I taught you: =Forms!CustomerF!FirstName

What's a "singular leadership summary?"

I cover hiding the Navigation Pane and showing only your Main Menu in Access Expert 7 (which you will soon discover). That will be good enough to hide those objects from MOST users. However if you REALLY want to lock down and secure your database against everyone (except me, of course, ha ha) then you need to use some programming techniques that I cover in my Access Security Seminar.