Hi there,

Very new to Access and I'm trying to determine whether Access could be a solution to the following;

i work in an organisation that uses a decentralised purchasing model, we have several contracted services and goods supply contracts in place but the issue is our employees are not entirely aware of what is and isn't on a contract.

I'd like to create an access database that provides a search type option, based on keywords, that will return results if what they are looking for is on contract.

The types of info that is common across all contracts will be a contract number, title, start/end dates + any extension options (if they exist), and the supplier(s) that can be used.
Dependent on the contract, there could be multiple categories with multiple suppliers. With this, there will be schedules of rates which I'd like to link to a excel spreadsheet.

It is a complex beast and I wonder if Access can accomodate it?