{br} STUCK with your assignment? {br} When is it due? {br} Get FREE assistance. Page Title: {title}{br} Page URL: {url}
UK: +44 748 007-0908, USA: +1 917 810-5386 [email protected]

Microsoft Access Database Design and Implementation

Business Scenario
Your company has been using Excel to track customer orders. They are having difficulty analyzing the data and producing meaningful reports. They have asked you to implement an Access database which will allow them to add, modify and delete data as well as generate reports based on the information contained in the database.
1.    Create Database ?Your first task is to create a database in Microsoft Access populated with data from OriginalData.xlsx spreadsheet which includes: ?§??the material worksheet?§??the customer worksheet?§??the salesorder worksheet?§??the salesorderitem worksheet ?Start with a “blank” Access database, name this database YourName.accdb. Import data from each worksheet in the Excel file OriginalData.xlsx. Note that each worksheet should be imported as a new Access table and given the same name as the Excel worksheet. Hint: Be careful in setting the datatypes of each field during the import process – remember foreign keys (an example is the CustomerID in the SalesOrder table) MUST be of the same data type as the corresponding primary key in a related table. Use text for ID numbers in all tables.
2.    Create Relationships & Forms for Data Entry?a. Build the relationships for the three tables per the model shown in Figure 1. ?Figure 1: Model of the Relationships

ITM 220 Access Assignment Dr. Papp
3. Create Forms for Data Entry
a. Create a data input form (name it “customerFRM”) for customers that can be used to update the customer table. Use the Create form wizard with “split form”. Add one company to the database as a new customer that is a Hypermart in Fulda (Germany) with postal code of 36048. Use your UT student ID for the customerID.
Figure 2
b. Create a form to display each salesorder as well as salesorderitem details on a subform. (Use the Forms Wizard, style “office”.) The form should look like Figure 3 below.
For Order number 10 add an additional line item using your new form as follows: MaterialID: AA-02

Quantity: 100 Price: 525

Figure 3 ITM 220
Access Assignment Dr. Papp
4. Create Queries to Analyze Information
(a) Create a query called Q1-ListAllCustomers which displays each customer’s ID, postal code, city, and searchterm. Sort the list alphabetically by city (hint change setting in “Sort” row of query design grid).
(b) Create a query called Q2-ListCustomersFulda that displays the ID, postal code, city, and searchterm for each customer in Fulda. Sort this list from largest to smallest by customerID.
(c) Create a new query called Q3-PriceStatistics that displays price in six columns but computes different values for each display. Display 1) the sum, 2) the minimum, 3) the maximum value, 4) a count, 5) the average, and 6) the standard deviation of price. (Hint: use the Sigma summation symbol to display the “Total:” row in the query grid)
(d) Create a query called Q4-CustomerOrderbyItem that displays data from all four tables. Specifically include: Customer, City, SearchTerm, SalesOrderDate, SalesOrderID, MaterialID, Quantity, Price, and Material description. Sort by MaterialID. This query will be used as an input to the next query and to show we can reassemble the data from the original document used to build the system.
(e) Create a query called Q5-OrderDetailsCrosstab, which produces a table such as is shown below (Hint: use the crosstab function in the Query Wizard and the previous query as your input to create this query)
(f) Create a query called Q6-CustomersLessThan15000. Start by copying Q4 and modify the name. Display only data for total prices less than 15000 Euros.
(Hint: use the “criteria” row by entering the appropriate inequality and numeric value to generate the correct data.)

ITM 220 Access Assignment Dr. Papp
5. Create Reports for Management
(a) Create a report “R1-CustomerbyCity” that looks like the one below.
•    Use the Create | Report with Customer table. (Don’t use Report Wizard.)
•    Change the title to include your name.
•    Use “layout view” to customize report (column order, width and sort by city,) ?(b) Create a second report “R2-SalesReport” as shown below using Q4 as your input source. ?•?Use Create | Report again but with Q4 as your source. You can use Report Wizard or create the report manually. Note: “right click” is your friend as you modify the default report format to achieve: ?o Group on MaterialID?o Group on MaterialDescription?o Adjust layout to “Stack MaterialDescription” as shown?o Sort by OrderDate?o Compute subtotals and grand totals for price and quantity?o Adjust format to align columns and change labels as necessary

PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂

Sample Answer

Compelling correspondence is essential to the achievement all things considered but since of the changing idea of the present working environments, successful correspondence turns out to be more troublesome, and because of the numerous impediments that will permit beneficiaries to acknowledge the plan of the sender It is restricted. Misguided judgments.In spite of the fact that correspondence inside the association is rarely completely open, numerous straightforward arrangements can be executed to advance the effect of these hindrances.

Concerning specific contextual analysis, two significant correspondence standards, correspondence channel determination and commotion are self-evident. This course presents the standards of correspondence, the act of general correspondence, and different speculations to all the more likely comprehend the correspondence exchanges experienced in regular daily existence. The standards and practices that you learn in this course give the premise to additionally learning and correspondence.

This course starts with an outline of the correspondence cycle, the method of reasoning and hypothesis. In resulting modules of the course, we will look at explicit use of relational connections in close to home and expert life. These incorporate relational correspondence, bunch correspondence and dynamic, authoritative correspondence in the work environment or relational correspondence. Rule of Business Communication In request to make correspondence viable, it is important to follow a few rules and standards. Seven of them are fundamental and applicable, and these are clear, finished, brief, obliging, right, thought to be, concrete. These standards are frequently called 7C for business correspondence. The subtleties of these correspondence standards are examined underneath: Politeness Principle: When conveying, we should build up a cordial relationship with every individual who sends data to us.

To be inviting and polite is indistinguishable, and politeness requires an insightful and amicable activity against others. Axioms are notable that gracious “pay of graciousness is the main thing to win everything”. Correspondence staff ought to consistently remember this. The accompanying standards may assist with improving courtesy:Preliminary considering correspondence with family All glad families have the mystery of progress. This achievement originates from a strong establishment of closeness and closeness. Indeed, through private correspondence these cozy family connections become all the more intently. Correspondence is the foundation of different affiliations, building solid partners of obedient devotion, improving family way of life, and assisting with accomplishing satisfaction (Gosche, p. 1). In any case, so as to keep up an amicable relationship, a few families experienced tumultuous encounters. Correspondence in the family is an intricate and alluring marvel. Correspondence between families isn’t restricted to single messages between families or verbal correspondence.

It is a unique cycle that oversees force, closeness and limits, cohesiveness and flexibility of route frameworks, and makes pictures, topics, stories, ceremonies, rules, jobs, making implications, making a feeling of family life An intelligent cycle that makes a model. This model has passed ages. Notwithstanding the view as a family and family automatic framework, one of the greatest exploration establishments in between family correspondence centers around a family correspondence model. Family correspondence model (FCP) hypothesis clarifies why families impart in their own specific manner dependent on one another ‘s psychological direction. Early FCP research established in media research is keen on how families handle broad communications data. Family correspondence was perceived as an exceptional scholastic exploration field by the National Communications Association in 1989. Family correspondence researchers were at first impacted by family research, social brain science, and relational hypothesis, before long built up the hypothesis and began research in a family framework zeroed in on a significant job. Until 2001, the primary issue of the Family Communication Research Journal, Family Communication Magazine, was given. Family correspondence is more than the field of correspondence analysts in the family. Examination on family correspondence is normally done by individuals in brain science, humanism, and family research, to give some examples models. However, as the popular family correspondence researcher Leslie Baxter stated, it is the focal point of this intelligent semantic creation measure making the grant of family correspondence special. In the field of in-home correspondence, correspondence is normally not founded on autonomous messages from one sender to one beneficiary, yet dependent on the dynamic interdependency of data shared among families It is conceptualized. The focal point of this methodology is on the shared trait of semantic development inside family frameworks. As such, producing doesn’t happen in vacuum, however it happens in a wide scope of ages and social exchange.

Standards are rules end up being followed when performing work to agree to a given objective. Hierarchical achievement relies significantly upon compelling correspondence. So as to successfully impart, it is important to follow a few standards and rules. Coming up next are rules to guarantee powerful correspondence: clearness: lucidity of data is a significant guideline of correspondence. For beneficiaries to know the message plainly, the messages ought to be sorted out in a basic language. To guarantee that beneficiaries can without much of a stretch comprehend the importance of the message, the sender needs to impart unmistakably and unhesitatingly so the beneficiary can plainly and unquestionably comprehend the data.>

Our customer support team is here to answer your questions. Ask us anything!