It’s finally here! Your First Guide to Database Design is now available on Amazon.com and BarnesAndNoble.com. Another PDF version will soon be available for purchase on Scribd.com. Your First Guide to Database Design is a clear, easy-to-use guide to relational database design for both beginners and I.T. professionals who need to know how to organize…
All posts in Database Design
On software design …
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…
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…