Microsoft Office Professional ships with the MS Access database application that lets you analyse and manage large amounts of data better than say an Excel spreadsheet. Sometimes, the information stored in various tables becomes fragmented causing duplication and at some point will need to be cleaned up. This is where distinct queries can help. Since a query asks questions to the database tables, it can also control how the information will be displayed in the output and that also includes […]

Tags: create an access database, creating an access query, distinct access query, distinct queries, how to build queries, unique and distinct in sql