Northwind jobs
Need some help with access database. ideally i need someone local (UK) or someone who is available online UK hours
Design a website that provides access to the Northwind database for managers of the Northwind company. The website will provide management assistance in two management tasks: product review and employee performance review. The specifications for each task are detailed below
Hi there, I need help with this in the next 15 hours. The attachments should be executed in the following order: 1.Northwind_Mart - creates the northwind star schema datawarehouse - creates and populates the DateDim table - script to populate the fact table SSIS portion of the assignment: Either pick product or shipper that would be the easiest one's to do.
Hi there, I need help with this in the next 24 hours. The attachments should be executed in the following order: 1.Northwind_Mart - creates the northwind star schema datawarehouse - creates and populates the DateDim table - script to populate the fact table SSIS portion of the assignment: Either pick product or shipper that would be the easiest one's to do.
I need to get query result from Northwind MSSQL for this I need WebService c# and swift ios code. main rule is security connection
I need a C# WCF web service that connects to a SQL Server database, retrieves all rows from a single ta...web service call to the database would be RetrieveData(TABLE_OR_VIEW_NAME, FIELD_NAMES[]) where TABLE_OR_VIEW_NAME represents a single table or view in the database and FIELD_NAMES[] is an array of string that contains all the fields to be included in the query. There should also be an option to include all the fields without specifying every one of them. So for the standard microsoft Northwind DB RetrieveData("Products",["ProductID","SupplierID","UnitPrice","Discountinued"]) or RetrieveData("Orders",["ALL"]) (where all represents all the fields). The returned output needs to be JSON. Minim...
Please contact me via email. mtmoore80831@gmail.com. Due date for this project is tomorrow Sunday October 12, 2014 at midnight. Thanks.
Over existing stored procedures create a console application (calle Task 1), which will be displayed from the Northwind database, details of the order of one customer whose ID (referring to the ID of order) forwards. It is necessary to introduce a stored procedure CustOrderDetail in EDM that requires one parameter @ OrderID as an input parameter. Note: The EDM import only stored procedures and tables that are needed for this task. The result should be in the form of: ProductName: Mozzarella di Giovanni, UnitPrice: 34.8000, Quantity: 5, ExtendedPrice: 174.0000, Discount: 0.
Business information system Technical skills (12% out of 25%) (fill in blanks, file upload) HTML and CSS (focus on the questions you missed in midterm) Microsoft Access query using Northwind database Microsoft Access creating forms and reports Microsoft Excel pivot table and chart using Northwind data Design of database: entity, attributes/fields, identifier/primary key; 1:N relationship, parent/child, primary key/foreign key
Business information system Technical skills (12% out of 25%) (fill in blanks, file upload) HTML and CSS (focus on the questions you missed in midterm) Microsoft Access query using Northwind database Microsoft Access creating forms and reports Microsoft Excel pivot table and chart using Northwind data Design of database: entity, attributes/fields, identifier/primary key; 1:N relationship, parent/child, primary key/foreign key
CIS 5612 Homework 4 The purpose of this assignment is to practice these skills: -Use of databases in ASP.NET -Creating secure applications You will need: - Northwind database (file: ), available in this HW link. Web site specifications In this assignment, you will develop an application that supports the inventory management and human resources departments of the “ASP Your Design” company. The web site allows employees from the Inventory Management department to log in and view data related to suppliers/shippers and allows Human Resources (HR) department employees to access data related to employees. We are assuming that Inventory Management employees can self-register in the web site, while HR employees ...
We need a demo project for our EasyQuery library () which implements ad-hoc reporting functionality over some sample database (like Northwind or AdventureWorks).
Design an asp.net page with the following components ( use the Northwind database) i. Web page that displays a grid which shows one row per Order. Columns in the grid are – Order ID, Customer Company Name, Order Date, Shipped Date, Shipper Name, Order Total (must include discounts if any). ii. Implement a basic filter at the top of the grid that lets user filter orders by Customer’s company name. iii. A way to show top “x” number of orders with options 5, 10, 50, All (orders always sorted by Order Date Descending) iv. Display order amounts over $3,000 in bold v. The grid must be refreshed using Ajax after filtering based on the above criteria vi. All columns in the grid must be sortable. Sorting should be done using Ajax as well. vii. Use CSS or code behind(C...
Over existing stored procedures create a console application (calle Task 1), which will be displayed from the Northwind database, details of the order of one customer whose ID (referring to the ID of order) forwards. It is necessary to introduce a stored procedure CustOrderDetail in EDM that requires one parameter @ OrderID as an input parameter. Note: The EDM import only stored procedures and tables that are needed for this task. The result should be in the form of: ProductName: Mozzarella di Giovanni, UnitPrice: 34.8000, Quantity: 5, ExtendedPrice: 174.0000, Discount: 0.
I have access template Northwind Traders and I need to modified file to meet my demands. *Create new order form (I will provide in .doc format) which is gonna be filled form other tables in access file *Customization of other forms that already exists Contact me for more information Access file is in Croatian language
...should retrieve from the Suppliers table (part of the Northwind database) the SupplierID and CompanyName. On changing the supplier the system should trigger thru jquery and ajax a WCF service used to retrieve (in Json format) from the Products table the PRoductID and the ProductName belonging to the selected Supplier. And the ultimately the submit button should using againa jquery and ajax retrieves the UnitPrice and UnitsInOrder and display this in the label The other project still in .NET Framework 4.0 will be a WCF Service Application project used 1) to access the Products table and retrieve the product's list required by the form 2) to retrieves the UnitsPrice and UnitsInOrder for a product What I am providing - the Northwind database What I am expec...
...information. Totals Total Colors Done In test Blue Purple Pink Totals 4. On a button click I want the values from the columns above to fill a row in a table. For ex. ID Date Totals Blue Purple Pink 4 3/4/2014 34 234 34 234 <- these would be the values from the above table and would be activated on button click to fill once per day. I attached the northwind database as a sample datasource....
Install the Northwind Database into the environment. Click here to install the database. Note that this link does link to the SQL Server 2000 Sample Databases, but after downloading it, the ZIP file can be extracted and contained inside the package as a file named "instnwnd.sql." This file can be opened and executed inside of Microsoft SQL Server Management Studio. Task #2 Generate a database diagram. Include a screenshot of this diagram in your Word document.
Using the Northwind sample SQL DB, need the SQL statement I can run in SQLITE Professional that will group the value of orders Customer 's city.
...after aggregation Upload the revised database to this assignment in Desire2Learn. Continue with the NWDataOnly database from 1. above or download a fresh copy of the Access database NWDataOnly. Create and enter (I am thinking by hand using the Access datasheet view for the tables) the following; the exact data are up to you except as indicated -- a new product category (e.g., HIA folks can help Northwind move into medical supplies wholesaling) with Category Name your 'xxxx Cat' where xxxx is JagNet ID (the part of your GRU Email before the @); so my Category Name would be 'tschultz Cat'. two new products in the product category; a new supplier linked to the two new products. Upload the revised database to this assignment in Desire2Learn. Continue with the NW...
Hello, I have posted a project previously however i was not satisfied with the freelancer response. I have created the framework for a Multi-user sales tracking database. My goal is to have a main form with as many drop-down lists as possible ( reducing human error) for users to enter in t...sales information as well as track the progress. Then be able to run reports of the recorded data of Complete sales or quotes only sales. I have attached a copy of the relationship data base i have built thus far. The issue I am having is FORM and Report Design not Database design. My biggest concern is when a quote has multiple items with one customer. A customized version of the Northwind Sales database is EXACTLY what I am looking for. Happy to skype to discuss further ...
Manish, I believe you have worked for me before. I'm Bethann Christopher. Do you remember me? I need Craigslist posting. I remember you were very good at it and we used your service in another company I am affiliated with also, Northwind Group. Please tell me what you charge per posting that sticks, and when you can get started once I send you the cities, titles and ads. Also, do you want image ads or text ads? I am putting up a new website in a couple of days - almost finished. Current one is obsolete. I need to get ready to start posting as soon as the new website goes up. My website is and my e-mail is BC@ . I look forward to hearing from you Manish. ...Beth
Hi Shawn: This is the VB.NET database project you bid on yesterday. I have a simple test project based on the NorthWind database. The Form1_Load code works - but none of the cell edits get saved to the file. I have defined Button1 - I want you to provide the code that will save the edited cells to the file. I awarded the project to another Freelancer, but his "solution" involved copying *every* cell from the DataGridView to the .mdb file. That looks to be very inefficient. I was hoping for a solution similar to what's given here. %28v=vs.80% Regards, Leigh
I have a simple test project based on the NorthWind database. The Form1_Load code works - but none of the cell edits get saved to the file. I have defined Button1 - I want you to provide the code that will save the edited cells to the file.
Please check the file below. I want you to edit the MS Access ready project Northwind Traders and make it works for a transportation company. I will not have a stock. I want to take over all features of this program like statistics, design and overviews. First I need to enter open loads for, where I have to search for a truck to pick it up I also need to an order form to enter the loads I have ordered. Please check and tell me if you can do it
I'd like to customize the templates "Case management" and "Northwind" to get an application that include Cases, Customers, Products. most of the job is to remove some options from the Northwind template and add some fields for the case managements
1. A full example source code of android JTDS(using Eclipse) connection to Server Microsoft SQL Express(Northwind DB is OK ). 2. 3 Pages needed, first Login Page(no authentication), second page, a button click to retrieve Northwind table(any table), third page, to display the output. 3. Able to retrieve records from any Northwind table. 4. A full documentation guide to setup JTDS connection until data is retrieve and display, include components and environment(JTDS version, OS 32 or 64 bit and settings to make it able to connect to database and retrieve).
Just a few more minor items: 1) Need DateClosed field on Orders. When Complete Order is clicked, then set DateClosed to today's date. Sales Report should key off DateClosed. 2) On the Invoice Report, add tax if not tax-exempt. (set the checkbox to unchecked by default) 3) Set available quantity to 1000 for each product. Maybe needs to append records to Purchase Orders/Purchase Order Details/Inventory Transactions to accomplish this. 4) When creating a new Purchase Order, the products on the subform should be products from the supplier selected (not all items). Please make the product searchable by words contained in the name (like you did on the Order details subform).
My database needs some additional work 1) On the Customer Order form near the bottom right, I need: a) a subtotal field b) a tax field that calculates the tax on the subtotal at a rate of 8.25% c) I need a checkbox somewhere around the subtotal, tax and total that indicates that the order is taxable or not (labeled 'Tax Exempt'). If the box is unchecked (default), then the tax needs to be calculated. If the box is checked, then tax would be $0.00. d) invoice total field If these fields don't exist in a table somewhere, then just make them display-only on the order form. All should update as items are added to or removed from the order subform. The purpose of this part of the project is so that someone who is purchasing with a fixed ...
Since the last project on this database I have done the following: Added field 'volumeCustomer' - Y/N Deleted Volume Customer Order button from Home screen Sorted the data on Inventory List by Product Name (as default) Now I need the following work done: ORDERS FORM / SUBFORM 1) Can 'Product By Name' field be modified so that I can search the field for products that 'contain' my search text, not just beginning with search text? 2) Now that I added volumeCustomer to the Customers table, I want the item price to be pulled like so: List Price when the customer is VolumeCustomer TRUE, American Price when customer is VolumeCustomer FALSE but still getting special pricing for items in the tblCustPrice regardless. Display the value of ...
I plan to use the invoicing portion of the Northwind database from Access 2007. Most of the modifications I need are minor, some I assume are more significant. Below are the required functions/modifications. Create New Table 1) Table containing special pricing for each customer. ID CustomerID ProductID CustomerPrice On the Create New Order form (Order Details) 2) On the product dropdown list, I need to be able to scan a barcode to select an item (item number), but also be able to search an alphabetized list of item names if the item does not have a bar code. 3) On the line for the product and item costs, I would like the new table to be queried, so a special price column displays any special pricing. If special pricing exists for the customer for that item, then...
Ms Access 2010 Database: My business is a building supplying company from China to Australia. Want simular to Northwind template (included but maybe not so advanced) I am trying to setup a database that has employee list, product list, client base list, supplier/factory base list, & shipper base list, inventory list. From this list I need a number of forms generated Quote, Invoice, Order, Packaging , Inspection/Certifcation, Client update. These forms need to be simular in size format layout. I also need report generated for Client, Products, Inventory, Invoice client only, Invoice vendor only, I will be supplying a 1 to 2 line list for every list. John
Program using Delphi 2010 or Delphi XE or Delphi XE2. It has to use dbExpress (VCL) to connect to NORTHWIND sample database (MSSQL) and perform subsequent queries. ODBC profile for this NORTHWIND DB is to be used in SQL SERVER EXPRESS 2008. DB is provided in the Zipped file.
The project is for adding Bill Of Materials Modules and Capacity Planning Module for Northwind database in MS Access. Bill of Material module shall be for upto single level explosion. Version management and multiple BOM for same items are not required. Capacity planning module would also be basic level only of employees Vs production.
1. It must be developed using DevExpress ASP.NET version 11.2 components; 2. It must be better visualized on 1024x768 screen resolution; 3. The described functionalities should be developed using Microsoft’s Northwind database using the follow tables: Orders, Order Details and Categories. 4. It must be possible to create several configurations for database connections, like a database connection registry. 5. Layout configuration must be based on a CSS file. 6. All implementations must be delivered with documentation.
...it can by autonumber, the Detail table must have an ID and another field for the (the foreign key), and some other fields that you can add just to show how the app. works: a test field, let's say "Description", another number field, let's say "Amount", some boolean fields, let's say "Approved", and so on. If you want to use one of the demo databases that comes with SQL Server, like Northwind, is OK too. Q. You want to create users and their roles through some admin login? A. Yes, that is what we want. Q. What about roles, what if we create roles? Do different roles have different options? A. We want to use roles to allow users to edit some data, for example if the "invoice" is in "pending" sta...
1. It must be developed using DevExpress ASP.NET version 11.2 components; 2. It must be better visualized on 1024x768 screen resolution; 3. It...deleting, data activation, data deactivation, export, import, special execution. The visualization permission may be: visualizes own data, all data from his group (company or enterprise), all data in system. 7. System must be multi language, allowing localization for visualization of names, values, currency, date and time. 8. The described functionalities should be developed using Microsoft’s Northwind database 9. It must be possible to create several configurations for database connections, like a database connection registry. 10. Layout configuration must be based on a CSS file. 11. All implementations must be delivered with ...
SYSTEM OVERVIEW GENERAL 1. It must be developed using DevExpress ASP.NET version 11.2 components; 2. It m...deleting, data activation, data deactivation, export, import, special execution. The visualization permission may be: visualizes own data, all data from his group (company or enterprise), all data in system. 7. System must be multi language, allowing localization for visualization of names, values, currency, date and time. 8. The described functionalities should be developed using Microsoft’s Northwind database 9. It must be possible to create several configurations for database connections, like a database connection registry. 10. Layout configuration predefined and must be based on a CSS file. 11. All implementations must be delivered with documentation. 12. ...
I need someone fluent in Microsoft Access 2007. I have most of the project set up already, using Northwind Traders as a template. The main data for my database is ODBC based with read only permissions. I have several forms setup where I can view the data. One form in particular allows me to view "Order Details"... of orders placed in the past... I want to be able to create NEW orders - which will add data to a new table, looking just like the Order Details table. ## Deliverables I am using Northwind Traders sample of Access 2007 to create a database for our sales agents that is actually stemmed from another database platform (Fishbowl). We need a system for Sales Agents to review orders already made (available by ...
I have a simple working WCF .net 4 service that is simply returning data from Northwind (Visual Studio 2010 project) The service works fine and you don't need to do anything on the service. I have a html page called getdata.html... on that page are two jQuery functions that return data and build some simple html on the page... Funciton A works fine, function b is not returning any data. I need both functions to work on the getdata page and I need two separate html pages created that each contain one of the functions that works and brings back data. I'm not familar enough with jQuery so this is an easy quick project for someone familiar with jQuery and Visual Studio. Any questions let me know... I will send the project to winning bidder.
Modal Popup to pass parameters JavaScript Functions ## Deliverables Using: Sql 2008 VS2008 VB (Masterpages) Need for you to create a small project for demo purposes either using NorthWind Database, or just a couple of txtboxes and dropdownlist with list items, to show two criteria in using asp.net Modal Popups. Bare minimun controls using FormView. Will need either instructions or code comments. 1. Open Modal Popup from link (parent page) sending Parameter(s) ie:EmployeeID to the Popup. Popup will be a form using FormView, which will use the (s) to populate textbox in insert mode, or used in SQL Query to find (filter) a certain record. Close Popup when finished, and nothing is returned to Parent form. 2. JavaScript function using ASP.Net -MasterPages-Form...
im seeking help to complete an autocomplete functionality, simply a textbox where a user enters text and the filtered results are displayed in a listbox underneath from where the user can make a selection that populates the textbox. ive got some existing code whereby im attempting to call a web service from a jquery autocomplete function...attempting to call a web service from a jquery autocomplete function that passes the textbox string to a stored procedure to retrieve the values in a JSON string. however i can't get the autocomplete function to fire so am unable to progress any further with it. anyone who knows jquery and could help finish this would be appreciated. i can provide my code sample.... a stored procedure (Northwind db), jquery files, web service, asp...
I NEED SOMEONE TO TRAIN ME TO DESIGN A FULLY FUNCTIONAL NORTHWIND DATABASE APPLICATION WITH HELP OF ASP.NET. I WANT TO USE VS 2008, BE A MVC APPROACH. TRAINING CAN BE DONE WITH THE HELP OF SKYPE AND TEAM VIEWER TOGETHER.
Using VS 2005 - 2008 - 2010 - VB Sql Server 2005 - 2008 I'm trying to use dependent dropdownlist to populate 3 or more dowpdowns. This is a simple project, and the main purpose of the project is to create a demo to be used as a tool to understand the process flow. Look at the example at: http://www.asp...Mode didn't work and threw errors. Therefore I need to see a simple working example, with code commented enough to enable me to apply those techniques in my production project. You are to: 1. Create a simple project in VS 2008 VB 2. Create 3 or more dependent dropdownlist, using FormView 3. Create 2 example pages - One using Stored Procedure and one using SqlDataSource 4. Use Northwind DB for example purposes Please ask questio...
USING: SQL 2005-2008 VS 2005 - 2008 - 2010 VB I'm having problem, and can't seem to find any solutions using Google, to be able to pre-fill textboxes in FormViewInsert mode, using data from Table A, and saving form ...SQL 2005-2008 VS 2005 - 2008 - 2010 VB I'm having problem, and can't seem to find any solutions using Google, to be able to pre-fill textboxes in FormViewInsert mode, using data from Table A, and saving form contents into Table B. I need a small demo created showing the process, along with detailed instructions. Need an example using both EXEC Stored Procedure and a query, and using Northwind database. Form will be called with a link using QueryString value or Session value. Link(s) on non related page may call the form, and thus wo...
The finished article is to be exactly the same as the file attached. I will provide the database to be used to the winning bidder. I need the full source code and finished article as follows: Your task is to design and implement a Windows Form application that will allow a Sales Representative for Northwind traders to take orders via telephone from Northwind customers. You are already familiar with the Database. The following operations are to be implemented: Sales representative sign in (gets the employeeID for the session) Find the customerID, or create a new customer Create a new order (You can assume that the ShipAddress is the same as the customer address) Select Products, Quantity and enter any discount for Order_Details for the new created Order. Upon ...
...Manifests for the job listed and one billing date) I can have this in the form of a report 6) I also need a report itemizing what is owed to each subcontractor for the job in the billing week. 7) The info will then be transferred to Excel to ultimately go into quickbooks. Any easier way to get me all this data would be appreciated. I would love to put it online and make it loof like the northwind sample project access has to know who has edited. Only one-2 persons will be on the program at the same time. Please let me know if you do this and the cost at your earliest convenience....
