ADM-162-O01

Module Four Access Extra Credit 15 points You work for Philips Associates, a company in Miami, Florida. To help keep the records confidential, a numeric filing system is used. You have been asked to use a database file to create an accession log and an alphabetic index for physical records. 1. Open the Access file 11-3 Files Index from the data files. This file contains information for the numeric file. 2. Open the Names List table. The personal and company names, along with addresses and telephone numbers, have already been entered in the table. In the Indexed Name field, key the name as it would be indexed for filing on a paper record. Review the alphabetic indexing rules, if needed. (5 points) 3. Create a query using the Names List table. Include the Number and Indexed Name fields. Sort the data by the Number field in descending order. In the Criteria row for the Number field, key Not G. Save the query using the name Your Name Accession Log. (5 points) 4. Create a report named Your Name Alphabetic Index using the Names List table. Include the Indexed Name and Number fields. Sort the data in ascending order by the Indexed Name field. Adjust the format as needed for an attractive report. (5 points) 5. Save the database and submit to the attached dropbox