Description Below are the parts of the project: Design on paper a database for a business purpose. Describe the database and its purpose in a word document. Also – in the word document explain each of the parts of the database as listed below. I can read your explanations as I look at each part of the database. For example, explain each query and its purpose in words. Determine the structure of a table with the following properties: 25 records At least 3 numeric or currency fields that can be added, counted, and averaged. At least 2 text fields. Name your database your last name and first initial. Sort the records in ascending order by some criteria. Perform three queries that will be helpful in decision making for your business. Describe and explain the purpose of each query. These queries should have some complexity with more than two criteria. Perform a query in which you – total one column, get a count on one column and average one column (in the same query). Create a form based on the fields you created. Based on the query from g above, prepare a report. The report title and all fields should be in complete words. The report should have a professional appearance
Recent Comments