Call Tracking Database -- 2

Objective: Create a Microsoft Access database to log/track incident calls and output a variety of reports. Parameters: - Must be compatible with Access 2016. - Be able to export to Word 2016 and Adobe Acrobat 2017 - Be coded in a generally accepted format that makes clear distinctions between various functions (forms -frm, tables-tbl, reports-rpt, queries-qry, etc.) Details: - Every call (record) will have a unique ID number that starts with the two digits for the year followed by a four-digit number that ascends with each call entry (ie. #23-0001). - There will need to be approximately 20-25 fields with the need to open up additional fields if a particular YES/NO selection is made. - Everything in this database will be based off of the call input form (fields to be provided). The ability to search for and modify previous records must be an included function. Need to be able to search by (a) call number, (b) author, (c) date range. - The user will need to have the ability to output a record to one of three reports including a MS Word document and two Adobe .pdf reports. - A weekly summary report (.pdf) of calls will also need to be generated. - Some fields will need to be included on the input form that are inactive and intended for future use. - Call input form is to be user friendly with the ability to tab through each field. Font side for all fields and labels must not be smaller than 10-12pt. - A main menu form is to be included with an exit function that also compacts the database. - Standard security features must also be applied so a regular user cannot access tables or edit forms. Left+SHIFT function to access back end of the database should remain. Expectations: - I will need a first draft by November 25, 2022 with an ultimate project completion date of December 20, 2022. There will likely be the need to make several revisions however the scope of the project will not expand without discussion and agreement. - Input form and main menu must be user friendly/intuitive to use.