Microsoft Access Question!

CluelessGirl

Hey!

I now have Microsoft Access on my laptop!:)

I want to make a database.

I have about 10 different Excel lists with columns marked destination/price/volume that I want to import into the database.

I then want to be able to search each list by destination.

For example: If I am looking for Algeria, I can type Algeria into a search box and then the information from the 10 Excel lists will come up on a new sheet.

I have been looking at many of the templates but I am unable to find one that just does this one request.

Any suggestions will be greatly appreciated.

Thanks in advance.

phog

What version of MS Access have you?

I think I know how to do this but to explain it, well here goes, someone else might come our rescue:cool:

Create a database, ignore the template, just creat a database .mdb, create it whereever you need it and call it whatever you like.

You can then import the excel files or link them, linking can be better if you going to make changes to the excel files.

Creat a query (crosstab I think), select all the table that you need the info from link the column names from one table to the next then in criteria list Algeria as in your example.

Clear as mud:o

CluelessGirl

phog wrote: »

What version of MS Access have you?

I think I know how to do this but to explain it, well here goes, someone else might come our rescue:cool:

Create a database, ignore the template, just creat a database .mdb, create it whereever you need it and call it whatever you like.

You can then import the excel files or link them, linking can be better if you going to make changes to the excel files.

Creat a query (crosstab I think), select all the table that you need the info from link the column names from one table to the next then in criteria list Algeria as in your example.

Clear as mud:o

Hey!

Many thanks for the help.

I will give it a go tomorrow. I have looked at all the info you have given me and all the tabs etc.....are on Access.

I will let you know how it goes.

Thanks again for the help.:)

CluelessGirl

phog wrote: »

Creat a query (crosstab I think), select all the table that you need the info from link the column names from one table to the next then in criteria list Algeria as in your example.

Clear as mud:o

Hey Phog,

I have it all done down to the final part.

If you have time at some stage could you go into a little more detail with the final step?

There is no rush on it.

I really appreciate it. Thanks in advance.

phog

What version of MS Office have you?

CluelessGirl

phog wrote: »

What version of MS Office have you?

Hey.

It is MS Office 2007!

Happy Friday!

phog

CluelessGirl wrote: »

Hey Phog,

I have it all done down to the final part.

If you have time at some stage could you go into a little more detail with the final step?

There is no rush on it.

I really appreciate it. Thanks in advance.

I hope I'm descibing this okay for you.

Okay assuming you have 6 tables and for this query you need info from three of the 6.

Click on "Create"
You should then see sections for Tables, Forms, Reports and Other
In the other section, click on Query Design

A"Show Table" window will pop up, usually with the "Tables" Tab open, you can use previously saved "Queires" too or "Both"

Seclect the tables that you need to get the data from, in my example that would be three tables.

The tables appear within your new query.
You will see the header rows is each of the tables that you selected.
Doble click on the header rows that you require to the "field" row on the query, ensure you drag the correct header row from the correct table.
You need to link the tables - you do this by left mouse clicking on the header row in the table and then dragging the mouse to the header row in the next table that has same info - your case it's a country. So in Table 1 lets say the country is under a header row of "Country" and in Table 2 the country is under a header row of "Country of Origin", then you'd link these two header rows as described.

Next step may not be necessary but might be nice to know:)

You can then right click on the link and select one of three options
1. Only include rows where the joined fields from both tables are equal
2. Include all data from Table1 and only those recrods from Table2 where the joined fields are equal
3. Include all data from Table2 and only those recrods from Table1 where the joined fields are equal

Down to the query fields and criteria
Under the "Fields" column which has the info that you want to get the data from - in my example it would be country or country of origin, you need to write Algeria in the Criteria row under country or country of origin.

Sorry for the delay but I cant access this site at work and I dont have MS Access on my home laptop.

If this isn't clear or you need further clarification post it here.

TiGeR KiNgS

do a vlookup in excel ?

CluelessGirl

Hi Phog,

Many thanks for that. I will try it tomorrow.

I really appreciate you taking the time to explain it to me.

Many thanks.