Any Access gurus on here? - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Any Access gurus on here?

sancho1983 Avatar
5y, 5m agoPosted 5 years, 5 months ago
Been a long time since I have used Access (10 years or so) but I have been asked to create a database to track some information.

I work at a college, we have about 80 students spread over 8 groups. They complete qualifications each year, these qualifications are made up of different units (with unique ref numbers). The students can do the same 'qualification' but it must be made up of different units in subsequent years

Often our students will stay in our department for up to 5 years (sometimes changing groups, sometimes not), we need a way of recording who has done what unit, what year they did it and which group they were in when they did it

I tried to do it in Excel but got really confusing. The students do roughly 14 units per year.

When planning for the following year we need to be able to pull up say all of the students who have done a particular unit, and which group they are in.

Any of that make sense?

1 student will do many units, 1 unit could be done by many students.

Am a bit lost if anyone could offer any ideas?
Other Links From Here:
sancho1983 Avatar
5y, 5m agoPosted 5 years, 5 months ago
Options

All Comments

(9) Jump to unreadPost a comment
Comments/page:
#1
You can use Access, but much easier in Excel, using Filters... PM me the names (made up if you want) and Qualifications with Units and I'll see what I can do this morning.

If you can, stick them all into a XL sheet, so I'm not having to cut and paste bud!
banned#2
Databses, spreadsheets etc, 96% don't ever get read/used. Save yourself some time and skip it!
#3
Disco
You can use Access, but much easier in Excel, using Filters... PM me the names (made up if you want) and Qualifications with Units and I'll see what I can do this morning.

If you can, stick them all into a XL sheet, so I'm not having to cut and paste bud!

When I tried to use Excel the sheet became massively wide. Plus the units were never necessarily put in the same column, so when I used filters it would pick up the units that happened to be in that column, but not if i'd put it elsewhere - if that makes sense

master_chief
Databses, spreadsheets etc, 96% don't ever get read/used. Save yourself some time and skip it!

Would love to, unfortunately I have to do a certain amount of days working on projects to fulfill my contract - This has been given to me. The worst thing is that no-one apart from me will understand it or be able to use it. Guess who will be the person inputting all of this info...
banned#4
I'm trying to bring the campaign to end the spreadsheet/db madness infecting the world. I could the world billions by getting people to stop creating/amending/updating them!
#5
Use excel, but don't put everything on the same sheet have a different sheet for each unit and a summary
#6
I will sign anything if it helps...

Although I quite like making them - just not using them
#7
just emailed you back. do you have the actual spreadsheet there, or is the one you sent me all you have?
#8
Disco
just emailed you back. do you have the actual spreadsheet there, or is the one you sent me all you have?

I did it a long time ago and didn't save it as I got confused and frustrated. The thing I sent you was just a quick example of the sort of thing needed.

Have e-mailed you with some more clarification
#9
replied

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!