Making info in multiple databases available to other users?

yuffie

New Member
Joined
May 16, 2007
Messages
2
Hi, this may be a really dopey question but here goes.

I work in a school and have a number of access databases that contain pupil reports from each term and am trying to work out a way of making this information available to teachers. What I hope to do is have a front end where a teacher can choose a pupil then filter by term and/or school year to see all their grades/reports.

Is this possible and if so what is the best way to do it?

Thanks.
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
I would try to get all of the data into our central "back-end" database. There are a few different ways of doing that.

One would be to import all of the information into one database.
Another way would be to build a new database, and link all the different tables from the different databases into this one central "collection" database.

Either way, I imagine you might some work in front of you linking all the different tables together.
 
Upvote 0

Forum statistics

Threads
1,217,383
Messages
6,136,245
Members
450,001
Latest member
KWeekley08

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top