AutoCorrect names can be buggy and drain your database
Some of the Microsoft Access features were introduced to help improve functionality and automation. However, some of Access features became a hinderance rather than a benefit and one I want to quickly mention here is the 'AutoCorrect' option in the Access Options interface. This feature was introduced with Microsoft Access 2000. It tries to help users who rename a table field, so that queries, forms and reports automatically recognise the new field name. Microsoft has addressed some of the problems with this feature, but is it still buggy, incomplete, and casue a strain on performance and should be avoided. It is better to therefore turn the feature off and depending which version of Access you use can be accessed via the 'Options' command. For Access 2000/2002/2003 it can be found via Tools, options, General tab. In Access 2007 it can be found via the 'Office' button, Access Options, Current Database tab. Finally in Access 2010 i(and later versions) t can be found in File tab, Options, Current Database. Final point here is that you must remember to do this every time you create a new database, preferably before creating any other objects.
MICROSOFT ACCESS DEPENDENCIES: WHAT IS THE OBJECT DEPENDENCIES PANE? https://accessdatabasetutorial.com/microsoft-access-dependencies-what-is-the-object-dependencies-pane/