List Only

How do I create a seperate list in Microsoft Access that contains data from my original database?

I have a database with information about books. I need to create a list containing only the title and author of books from a certain country. Can I create a list that just links the information, or do I have to copt and paste what I want? I used the wizard and entered the fields I wanted but I don't know how to link the information from one to the other? Any help is good.

Public Comments

1. You want to link from a NEW database to the ORIGINAL? Click on File/Get External Data. Select either Import... or Link Tables... Navigate to the original database, double click on it. Click on Tables, select the table or tables you wish to link or import. Click OK. Now you can create a query that filters on Country. If you want to create a new table, make the query a Create Table query.
2. create a query in Access from the original database. for example: select title, author from <tablename> where country = 'USA' then just run this query in Access and you'll have your list