I NEED A DATABASE
From my experience most software is worth about what you pay for it.
Why not try QGIS?
It is free.
It works in multiple operating systems (Windows 32 bit & 64 bit, Linux, MAC OS10, and others)
It has a very active community for support, and development.
You can design your own project database and store it in a shape file, or spatialite file.
It is able to read and write just about any type of file you may encounter.
It will interface to Google Earth, Bing, and other web mapping portals.
It interfaces with GPS/GNSS equipment that output NMEA strings. You can collect field data with it. I do it all the time with a rugged tablet.
It is able to work with just about every datum or projection known to man. (It uses Proj4.4)
The ability to import PLSS data, Found Monument Records, Federal, State, and Local data, Ownership data, Utility data, then view it, query it,
calculate with it is a tremendous asset.
It has great cartographic capabilities.
The list of capabilities are too many to mention here.
I can say this, I have built project management databases using QGIS for my current employer, and others..
They are more than happy with the results.
It is not difficult to learn, and once you start producing with it, you will come up with ideas for its use.
No two cents worth.
If you download it, I would recommend the Long Term Release, Version 2.18.24 and get the Standalone Installer for now.
Version 3.2 is still for early adopters. It is mostly stable, but has some quirks that are being ironed out.
I've used Access for this purpose very successfully for many years. The primary method to my madness is interfacing the Access .mdb file with our CAD land base maps so that I can plot the job No. in the database in CAD by using an ODBC connection and the State Plane northings and eastings in the Access file in the general area where the work was done. It can also be searched directly in seconds by MTRS, job No., subdivision name, FB PG, street name, on and on. It's the only way I've found I can keep track of thousands of jobs done over 20 plus years. I frequently use work done 15-20 years ago to quickly get work done where perhaps a lot of the original control has gone bye-bye or to comp out search coordinates before I even step foot on the site. The first step in every job is consulting the "Oracle" to see what's been done in an area and the last step putting it to bed is updating that database.
Newforma is also an option but I'm not sure of the cost.