In my upcoming book, Your First Guide to Database Design, my goal is to provide a clear guide for users at all levels of experience on how to organize their data into an efficient database, regardless of whether they’re using a desktop database like Microsoft Access or a network software such as MySQL. The first chapter…
All posts in Database Design
Removing Duplicate Records in Microsoft Access
Occasionally, you might have a table in Access that contains duplicate records. Maybe it was imported from one or more sources or perhaps it was not setup with the necessary key to ensure unique records. Whatever the reason, now you want to make sure that the records in the table are unique. Fortunately, Access offers…
Data Analysis with Microsoft Access
One of the strengths of Access is its ability to import and link to data from different sources. Excel does this too but with Access you can go on to query and report on the data in ways that Excel doesn’t readily provide. This can come in handy as part of an application but it’s…