Table Setup

[aaronjlaw]

Hello guys, I am new as you may guess and I have not used Access for a number of years and I have no idea about how it works in comparison to Oracle which I used for uni projects.

At work I have been tasked with a few Access based problems and one of which is making one of their handwritten feedback forms be input on Access so then responses can be graphed and analysed.

Is it possible to give written answers a number so they can be graphed.

For example.

Question 1 - Give me an example questions?

Answers:

1. Yes
2. No
3. Unsure

So you can see how many have each one when you graph the results. As I have it created with foreign keys at the moment it is displaying the text when I do the queries.



Also... is it possible to make a button so an interactive pdf report can be sent to all the selected user's email addresses?

 

[aaronjlaw]

Thanks for your reply. So this way would I be able to have a legend on the graph to show which numbers mean which answers so the admin team can understand the figures etc?

I had combo boxes set up but not with the correct columns as you have just explained.

Thanks.

 

[aaronjlaw]

How would I go about doing this on the query menu? Do you have any useful links for this sort of thing?

Many thanks!

 

[aaronjlaw]

I basically need this so I can input data as words (via combo boxes) but then it adds to a total of the same answers in a query so I can then graph it. It still needs each record to be intact though so it can be viewed as a whole. I cannot show you a picture example as I do not have enough posts it seems!

 

[Mihail]

I cannot show you a picture example as I do not have enough posts it seems!

You can upload anything but only in ZIP format for now.

 

[ButtonMoon]

Welcome aboard
Jet/ACE are relational databases just like Oracle. You will find some differences in the features offered, data types, and SQL syntax but nothing dramatic.

I think I nearly fell off my chair when I read that! Possibly what Pat means is this: there is a certain subset of Oracle features that do have equivalent or similar support in the Jet/ACE world and the differences across platfoms in those common features alone are probably not too difficult to get to grips with. It's a fairly small subset of features to be sure but many of those basic features will at least be recognizable to anyone familiar with a SQL DBMS but new to Jet/ACE.

Aaron, I know it's not the main subject of your question but in case it helps, here's a list of Oracle features compared to Microsoft SQL Server:
http://psoug.org/reference/sqlserver.html
most of the features labelled as "no equivalent" in the SQL Server column will also have no equivalent in Jet/ACE.

I think the biggest obstacle for people familiar with other SQL DBMSs is the Access UI itself, which unfortunately obscures many of the standard SQL features and makes it unreasonably hard to do some pretty basic things. You can of course bypass the UI fluff if you want to, it's just that Access doesn't make it all that easy to do so.

 

[aaronjlaw]

I used Oracle at uni to do some very basic things and also used mysql for a website but I have not used the Access UI since I was at school and on version 2003.
I am confusing myself continually but want to use Access as its the best way to do what the admin team want.

Buttons to make graphs, reports and input data. All of which Access can do nicely if I knew what I was doing haha!