I am familiar with Access 2010 except have no experience with Macros. If I could get a sample explanation for what I wish to do, I believe I could manage getting it done. Here is what I wish to do:
I have a table in a database that is quite large, 600K+ records. I wish to create a "query form" that will allow me to enter the search key, for example, the "last name". Then populate the form with the query results of selected fields from this rather large table, such as last name, first name, address, state, zip, etc. Once the data is examined on the form, I wish to have a "button" with a macro attached to it that would allow only these fields on the query form to be inserted into a separate table.
The overall objective is to take paper sheets with names that I wish to find in the database table, if found, I wish to write out these fields to another table. This is a huge table with about a hundred fields, all I want are the fields I mentioned, and once found, create an entry of this limited data to another table.
This should be easy. I have never done this in access.