How to analyze data and output it in table form?

L

Little Beginner

I am a beginner in MS Access and would like to try some data analysis.

I have a database like this:
http://hk.geocities.com/butterflycharles/access.jpg

And I would like to analyze the data and output a table like this:
http://hk.geocities.com/butterflycharles/academicprofile.jpg

Please let me know what I should use(e.g. query, functions, reports, etc.).
If possible, please let me know the corresponding tutorials so that I can
understand what's going on. I wonder if crosstab query is the answer. Thank
you!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Adding data to MS Access from csv file 0
need help 0
problem with crosstab query 1
System for Analyzing a database 4
How do I clear a form? 0
help me 0

Top