Access Database Project

ORDER NOW

INDIVIDUAL ACCESS PROJECT GUIDELINE CIS 310 Management Information System

TRANSACTIONAL APPLICATION-DATABASE

Students will create a simple Airline application using Microsoft Access. The application will demonstrate the ability of an application database to capture, store, and report on data and information.
Operational Management Information System (Microsoft Access) – 100 points
Your final Microsoft Access project file will include the following components. Specific instructions, concepts, expectations, and demonstration will be provided during scheduled class lecture time as stated in the syllabus. It is highly recommended that you attend all scheduled class sessions to obtain all the necessary skills and understanding to complete this assignment.
Database Tables & Attributes Requirement:
• Manufacture Table – Database table capturing and storing aircraft manufactures data with the following attributes o
ManufacturerID – Primary Key (Required Field - Auto Increment - Number)
ManufactureName – Text (Required Field)
ManufactureAddress – Text (Required Field)
ManufactureCity – Text (Required Field)
ManufactureState – Text (Required Field)
ManufactureZipCode – Text (Required Field – Zip Code Input Mask Format )
ManufacturePhoneNum – Text (Required Field – Phone Number Input Mask Format)
• Airplanes Table – Database table capturing and storing airplane data with the following attributes o
AirplaneNumber – Primary Key (Required Field - Auto Increment - Number)
AirplaneModel – Text (Required Field)
AirplaneManufacturer – (Foreign Key attribute)
AirplaneServiceStartDate – Date/Time (Required Field)
AirplaneEndOfLifeDate – Date/Time (Required Field)
AirplaneNumSeats - Numbers (Required Field)

• Airports Table – Database table capturing and storing airport data with the following attributes

AirportID – Primary Key (Required Field - Auto Increment)
AirportName – Text (Required Field)
AirportCode – Text (Required Field – Only Allow 3 Characters at Input)
AirportAddress – Text (Required Field)
AirportCity – Text (Required Field)
AirportState – Text (Required Field)
AirportZipCode – Text (Required Field – Zip Code Input Mask Format ) AirportPhoneNum – Text (Required Field – Phone Number Input Mask Format)

• AirplaneFlightSchedule Table – Database table capturing and storing flight schedule (which plane is scheduled to be at which airport) for each plane with the following attributes

ScheduleID – Primary Key (Required Field - Auto Increment)
AirplaneNumber – (Foreign Key attribute)
FlightOrginAirportNum - (Foreign Key attribute)
FlightDestAirportNum - (Foreign Key attribute)
DepartureDate - Date/Time (Required Field)
DepartureTime - Date/Time (Required Field)
ArrivaleDate - Date/Time (Required Field – Input Mask Format to 01:00 AM)
ArrivalTime - Date/Time (Required Field – Input Mask Format to 01:00 AM)
Application User Interface - Forms and Features Requirements:

• Manufacturers Form – User interface to add and update aircraft manufacturer information to the database
• Airplanes Form – User interface to add and update airplane information to the database – the form must allow users to pick from a drop down list (combo box) from the manufactures in the database that produced the airplane
• Airports Form – User interface to add and update airport information to the database
• FlightSchedule Form – User interface to add and update flight schedules for each aircraft in the database
o HINT: A subform titled “AirplaneFlightSchedule subform” will be created to address the many-to-many relationship between airplane and airport entities in the database design for this form
o NOTE: The AirplaneFlightSchedule subform on the FlightSchedule Form needs to allow users to pick an Orgin Airport from a drop down list (combo box) AND allow users to pick a Destination Airport from a drop down list
(combo box) containing all the available airports in the database o
NOTE: Your Airport drop down list should show the following for the users to see
 AirportNumber
 AirportName
 AirportCode o NOTE: Your AirplaneFlightSchedules Form needs to allow users to enter multiple flight schedules for each aircraft – users of your FlightSchedule Form will be able to plan multiple flights for each airplane in this form

Report Required:

• Flights Schedule Report – Report that shows each aircrafts flight schedule o
NOTE: The report must show each aircraft and below each aircraft it should list all the flight schedules planned for the aircraft
HINT: The report is Grouped by aircraft
NOTE: The report should show AirplaneNumber, AirplaneModel, and NumberOfSeats o NOTE: The report should show ScheduleID, OrignAirportNum, DepartureDate, DepartureTime, DestAirportNum, ArrivalDate, ArrivalTime o
HINT: Use report design view to space out the report and landscape to display all the info on the report


Grading will focused on:

• Complete fields (required fields) with correct field format (data type) in the database table design – 2 points for each missing field or formatting error
• Accurate database tables relationship design (Entity Relationships Diagram) – 5 points per relationship that is linked incorrectly or missing
• Functionality of all the User Forms and accuracy of storing user inputs into database tables – 3 points per field on the forms that do not store user entered data into the table correctly from the forms o – 3 points for each missing drop down list for users to select Manfacturer, Origin Airport, and Destination Airport on the forms
• Accuracy and completeness of information presented in the Report – 2 points for each missing information/data element on the report