This short screencast covers the major reasons why an Access database application is slow. Poor performance is most commonly associated with missing or incorrect table relationships. Other factors that are covered include poor field design, particularly the Field Size property and unnecessary table indexes. Finally, splitting the database into front-end and back-end files is explored.
See all of Professor Lisa Friedrichsen's short screencasts organized at learncs.w3spaces.com