Making a duplicate copy of a table in ACCESS 2000

Question

I created a database of books in a private library as it was being organized. Thus, many of the books turned out to be duplicate copies, which I noted in a field "Notes" along with other extraneous info that turned up. The duplicate books were culled and stored elsewhere. I managed to create a copy of the database, that contained just the duplicated books (or most of them) to use when consolidating these duplicate books at a later time. I have now gotten the multiple copies together in specific locations and entered this data into the original table, but would like to create a new table of just these duplicate books. I can't remember how I did it. Export doesn't work, as it wants the database file already created. Query/report doesn't suit, as I want to be able to add information into the records. Re-entering the data into the copy I created previously seems to defeat the purpose of having the database in the first place.

Did I miss something in the use of a database that would have allowed this?  Can I rectify it at this point? Or can someone help me to remember how I did the copy in the first place?

Answer 1

 Is that the menu? If, so, which one, where?  I have tried this several times, with and without wizard and see no opportunity to do any of the things you mention.  Maybe Access 2000 doesn't do it, but later versions do?

Use the steps depicted below --

Answer 2

Karl:

Thanks every so much for the effort. Unfortunately, ACCESS 2000 doesn't look anything like your pretty pictures and I can't find that concept anywhere in the limited menus available to me..   Yes, I realize I should update.  For the limited use I give it, I'm not sure it's worth it, as surely by now I'd have to buy it anew, not having updated as we went along.

Twas ever thus.

Thanks again,

J.

Answer 3

If you are in design view and click on the floppy icon it will prompt for a file name.