Access beginner needs advice

[robertc1986]

Hi all

First off thanks for taking the time to read this

ok ill start with what im planning and let you decide from there, sorry for any non technical terms im still very basic at access but enjoying every moment learning so fingers crossed this will benifit me even further

Ok ive created a table (Table1) and inside this table i have a number of fields:

Name
Address
Q1 - these are questions that you can select from 1-4 1 being good 4 being bad
Q2
Q3
Q4
Q5
Q6
Date Created

i have a form for these details to be entered and all this is working correctly you enter the details and click save & close and this info gets added to the table all well and good

now for the hard part and the part im completley new at:

Creating a report.

on this report i would like to be able to pull the information from the table i.e name address and then answers 1-4 from the questions

under this then i would like to be able to take the following details:

total number of records?

some type of percentage from the questions not sure hwo to work this out?

for an example what im aiming for is the following:

if there is 10 records i would like to be able to find how many picked 1 how many picked 4 and so on and then maybe a percentage from the 10

so like 15% choose 1 for Q1 30% choose 2 for Q2 ect ect

then maybe a total of some kind

to be honest im rubbish at maths and new at access so if someone could possible feed back some info as to hwo this could be done?

would it be :

report?
query?

could i have it on a 2nd form? and have command buttons to pull these details into a text box on user clicking the button ?

example:

[Button] - [ test box ]

user clicks button the text box is then filled with how many people submitted a record?

please reply with any info possible id appriciate it

also i can post the database im working on for you to look at if you like so you get an understanding of what im aiming for

once again sorry for the non techi stuff ive currently used access for a week and am still very new to this whole package

anyways enuff rambling

Kind regards

Robert C

 

[Trevor G]

Re: Access begginer needs advice

Welcome to the forum Robert,

What you need to do is first create a query to show you all the data, then create a report to use the query in its layout.

You can use a report header to show how many records and calculate etc. Like a cover sheet and summary.

If you create the query and initial design of the report then upload a copy of the database in 2003 verison (or lower) then I will take a look and deal with the percentages etc.

 

[robertc1986]

Thanks for the speedy reply

ill get on the design and everything over the weekend i should have it all finished by sunday night i have a bit of university work to do so if i say ill upload it by monday the latest that should give you and myself ample time

thanks once again trevor i really appriciate it it will also be intresting looking over your work to give me an ideas of how its arranged ect

so thanks again

much appriciated

Rob