Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
Is there a way to do this for reports?
Cleaning Up an Access Database for the first timer
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Ok, I'm hoping someone on here can provide me with a go to directions or simply give me some simple instructions on how to clean up an Access database. I have a database that has been used for around 8 years and I've deleted small things, but it's getting way to lost in all the tables, quries and reports. I know I don't use many of them anymore, some only being done for a one time info needed project. It's a little overwhelming looking at all the info and trying to start weeding through.....is there an easier way? Like to see exactly what all is linked together? Or some report of showing dates of last time used? Any suggestions would helpful. It's my first time trying to clean up an Access database.
Microsoft 365 and Office | Access | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
3 answers
Sort by: Most helpful
-
Anonymous
2015-08-31T15:37:54+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
ScottGem 68,810 Reputation points Volunteer Moderator2015-08-31T15:26:34+00:00 You can use the Object Dependencies function on the Database Tools ribbon. This can tell you what objects are dependent or depend on the object. Then you can decide whether its in use anymore.
Other than that you know your database better than we do.
-
Anonymous
2015-08-31T15:39:13+00:00 Oh, never mind I see. I had tried it already and just went back. I had to change the objects that depend on me to objects that I depend on. Thanks for your help.