Access Database Modifications

Have and access database application that needs some report and basic field revisions. ## Deliverables * Instrument drop down box. Want all caps on all items. Would like field to allow more characters. * Vol field would like more characters * Pg field would like more characters * Remove record# field from form * Type field would like more characters * For all date fields would like to have dash between numbers, would like auto formatting of date so can just type date and dashes auto added * Would like to move effective date above inst date * Remove desc field from form * Change field name from remarks to comments * If hit enter in remarks field if hit enter would like to advance to new line, currently advances to new record Reports * On index report add instance # on L column like old report and remove date column. Would like numbered and sorted by date oldest date to newest date. * Would like date and page number at bottom of page to be all caps * Would like same new header for runsheet report, landman index report, and index report (see header details) * Use the following header details for reports: Would like first line to be title (All bold and bigger font), Would like the ability to add one or several additional likes for description below heading in smaller font (but still all caps and bold). Want separate form for creating heading that reports can access to populate their page headings. * Set all column and row headings to all caps * On all pages want numbering to say page x of y * Set limited title runsheet form to default to legal page size * On runsheet form remove reference & number field * On runsheet form add acerage field with 10 character max, want to print underneath effective date and add “ACS?? after number on report i.e. 10 ACS * On runsheet report would like inst # to show to column R of printed record * Rename indexreportportrait to indexreportportraitbyeffectivedate (when print reports use * reports) * Would like index report by inst date * Would like index report by file date added * Set landman report to all caps on field names