If you are looking for a larger scale database...SQL Server is the way to go!!
But, if you are looking for something smaller, and you are deciding between Access and FoxPro. FoxPro gives you the INSERT, DELETE, and UPDATE triggers as well as Stored Procedures (that are stored in the DBC (Database Container))...
Both FoxPro and Access2000 can be upsized to SQL Server if you application grows...
Just some thoughts!