Linked Databases and using 1 user interface

[mooreb55020]

I'm new to access but wondering if it's possible to build multiple databases. I'm looking at 1 for the following (product records/Bill of Materials, Production/Scheduling, Maintenance/Machines, Quality Records, Sales/Accounting, Employees, Purchasing/Inventory/Warehouse). Would it be possible to build a database for each of these then build a separate database that has linked tables/queries to each of these and then build the forms and reports to run off of that linked database? The company doesn't want to spend the finances to build it in SQL Server and Visual Studio so I'm stuck with Access which I'm not familiar with or Excel which has such limited capabilities. Thanks in advance.

[pbaldy]

I'd lean towards a single back end database with the appropriate tables for all of them. I suspect there would be inter-relationships between them, and having them in separate databases could lead to performance problems.

FYI, there is a free version of SQL Server, which Access can use as the back end.

[mooreb55020]

I'm unsure of how many cores our server is and unfortunately our IT department thinks it's the CIA so it's hard to convince them that SQL Server Express is an option to increase our data load capacity. I'd much rather build it all in Visual Studio and SQL Server.