Topics
Content Types
About 98 results
-
Use Access validation rules to ensure accurate data entry
Your Access database is only as sound as the data it stores. Data types can only do so much. The next step is to constrain input values using validation rules.
-
The 10 most important things to teach your Access users
Access is a powerful tool -- and for many users, it's a confusing one. This list of basic concepts will help them develop their database skills.
-
How to add a graphic to an Access label report
A graphic to a label can add information or just a bit of fun to an Access database and it doesn't require any special expertise.
-
10 questions to ask before upgrading from Access to SQL Server
Upgrading to SQL Server might make sense for some of your clients, but it could be a bad idea for others. These questions will help them make the right call.
-
Office challenge: Can you troubleshoot this database error?
This week, troubleshoot a mysterious and troublesome error after what should've been a quick and easy enhancement goes sour.
-
10 mistakes to avoid when designing Access objects
There are lots of false assumptions floating around the world of Access development. Susan Harkins has rounded up some of the worst object design mistakes that developers make -- a...
-
How to work with rich text in Access 2007 and 2010
True rich text wasn't supported in Access 2003 (and earlier versions). Access 2007 and 2010 both support rich text and it's easy to implement.
-
10 easy ways to speed up an Access database
Even your least technical Access users can improve the performance of their databases. Susan Harkins shares some basic tips those users can put to work right away.
-
Grouping dates in Access by date components
You don't need a complex set of expressions or even VBA to sort Access date values by specific components, such as month or year. Use DatePart() and sort on its results.
-
Five tips for teaching database concepts to clueless users
Investing a little time in helping your users understand database fundamentals will make them more productive and self-reliant. Their understanding and insights may even help you i...