Design a query to calculate the gross profit and gross margin for each of the products in your product worksheet in descending order of gross margin. The following attributes are to be displayed in sequence: Product No, Product Name, Unit Cost, Unit Price, Gross Profit, Gross Margin. Name the query “Product Gross Profit and Gross Margin.” Print out the result of the query (the datasheet view). In addition, capture a screen shot under Design View and print out the query.
2. Design a query that will display payment methods for the customer with Customer ID 1004. The following attributes are to be displayed in sequence: Credit Card Type, Name on Card, Expiration Date. Name the query “Payment methods for customer 1004.” Print out the result of the query (the datasheet view). In addition, capture a screen shot under Design View and print out the query.
3. Design a query that will display Last Name, First Name, and Email address of customers who have ordered product with Product No 200415, in ascending order of Last Name. Name the query “Customers who have ordered 200415.” Print out the result of the query. In addition, capture a screen shot Under Design View and print out the query.
4. Design a query that will display the products that need to be reordered and their suppliers. The following attributes are to be displayed in sequence: Product No, Product Name, On Hand, Safety Stock, Supplier No, Supplier Name. Arrange the records in ascending order of Supplier Name. Name the query “Suppliers for products that need to be reordered.” Print out the result of the query. In addition, capture a screen shot under Design View and print out the query.
5. Design a query that will list all data elements (including a calculated field for subtotal, but excluding order total) needed to generate an invoice for the order with Order No. 300-05. Print out the result of the query. In addition, capture a screen shot under Design View and print out the query.
Hi sir,
I am very much interested in your project.
I can create any type of query in Microsoft Access and SQL.
Feel free to contact me for further details.
Looking Forward,
Nblsoft
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
Hello there,
I'm an experienced freelancer, with a vast experience in Access. i have designed many databases, bth for academic and commercial purpose. Please hire me and i will help you out.
I always keep time, and deliver quality work.
Hire me & be assured of great work.
Hello there,
I'm an experienced freelancer, with a vast experience Databases. I can help you with the Access work.
I always keep time, and deliver quality work.
Hire me & be assured of great work.
Hi
I am a 25 year old hard worker with excellent computer skills including Data entry,C#,HTML5,Bootstrap,and CSS.
Majored in Information Systems Engineering from 2011 and grew a passion for web development,
I classify myself as an IT expert.
I have a permanent job as a receptionist and data entry is my key role.
Joined Freelancer.com to better my income and I vow to use my skills
and time with respect and honesty to suite your project expectations.
Please accept my bid.
Warm regards
Clyde
Hello,
i have over 10 years experience in software development, i'm interested for this project and for this price i can offer you and development in mssql with vb.net application that is better than access. But also if you want than we can go on and with access.
We practioners MS Access, Ms Access control of various features of table creation to codding in VBA.
Is currently working on creating a database specifically for Gemstones Laboratory. ranging from customer receipts to the reporting process.
Some we have completed and in progress include:
1. SKY GEM LAB (JAKARTA) -- (MS ACCESS Combine MySQL)
2. AVIANNOOR GEM LAB (JOGJA) -- (MS ACCESS Combine MySQL)
3. G-LAB Pawn Center (Jakarta) -- (MS ACCESS Combine MySQL)
Technically we use MS ACCESS for Interface and MySQL for saved Database
ADVANTAGE SOFTWARE MADE OUR
User Friendly
Step by Step Building and Customization
Based network
Easy Installation
Easy Integration
Elegent Design
I am MCT (Microsoft Certified Trainer) since 2007 and have knowledge of
SQL,
VB,
,
C#,
SQL Server,
BizTalk,
Business Intelligence,
Java,
SAS,
MS Office
MS Access, Excel, Word and PowerPoint
Oracle PL/SQL
SQL project experiences. Trading system data model enhancement. Deign query to tracking shareholders, the trades made by the shareholders, and some specific information like the below project description. Please contact me if you have any questions,
Hello,
I am a IT professional with more than 5 and half years of experience. I have a knowledge in MS access as per your requirement. If given a chance would complete your work in a day or two.
Below is Access query for your point no. 1 i.e. Product Gross Profit and Gross Margin:
SELECT Product.[Product No], Product.[Product Name], Product.[Unit Cost], Product.[Unit Price], Orders_Product_Wise.[Sum Of Quantity], (([Product].[Unit Price]-[Product].[Unit Cost])*[Orders_Product_Wise].[Sum Of Quantity]) AS [Gross Profit], Round((((([Product].[Unit Price]-[Product].[Unit Cost])*[Orders_Product_Wise].[Sum Of Quantity])/(Product.[Unit Price]*Orders_Product_Wise.[Sum Of Quantity]))*100),2) AS [Gross Margin]
FROM Product INNER JOIN (SELECT DISTINCTROW [Ordered Items].[Product No], Sum([Ordered Items].Quantity) AS [Sum Of Quantity]
FROM [Ordered Items]
GROUP BY [Ordered Items].[Product No]) AS Orders_Product_Wise ON Product.[Product No] = Orders_Product_Wise.[Product No];
Hi,
I'm an electronic and computer engineer with expert knowledge of database development,Microsoft Access,SQL,Microsoft Excel and VBA programming.
I reviewed specification You gave and I'm very interested to work on your project.
I can assure You that,if You choose me,the project will be done in specified time frame and it will met quality recommendations.
Thank You,
Goran Hristov
I have many years of experience with SQL and entity-relationship databases. Your project will be completed swiftly and accurately with complete documentation.
I have done Engineering and MBA from one of the prestigious college in the country. I am Advanced SAS certified by SAS, USA. I have around 3 years of experience in SQL,SAS. I like to plan my work based on project deadline.