Forum Discussion
RAC1978
Apr 02, 2024Copper Contributor
Steps to remove certain date range of records in Access
I have a database with about 10 years of records. We only need two years of history in the current database. How can I move the older data but keep in case we need to review? Roberta
RAC1978
Apr 03, 2024Copper Contributor
The database was created many years ago by a former team member who really did not know a lot about relationships or design choices. I could rebuild it, but time is not something I have to do so.
The database takes about 20 seconds to open and land on the Menu. When I click on Relationships Design I see 3 tables, one looks blank because it is link to an Excel spreadsheet for its data.
This database allows our Phone QA person to enter scores when observing phone calls for our Customer Service teams. I believe there are too many tables, queries, reports, etc. that does not mean much, little or improper relationship. She should enter call score data, ensure calculation is returned correctly (this took weeks for me to figure out when scores weren't correctly being outputted).
I consider myself a Novice still after all these years. I need to learn how to create formulas and maybe slowing recreate this tool for her.
Thank you for your insight.
The database takes about 20 seconds to open and land on the Menu. When I click on Relationships Design I see 3 tables, one looks blank because it is link to an Excel spreadsheet for its data.
This database allows our Phone QA person to enter scores when observing phone calls for our Customer Service teams. I believe there are too many tables, queries, reports, etc. that does not mean much, little or improper relationship. She should enter call score data, ensure calculation is returned correctly (this took weeks for me to figure out when scores weren't correctly being outputted).
I consider myself a Novice still after all these years. I need to learn how to create formulas and maybe slowing recreate this tool for her.
Thank you for your insight.
George_Hepworth
Apr 03, 2024Silver Contributor
Okay, thanks.
20 seconds is SLLOOOOOWWWW. Time to refactor/redesign.
Archiving might be an interim, delaying tactic to put that off while you work on redesign.
My first target would be that linked Excel spreadsheet. Probably that is not the most efficient part of the application. How many records in it? How is it created? How is it used? Can it be replaced by an Access table by importing the data from it?
When you open the relationships window, try clicking on "All Relationships". Does that show any additional tables beyond the first three you see?
Can you manually add the other tables? Then take a screenshot for us. That might help in offering ideas on ways to improve it. Might not, but it could help a lot.
- Tom_van_StiphoutApr 03, 2024Steel ContributorWhen you work with Relationships window, also have Navigation Pane open, and drag and drop additional tables that may not show up at first (because they are not related to any others).
A good relationships window should look like this one for Northwind template:
https://support.content.office.net/en-us/media/559a04f2-11b2-44b8-ae4a-92284d1576bd.png- RAC1978Apr 03, 2024Copper ContributorI dragged the other tables in the Relationship window; however, there are no relationships.
I hate that I cannot attach screen shot.- George_HepworthApr 03, 2024Silver Contributor
The lack of designated relationships is predictable, given your description earlier. We can work on that.
You should be able to add screenshots in a couple of ways, but you have to elect to reply this way on the first screen.
..