Em Andamento

access work immediately done

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;

Habilidades: Administração de Bancos de Dados, Engenharia, Microsoft Access, SQL

Ver mais: work close, sql inventory system, sql data entry form, sql create table price, purchase order number example, ms lookup, ms access work, ms access purchase order system, ms access purchase order database, ms access form data entry, ms access data entry form, hit data entry, example of inventory database, data entry form in access, create data entry form access, create an access form for data entry, access subform data entry, access purchase order system, access group, access data entry form, access database purchase order system, access database data entry form, engineering team names, access subform, engineering report format

Acerca do Empregador:
( 121 comentários ) Calcutta, India

ID do Projeto: #6844911

Premiar 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 Mais

₹100 INR / hour
(9 Avaliações)
2.0

4 freelancers are bidding on average ₹247/hour for this job

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 Mais

₹333 INR / hour
(1 Comentário)
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 Mais

₹277 INR / hour
(0 Comentários)
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 / hour
(0 Comentários)
0.0