AIRPORT RESERVATION SYSTEM

Project report submitted in partial fulfillment of the

requirements for the Degree of

Bachelor of Computer Application

By

Gnahoua Zoro Leandre 08P4SB3026

Kouadio Serges Landry 08P4SB3027
Kouakou Etibo Jean Marc 08P4SB3028

Under the Guidance of

INDO ASIAN ACADEMY

#10, 4th D MAIN HRBR Layout, Bangalore 560043

Hotel Management System Year 2009 –
2010

INDO ASIAN ACADEMY DEGREE COLLEGE

#10, 4th D Main, HRBR Layout, 2nd Block, Kalyan Nagar Bangalore 560043; ph: 25429691

DEPARTEMENT OF COMPUTER SCIENCE

This is to certify that the project entitled “Airport reservation System” is the bonafide
project work carried out by Gnahoua Zoro Leandre, Kouakou Etibo Jean Marc and Kouadio
Serges Landry of 5th semester BCA.

Students of Indo Asian Academy, during the year 2010-2011 in partial fulfillment for the
requirement of the award of the Bachelor of Computer Applications from Bangalore University.

Faculty in charge: …………………… HOD (dept of comp sc): ……………………

Examiner: ……………………

1.

2.

Page 2
Hotel Management System Year 2009 –
2010

1/ ACKNOWLEDGEMENT 4

2/ SYNOPSIS 5

3/ INTRODUCTION TO VISUAL BASIC 6.0 7

4/ INTRODUCTION TO DBMS

5/ HARDWARE AND SYSTEM REQUIREMENTS

6/ AIRPORT RESERVATION DATABASES

7/ SCREENSHOTS

8/ CODING

9/SCOPE FOR IMPROVEMENTS

10/CONCLUSION

11/ BIBLIOGRAPHY

Page 3
Hotel Management System Year 2009 –
2010

The satisfaction of completing this project successfully would remain incomplete without the
mention of those people who made this possible and whose constant encouragement and
guidance has helped immensely in the development of this project.

We take this opportunity to express our heartfelt gratitude to ………… for his moral support.
A project like this requires support and understanding in big measures. Our sincere thanks go
out to …………. for her continual support and valuable suggestions. It is due to her efforts that
our project has been developed successfully.

We also thank all those who have contributed their efforts, either big or small towards the
completion of this project. And last but not the least, our heartfelt gratitude to our families and
friends and to the almighty for their unending love.

Page 4
Hotel Management System Year 2009 –
2010

The software “Airport Reservation System” is implemented in Visual Basic 6.0 as the
front end and Microsoft Access as the Back end. It deals with all the operation of Airport
Reservation (Flight status, customer registration, flight registration, Booking)

During the past several decades’ personnel function has been transformed from a
relatively obscure record keeping staff to central and top level management function. There are
many factors that have influenced this transformation like technological advances,
professionalism, and general recognition of human beings as most important resources.

• A computer based management system is designed to handle all the primary information
required to save the national and international flights and also the customer of the airline
company. Separate database is maintained to handle all the details required for the correct
statement calculation and generation.

• This project intends to introduce more user friendliness in the various activities such as record
update, maintenance, and searching of flight and customer.

• The searching of record has been made quite simple as all the details of the customer can be
obtained by simply keying in the identification of that customer.

• Similarly, record maintenance and update can also be accomplished by using the identification
of the customer with all the details being automatically generated. These details are also being
promptly automatically updated in the master file thus keeping the record absolutely up-to-date.

• The entire information has maintained in the database or Files and whoever wants to retrieve
can’t retrieve, only authorization user can retrieve the necessary information which can be
easily be accessible from the file.

Airport Operations:

Using this software, operator can book a flight for a specify client’s needed (specifying
the date of departure and the destination country along with the client’s details).

He / She can also make a cancel as the client wants to cancel a flight. The booking flight
status gets update when an operation is made.

Page 5
Hotel Management System Year 2009 –
2010

Reservation /Cancellation

In the reservation, the status of the available flight gets automatically updated when a
new reservation is done.

Status

 Flight status

It provides all the information regarding the status of any flight such as national flight,
international flight, one way flights, round trip flight.

Page 6
Hotel Management System Year 2009 –
2010

Visual Basic (VB) is the third-generation event-driven programming

language and integrated development environment (IDE) from Microsoft for
its COM programming model. VB is also considered a relatively easy to learn and use
programming language, because of its graphical development features and BASIC heritage.
Visual Basic was derived from BASIC and enables the rapid application development
(RAD) of graphical user interface (GUI) applications, access to databases using Data Access
Objects, Remote Data Objects, or ActiveX Data Objects, and creation of ActiveX controls and
objects. Scripting languages such as VBA and VBScript are syntactically similar to Visual
Basic, but perform differently.[2]
A programmer can put together an application using the components provided with
Visual Basic itself. Programs written in Visual Basic can also use the Windows API, but doing
so requires external function declarations.
The final release was version 6 in 1998. Microsoft's extended support ended in March
2008 and the designated successor was Visual Basic .NET (now known simply as Visual Basic).

Features of Visual Basic:

 Visual Basic is a flexible, high level, structured programming language.

 Visual Basic includes certain low level features that are normally available only in
assembly or machine language.

 Visual Basic is widely available, commercial interpreter are available for most
personal computer, mini computers and main frames.

 Visual Basic is largely machined independent. Programs written in visual basic are
easily ported from one computer to another.

 Your programs interface may include the familiar controls that window users
already know how to operate-such as command buttons, option list, text boxes and
scroll bars.

 With just a few mouse actions, you can add any combination of these controls to a
program.

 As a result design tasks that used to require many hours of detailed programming
efforts can be completed in minutes.

Page 7
Hotel Management System Year 2009 –
2010

 In Visual Basic you can quickly design the visual elements of any new
programming project.

The Programming Process:

These standards steps are to be followed while creating Visual Basic Programs:

1. Deciding what your application is done by creating an overall design.

2. Creating the Visual Basic portion of the application (the serene and menus that the
users will interact with)
3. Adding the Visual Basic programming language code to tie the Visual Basic
elements together and to automate the program.
4. Testing the application to locate and remove any bugs.
5. Compiling the tested application and distribute the compiled application to the end
users.

Visual basic includes a special helpers system called a debugger that the programmer can use to
help locate bugs that appear during testing. The debugger is an interactive monitoring system
that you turn on and off inside Visual Basic that helps you to locate statements that may contain
bugs.

♦Programming Maintenance

Apart from the bugs, the programmer has to maintain the program he /she has created. Program
Maintenance is a term used for the updating of a program after the program after the program is
put into use. This updating may be a result of the users request or a change in the way the
program needs to operate.

♦Project

A project is a collection of files that make up your application. A single Application might
consist of several files and the project is the collection of those files.

♦Multiple Documents Interface (MDI)

Page 8
Hotel Management System Year 2009 –
2010

It allows the application to contain multiple documents windows. In effect, this interface lets
your work with several sets of data in multiple windows within the program. Each document
window is called a child window.

♦ Single Document Interface (SDI)

It limits the application take on a window Explorer- like interface with topic summaries in the
left window and details for a selected topic in the right pane.

Microsoft Office Access, previously known as Microsoft Access, is a relational database

management system from Microsoft that combines the relational Microsoft Jet Database

Page 9
Hotel Management System Year 2009 –
2010

Engine with a graphical user interface and software development tools. It is a member of
the Microsoft Office suite of applications, included in the Professional and higher editions or
sold separately.
Access stores data in its own format based on the Access Jet Database Engine. It can also
import or link directly to data stored in other Access databases, Excel, SharePoint lists, text,
XML, Outlook, HTML, dBase, Paradox, Lotus 1-2-3, or any ODBC-compliant data container,
including Microsoft SQL Server, Oracle, MySQL and PostgreSQL. Software
developers and data architects can use it to develop application software, and "power users" can
use it to build simple applicationsLike other Office applications, Access is supported by Visual
Basic for Applications, an object-oriented programming language that can reference a variety of
objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX
components. Visual objects used in forms and reports expose their methods and properties in
the VBA programming environment, and VBA code modules may declare and call Windows
operating system functions.
Access version 1.0 was released in 13 November 1992, quickly followed in May 1993 by
an Access 1.1 release to improve compatibility with other Microsoft products and include the
Access Basic programming language.
The native Access database format (the Jet MDB Database) has also evolved over the
years. Formats include Access 1.0, 1.1, 2.0, 95, 97, 2000, 2002, and 2007. The most significant
transition was from the Access 97 to the Access 2000 format; which is not backward
compatible with earlier versions of Access. At the time of this writing, all newer versions of
Access support the Access 2000 format. New features were added to the Access 2002 format
which can be used by Access 2002, 2003, and 2007.
Prior to the introduction of Access, the desktop database market was dominated
by Borland with their Paradox and dBase programs, and FoxPro. Microsoft Access was the first
mass market database program for Windows. With the purchase of FoxPro and incorporating its
Rushmore query optimization routines into Access, Microsoft Access quickly became the
dominant database for Windows effectively eliminating the competition which failed to
transition from the MS-DOS world.[1]
Microsoft Access is used to create simple database solutions. Access tables support a
variety of standard field types, indices, and referential integrity. Access also includes a query
interface, forms to display and enter data, and reports for printing. The underlying Jet database,
which contains these objects, is multiuser-aware and handles record-locking and referential
integrity including cascading updates and deletes.

Page
10
Hotel Management System Year 2009 –
2010

Simple tasks can be automated through macros with point-and-click options. Microsoft Access
is very popular among non-programmers who can create visually pleasing and relatively
advanced solutions on their own. It is also easy to place a database on a network and have
multiple users share and update data without overwriting each other’s work. Data is locked at
the record level which is significantly different from Excel which locks the entire spreadsheet.
Microsoft offers a wide range of template databases within the program and for download
from their website. These options are available upon starting Access and allow users to quickly
use and enhance a database with pre-defined tables, queries, forms, reports, and macros. Popular
templates include tracking contacts, assets, issues, events, projects, and tasks. Templates do not
include VBA code.
Microsoft Access also offers the ability for programmers to create solutions using
the programming language Visual Basic for Applications (VBA), which is similar to Visual
Basic 6.0 (VB6)and used throughout the Microsoft Office programs such
as Excel, Word, Outlook and PowerPoint. Most VB6 code including the use of
Windows API calls can be used in VBA. Power users and developers can extend basic end-
user solutions to a professional solution with advanced automation, data validation, error
trapping, and multi-user support.
Database solutions created entirely in Microsoft Access are well suited for individual
and workgroup use across a network. The number of simultaneous users that can be supported
depends on the amount of data, the tasks being performed, level of use, and application design.
Generally accepted limits are solutions with 1 GB or less of data (Access supports up to 2 GB)
and 50 or fewer simultaneous users. This is appropriate for workgroup and department
solutions where the total number of users number a few hundred.
Applications that simply view data or have simple data entry can support considerably
more users. Applications that run complex queries or analysis across large datasets would
naturally require greater bandwidth and memory. Microsoft Access is designed to scale to
support more data and users by linking to multiple Access databases or using a back-
end database like Microsoft SQL Server. With the latter design, the amount of data and users
can scale to enterprise-level solutions.
Microsoft Access' role in web development prior to version 2010 is limited. User
interface features of Access, such as forms and reports, only work in Windows. The Microsoft
Jet Database Engine, core to Access, can be accessed through technologies such
as ODBC or OLE DB. The data (i.e., tables and queries) can be accessed by web-based

Page
11
Hotel Management System Year 2009 –
2010

applications developed inASP.NET, PHP, or Java. Many ISPs offer Microsoft Access as a data
storage option.

Page
12
 Hotel Management System Year 2009 –
2010

HARDWARE REQUIREMENTS: -

 Min. 16 MB RAM.
 Min 1 MB of Display Card.
 Min. 100 MB free space on the Hard Disk.
 At least Color Monitors.
 Pentium III or equivalent

SOFTWARE REQUIREMNETS: -

 VISUAL BASIC
 MS ACCESS
 MINIMUM WINDOWS XP AND ABOVE.

Table Design

Page
13
Hotel Management System Year 2009 –
2010

Splashscreen

Page
14
Hotel Management System Year 2009 –
2010

Page
15
Hotel Management System Year 2009 –
2010

Page
16
Hotel Management System Year 2009 –
2010

Nowadays Airport Reservation systems are providing many other facilities, this
project can also be improved with the improvement in the Airport Company.

Utmost care and back-up procedures must be established to ensure 100%

successful implementation of the computerized Airport Reservation system. In case of system
failure, the Airline company should be in a position to process the transaction with another
company or if the worst comes to the worst.

Page
17
Hotel Management System Year 2009 –
2010

We confidently say that part of the application developed by us is working properly and
does work efficiently when put to the real use.

The application is a user-friendly system, which has been developed using Visual Basic
6.0 and MS Access.

We have tried our best to make the complicated process of Airport reservation system as
simple as possible using Structured & Modular technique & Menu oriented interface. We have
tried to design the software in such a way that user may not have any difficulty in using this
package & further expansion is possible without much effort. Even though we cannot claim that
this work to be entirely exhaustive, the main purpose of our exercise is perform each
Employee’s activity in computerized way rather than manually which is time consuming.

We are confident that this software package can be readily used by non-programming
personal avoiding human handled chance of error.

Page
18
Hotel Management System Year 2009 –
2010

This section gives you the name of the books required for the
development of the project.

NAME OF THE BOOK AUTHOR NAME

1. Simply Visual Basic 2008 Michael Halvorson

2. Programming in Visual Basic Julie Case Bradley

3. Pro VB 6.0 Andrew Troelsen

 http://www.profsr.com/vb/vbintro.htm

 http://www.techaddicted.net/

Page
19
Hotel Management System Year 2009 –
2010

Page
20