Questions on a Database with Mass Data

[AccessHelp]

Good morning,

Currently, I have 5 databases with data (I would say, backend - BE
databases). Each database contains data for a specific year and has a size
of about 800 MB. The reason that I have 5 databases (represent 5 years of
data) is I don't think Access has a capability of handling 4 to 10 Gig of
data. Going forward, I will have more BE databases since I will have more
data for other years.

What I want to do is I want to build a frontend (FE) database that will
allow users to grab the specific data from a specific year (or multiple
years) by clicking a button or running a report. I know that I can link my
FE to each BE and let a query to grab the specific data from a specific year
(or multiple years). When I think of it and if I do that, I will end up
creating a lot of queries to grab the data. I don't think that is an
efficient way of doing it.

Please give me some advices or suggestions what you would do if you were me.
I also heard that SQL database can handle the massive data. Unfortunately,
I am not familiar with SQL database. If SQL database can do the job, please
let me know the sources where I can go to learn more about SQL databases.

Thanks.

 

[AccessHelp]

Chris,

Thanks for the information.

Are you referring another db as SQL database? In order for me to use the
SQL server, how much involvement would I expect from our IT department? Is
SQL server a database that can store the data?

I am sorry I am new to the SQL server thing. Could you please tell me a
little bit more?

Thanks.