access work immediately done

En curso Publicado Dec 9, 2014 Pagado a la entrega
En curso

Working System--minimum criteria:

• A copy of your database. Please make sure you compact the MS-Access file. Name the file Team#[url removed, login to view] where Team# is your team's number and Teamname is the name you have chosen for your team. For example, if you are on Team # 9, your team name is ‘Clueless’, the file name would be 9_Clueless_M4.accdb. Send it to me as an email attachment or deposit it in the BlackBoard Dropbox.

• A multi-table data entry form with a subform that allows the user to view, edit, and enter data for a purchase order, including line items. Make the purchase order the basis for the form, not the manufacturer! Use drop-down menus and lookup fields to improve data entry accuracy. You should be able to add a new purchase order and its line items through this form;

• At least two multi-table queries that will be helpful to the user:

a. One query that displays each manufacturer and that manufacturer's purchase orders—pick fields that are relevant, and sort by the manufacturer's name and by the order date;

b. One query that displays an inventory item and its quantity on hand and value. Include fields that are relevant, and sort by category. This should be a parameter query that permits the user to specify a specific category, or just hit <Enter> for all categories;

• At least one multi-table report that shows the main table with details from the related table:

• As the data source, create a multi-table query that displays each manufacturer by ID and name, that manufacturer's purchase orders with net total, shipping & handling, and gross totals,, and the line items for each order, including the item names, quantity, and price. You might need a subreport (similar to a subform) to do this last task;

• Group by the manufacturer ID;

• Subgroup by the purchase order number;

• Include subtotals for each manufacturer's purchase orders, and for the entire report;

• In the report footer, summarize the value of inventory holdings by each product category;

• Include page headings and footers with report titles, column headings, page numbers and the date;

• Make sure to format the numbers with decimal alignment, and use and consistent formats; a good visual layout will be a plus;

• A switchboard or menu system that automatically opens when the application starts, hides the database window, and allows the user to select:

• The data entry form(s) you create;

• The queries you create;

• The report your create—please display them in preview mode;

• Close the switchboard, open the database window, and return to the database;

Administración de bases de datos Ingeniería Microsoft Access SQL

Nº del proyecto: #6844911

Sobre el proyecto

4 propuestas Proyecto remoto Activo Dec 13, 2014

Adjudicado a:

danangvw

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 administ Más

₹100 INR / hora
(9 comentarios)
2.0

4 freelancers están ofertando un promedio de ₹247 / hora por este trabajo

rajafaizan

Hello sir...i am very much interested in this project and I have much of experience for this project. my expertise lies in quality service and delivery on Time i guarantee you 100% satisfaction. kindly if you wants hig Más

₹333 INR / hora
(1 comentario)
1.8
madhu2591

Myself Madhura Kochrekar, B. Tech in Computer Science and Technology, working In ITSource technologies , Mumbai . India. I would like to work on Projects in Java , Software testing , Software development. I am a sincer Más

₹277 INR / hora
(0 comentarios)
0.0
vkrisreddy

Hi, I have good experience in creating user forms in Access. Have good knowledge on SQL. I have created many tools in Access for a MNC.

₹277 INR / hora
(0 comentarios)
0.0