One of the primary benefits of using Microsoft Access is having the ability to pull data regardless of where it is saved within the database, especially if it is spread over half a dozen tables.
After making tweaks and changes to a query, it can be difficult to remember exactly what changes pulled which results. This is one very good reason to get accustomed to saving queries with some frequency, even if they don’t provide exactly what the user is looking for at the time.
Access offers users a way to print queries and their results. This provides users with a way to later review the results if they cannot remember which query was used.
Tables can be indexed, giving the user the power to execute sorts and finds in a manner that is faster and more efficient for fields that are frequently searched
Microsoft Access 2013 includes filters that pull specific information instead of users having to muddle through countless records.
Copying, renaming and deleting tables in Microsoft Access often causes confusion for database administrators. In this article, we clarify the differences between the three operations and explain how to perform each.