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

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
56,957
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,811
Messages
5,638,488
Members
417,027
Latest member
wlknspc7

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
Top