Computer Learning Zone

Microsoft Access Reports Running Slow? Here's What You're Missing - QQ 90


Listen Later

In Quick Queries episode #90, we address several practical Microsoft Access topics including why Access Reports might run slow and ways to speed them up, password and pass phrase strategies, considerations for 32-bit versus 64-bit Access, best practices for importing Excel data, handling date formatting, the importance of table normalization, and moving Access queries to SQL Server. We will also discuss the benefits of select case versus if then statements in VBA, handling composite keys with nulls, and the value of clear documentation for Access projects. Several questions from users are answered with practical advice and real-world examples.

...more
View all episodesView all episodes
Download on the App Store

Computer Learning ZoneBy Richard Rost