Reference no: EM132558930
COMP 20006 Front End Applications Development - Middle East College
Learning Outcome 1: Write event-driven programs with the support of an integrated development environment
Learning Outcome 2: Build and deploy database applications using ADO.Net
Learning Outcome 3: Design reports using Crystal Reports
Assignment Objective
This is an individual assignment aimed to give students the experience to use visual programming language, create simple graphical user interfaces (GUI), and develop data connectivity using AD.Net and design crystal reports within an applications environment.
Assignment Tasks
1) Submit a work proposal for this assignment which must include:
• Understanding of deliverables - a detail description of deliverables.
• General overview of proposed plan - initial understanding of solution to task2.
• Timeline for completion of the given tasks
• References (CU Harvard style) and it should be MEC r-resources
2) VB.Net application
You have to design your VB.Net Application appropriately and use different controls (like button, textbox, listbox, combo box, radio buttons, DataGridView, Crystal report viewer and panel, etc.,) in your application. Your application should include the ALL requirements stated below.
Requirements
Create and Design a VB.Net application that will include the following:
1. Create and Design a database in MS Access or any other Relational database system that will include the following;
• At least one (1) table with minimum six (6) columns with proper data type
• Insert at least 15 appropriate records
2. Maintenance form
• Appropriate use of components such as labels, buttons, text fields, panel and data grid to present the interface as per the scenario
• Trigger events for the different buttons
o Add -adding elements based on the chosen information system and records must be stored in the database
o Delete -deleting elements based on the chosen information system and records must be deleted in the database.
o Update - Upon opening the form, all fields should not be enabled to do any changes and when updating a record, a form or an input box can be used to make the changes. Records must be updated in the database
o View/Display -User view/display all the data.
o Clear - remove all existing contents from the fields
o Exit -existing the application
• At least 2 panels with appropriate layout to enhance the interface presentation
• Ensure to connect and access your database in doing the maintenance
• There should be a function/procedure to be called in this form while updating records are being done.
3. Transaction form
• A form where users can use the records in the database to do some transactions.
• Appropriate use of components such as labels, fields and buttons to represent the interface as per the scenario
• Trigger events for the different buttons
o Calculate -A transaction activity needs to be implemented in this form such as calculations, error messages, (for example of HRIS system Total Salary = BasicPay + HRA) etc. Make use of message boxes for displaying error messages with regard to your chosen application.
o Clear - remove all existing contents from the fields
o Exit -existing the application
• At least 2 panels with appropriate layout to enhance the interface presentation
• Ensure to connect and access your database in doing the transaction.
• There should be a function/procedure to be called in this form while updating records are being done.
4. Crystal Report-Create simple report that can be generated from your database through your application and export any of the reports to MS Word/MS Excel/pdf/Text format.
3) Prepare a document to present the work done of all tasks. The report should consist of the following
• A cover page to identify your work (Student ID, Student Name, Module Code, Module Name)
• Table of content for your report
• Clear label and introduction of each task followed by the coding of that task. Include comments wherever possible to enhance the clarity of your coding
• Ensure proper formatting of your report
Attachment:- Front End Applications Development.rar