A department at my office uses an old MS-Works database. The employees there like it because it is simple to use. I designed a database in MS-Access (2000) that essentially works the same and is easy to use (which is what they want and need).
The one problem I have which works better in Works than in Access is that when they are entering customer information in the Works database table (like mailing addresses),if the city is the same for 60 records, they can type the city in the 1st cell, hit copy, highlight the other 59 cells and hit paste. In Access, if you copy one cell, you can only paste to one cell, if you copy 3 cells, you can paste to three cell and so on.
Is there a way to rectify this that will be easy for these employees to use? They could use Excel to enter the information and import it to Access but that would be more hassle for them and they would just rather keep using Works.
Any help or advice would be appreciated.
The one problem I have which works better in Works than in Access is that when they are entering customer information in the Works database table (like mailing addresses),if the city is the same for 60 records, they can type the city in the 1st cell, hit copy, highlight the other 59 cells and hit paste. In Access, if you copy one cell, you can only paste to one cell, if you copy 3 cells, you can paste to three cell and so on.
Is there a way to rectify this that will be easy for these employees to use? They could use Excel to enter the information and import it to Access but that would be more hassle for them and they would just rather keep using Works.
Any help or advice would be appreciated.