AIRWAY RESERVATION SYSTEM

A Project report submitted to Arulmigu Palaniandavar Arts College for

Women, Palani in partial fulfillment of the requirement for the Award of
Degree of
BACHELOR OF COMMERCE
(COMPUTER APPLICATION)
Submitted by

A.MALATHI
(REGISTER NO: 22PUCAA12)

Under the Guidance of

Dr.Ms.R.Deepa
Assistant Professor,PG And Research Department of Commerce

PG AND RESEARCH DEPARTMENT OF COMMERCE

ARULMIGU PALANIANDAVAR ARTS COLLEGE FOR WOMEN
(Autonomus)
Re-accredited with ‘A’ by NAAC
Run by Hindu Religious and Charitable Board
Under the Aegis of
Arulmigu Dhandayuthapani Swami Thirukovil, Palani (Affiliated to Mother Teresa
Women's University, Kodaikanal) Chinnakalayamputhur, Palani - 624615.

April-2025
CERTIFICATE
 CERTIFICATE

This is to certify that the project work entitled ―AIRWAY

RESERVATION SYSTEM” submitted to Arulmigu Palaniandavar Arts
College For Women, Palani, in Partial fulfillment of the requirements for the
award of the degree of Bachelor of Commerce (Computer Application) is
record of original research work done by A.Malathi (Register
No:22PUCAA12) during the period 2024-2025.

SIGNATURE OF THE GUIDE SIGNATURE OF THE HOD

Submitted for the Viva – Voce examination held on______________________

EXTERNAL EXAMINER
ACKNOWLEDGEMENT
 ACKNOWLEDGEMENT

I express my sincere thanks to the Almighty for all the blessings showered on
me.

I owe my sincere thanks to our Principal Dr.(Mrs) N.PUVANESWARI,

M.Sc., M.Phil., Ph.D.,. Arulmigu Palaniandavar Arts College For Women, Palani
for having permitted us to under go the project work.

I extremely thankful to Dr.(Mrs)N.SUMITHRA DEVI, M.Com., M.Phil.,

MBA., PGDCA., Ph.D., Head of PG and Research Department of Commerce for
her support and encouragement in completing the project successfully.

I sincerely thank the research guide Mrs.DEEPA, M.Phil., Assistant

professor, PG and Research Department of Commerce, Arulmigu Palaniandavar
Arts College For Women, Palani for inspiring guidance and encouragement to
complete the research work in a successful manner.

I extremely thankful to all staff members of PG and Research Department of

Commerce for their support and assistance provided to complete the research
work.

I deeply thank my parents, family members, respondents and friends for their
support in preparing this project work.

Above all I thank the almighty for the blessings showered on me all throughht
the execution of the project work.

RESEARCH (INDIVIDUAL)
 TABLE OF CONTENTS

CHAPTER TITLE PAGE NO.

ABSTRACT
1 INTRODUCTION
1.1 PROJECT DESCRIPTION
2 SYSTEM SPECIFICATION
2.1 HARDWARE SPECIFICATION
2.2 SOFTWARE SPECIFICATION
3 LANGUAGE SPECIFICATION

3.1.VISUAL BASIC 6.0

3.1.1 Introduction
3.1.2 The integrated development environment

3.2. MICROSOFT ACCESSS

3.2.1. Introduction
3.2.2. Features of MS Access
3.1.3. MS Access Usability Hierarchy
3.1.4. Additional features of MS Access
3.1.4. A review of database concepts

4 DATABASE DESIGN
5 SAMPLE SCREENSHOTS
6 SAMPLE CODING
7 CONCLUSION
8 BIBLIOGRAPHY
 ABSTRACT

This project entiled as ―AIRWAY RESERVATION SYSTEM‖ is

designed by using visual basic as front end and access as back end. The project
is used by the customers or people. This project through customers or people
can easily login in the Airway reservation. The admin can view the different
kinds of packages and easily ,register under their choices . Customers are daily
motivated by this Quotes Of The Day button. Customers or people easily get
the daily updates using this project.
 INTRODUCTION

The entire project has been developed keeping in view of the

distributed client server computing technology, in mind. The specification has been
normalized up 2NF to eliminate all the anomalies that may arise due to the database
transaction that are executed by the general users and the organizational
administration. The user interfaces are browser specific to give distributed
accessibility for the overall system. The internal database has been selected as
database MS Access.

The Airline Reservation System project is an implementation of a general

Airline Ticketing website like Orbitz, which helps the customer to search the
availability and prices of various airline tickets, along with the different packages
available with the reservations.
This project also covers various features like online registration of the
users, modifying the details of the website by the management staff or administrator
of the website by adding deleting or modifying the customer details flights or
packages information in general this website would be designed to perform like any
other airline ticketing website available online.
 1.1 PROJECT DESCRIPTION

The Project ―Airway reservation Management System‖ contains the following

modules
They Are

 Login Module
 Customer reservation Module
 Cancellation Module
 Postpone Module
 Feedback

MODULE1:(Login Module)
In this module the User can enter their user name, password , to login into the
application.

MODULE2:(Reservation Module)
In this module the user can select and book their flight. And the Administrator
can view the booking details .

MODULE3:(Cancellation Module)
In this module the user can enter their personal details which they given
during booking and cancel the flight.

MODULE4:( Postpone Module)

In this module the user can enter their personal details which they given during
booking and postone the flight.

MODULE5:( Feedback Module)

In the module the user can give feedback about their experience and the flight.
 2. SYSTEM SPECIFICATION

2.1 HARDWARE SPECIFICATION (Minimum Requirement)

1) PROCESSOR :Intel® Core ™ i5-2520M
2) RAM : 40GB or Above.
3) HARD DISK : 160 GB
4) MONTOR : 15’inch LCD Monitor.
5) CD DRIVE : DVD Writer
6) KEY BOARD : Multimedia Keyboard
7) MOUSE : Wireless Mouse

2.2 SOFTWARE SPECIFICATION (Minimum Requirement)

1) Front End : Visual Basic 6.0
2) Back End : Microsoft Access Database 2007.
3) Operating System : Windows XP
LANGUAGE SPECIFICATION
 3.LANGUAGE SPECIFICATION

3.1. VISUAL BASIC PROGRAMMING

Visual Basic (VB) is the fastest and easiest way to create applications for
MS Windows. Whether you are an experienced professional or brand new to
Windows programming, VB provides you with a complete set of tools to simplify
rapid application development.

3.1.1. INTRODUCTION

The ―Visual‖ part refers to the method used to create the graphical user
interface (GUI). Rather than writing numerous lines of code to describe the
appearance and location of interface elements, you simply put prebuilt objects
into place on screen.
The ―Basic‖ part refers to the BASIC (Beginners All-purpose Symbolic
Instruction Code) language. We need to notice that VB has evolved from original
BASIC language and now contains several hundred statements, functions, and
keywords, many of which relate directly to the Windows GUI.
The VB programming is not unique to Visual Basic. The following
applications or programming also used VB:
• VBA in MS Word, Excel, and Access
• VB Script for web-based programming
• Visual Basic Concepts

Visual Basic, derived from the Basic language, is an object-

based and event- driven programming language from Microsoft. This
language is relatively easy to learn. It enables you to create GUI
(Graphical user interface) applications easily using the Rapid
Application Development (RAD) technique. The one most interesting
feature of this language is that it comes with a designer called
Integrated Development Environment (IDE). The easy-to-use tools of
the IDE enable you to easily create buttons, textbox, and other controls
for your desktop application.

Visual Basic 6.0 is a very powerful programming language. It

enables GUI application development, provides access to databases and
enables the creation of ActiveX controls.
In addition, Visual Basic 6 is Event-driven because we need to write
code in order to perform some tasks in response to certain events. The
events usually comprises but not limited to the user's inputs. Some of the
events are load, click, double click, drag and drop, pressing the keys and
more. We will learn more about events in later lessons. Therefore, a
VB6 Program is made up of many subprograms, each has its own
program code, and each can be executed independently and at the same
time each can be linked together in one way or another.

Start New Project

Run the Visual Basic software from the list of programs.

 Click "Standard EXE". Start a Standard .exe type ofproject. In the
beginner level, you will only learn about this type of project.

Other project types on this window are for the advanced learners.
You can do a lot of things implying VB6 is giving you enough power
in your hand through these different project types.

3.1.2.THE INTEGRATED DEVELOPMENT ENVIRONMENT

After this, the main workspace appears where you will develop
your application with the tools in IDE (Integrated Development
Environment).

It is very important to know the names of all the elements of this

development environment. The tools available here makes it very easy for you
to develop an application. The VB6 IDE provides you many tools in one
place. You can add a control on the form of your choice, set a property of an
object from the Properties Window on the right hand side, set the form layout
and many more things that you can use alongside your coding. You can even
fill the ToolBox with lots of additional controls.
 1) The Menu Bar

The Menu Bar contains all the menu such as File, Edit, View, Tools and soon.

2) The Tool Bar

The Tool Bar contains all the tools such as Open, Save, Copy,
Cut. Start and so on.

3) The Tool Box

4) View Code Window

Double-click on form or any control on the form or click "view code"
iconin explorer window to view the code window.
 5) Save project

After developing your application, save your project in order to modify

or improve it later, or make an executable file with a few clicks. The
project, form and module are saved in .vbp, .frm and .bas extensions
respectively.

The Properties Window

 6) The Project Explorer Window

The Project Explorer Window gives you a view of the modules or forms
which are contained in your VB application. You can switch from one form
to another or from one module to another from the Project Explorer
Window. You can view the code window of a particular form or module as
well.

7) The Code Window

You need the Code Window to write code that will specify the behavior
of the forms and the objects. Remember that the Form is an object.

The Immediate Window helps in debugging your program by

displaying the current values of variables or expressions in a certain
line of your code.
 8) The Object Browser

Press F2 to showtheObject Browser Window.It is veryuseful because

youcan learn about all the methods, functions, properties and events of the
objects. If you want to know about any property, method, event, function
etc, simply search in the Object Browser.

9) Label
The label control is used to display text. It is also used to label other
controls. The enduser cannot edit the label text.

10) Command Button:

The Command Button control is simply abut to nthat we see in our

daily-use software. When the end-user clicks the Command Button, the
program behaves according to the code assigned in the Common Button.
 11) Option Button

This control enables the end-user to select one among several

options.Only one option button among others in a group can be on at
the same time.You can name an option using the Caption property.

12) Check Box

The Check Box control is used to make a yes/no or true-false

selection. You can check more than one Check Box at the same time
that let you make multiple choices. You can label this control using the
Caption property.

13) Vscroll Bar & Hscroll Bar

Vscroll Bar and Hscroll Bar control slet you create Verticalscroll bar
and Horizontal scroll bar respectively.

14) Frame

The Frame control is used as a container of other controls. This is

also used to group different controls especially in Option Button
controls when you wish to select more than one option. The Caption
property associated with it is useful to label the frame.

15) ListBox & ComboBox

The ListBox control contains a number of items. The user can select
one or more items from the list.

16) Drive List Box , Dir ListBox &File ListBox

These controls are of tenused together to perform filerelate task s like

opening or selecting files that are stored in the secondary memory.
 17) Timer

The Timer control is not visible on the form when you run the
program. It is used to execute lines of code repeatedly at specific
intervals.

18) The Data Control

The Data control isused for database programming.

19) Back Color and Fore Color

The Back Color property sets the background color of an object

while the ForeColor property changes the foreground color used to
display text.
 It is necessary for us to have a better understanding some of the key
concepts VB has built. A simplified version of the workings of Windows
involves three key concepts – windows, events, and messages.
command buttons
• icons
• text boxes
• option buttons, and
• menu bars

 The MS Windows operating system manages all of these many windows

by assigning each one a unique id number (window handle or hWnd).
Events can occur through user actions such as mouse click or a key press,
through programmatic control, or even as a result of another window’s
actions. Each time an event occurs, it causes a message to be sent to the
operating system. The system processes the message and broadcasts it to
the other windows.
  In traditional or procedural applications, the application itself controls
which portions of code execute and in what sequence. Execution starts
with the first line of code and follows a predefined path through the
application, calling procedures as needed.
 In an event-driven application, the code does not follow a predetermined
path – it executes different code sections in response to events. Events can
be triggered by:

• The user’s actions,

• Messages from the system or other applications, or - event from
the application itself.
• VB Integrated Development Environment

VB Integrated Development Environment (IDE) integrates many different

functions such as design, editing, compiling, and debugging within a common
environment while each of these tools would operate as a separate program in a
traditional development environment.

20) Object browser

• Code editor window
• Form layout window – allows you to position the forms in your
application using a small graphical representation of the screen.
• Immediate, Locals, and Watch windows under View menu are used for
debugging.

21) Environment Options

VB provides a great deal of flexibility, allowing you to configure the working
environment to best suit your individual style. Two different styles are available
for the VB IDE:
• single document interface (SDI): with SDI, all of the IDE windows are free
to be moved anywhere on screen.
• Multiple document interface (MDI): all of the IDE windows are contained
within a single resizable parent window.

 To switch between SDI and MDI modes, Select Options from the Tools
menu. The Options dialog box is displayed.
• Select the Advanced tab.
• Check or uncheck the SDI Development Environment check box.
• The IDE will start in the selected mode the next time you start Visual
Basic.
3.2 MICROSOFT ACCESS
3.2.1 INTRODUCTION

Microsoft Access (MS Access) is a Relational Database Management

System (RDBMS) developed by Microsoft. It is a part of the Microsoft Office
suite and is widely used for creating, managing, and analyzing databases. MS
Access provides a user-friendly interface for handling large amounts of structured
data efficiently.
Unlike traditional databases that require complex programming knowledge,
MS Access allows users to create databases using built-in templates, tables,
queries, forms, and reports. It supports data entry, storage, retrieval, and reporting,
making it suitable for small to medium-sized businesses and personal use.
MS Access integrates seamlessly with other Microsoft applications like
Excel, Outlook, and SharePoint, allowing users to import and export data easily. It
also supports Visual Basic for Applications (VBA), enabling automation and
advanced customization.
With features like multi-user support, security settings, and data validation,
MS Access is a cost-effective and efficient solution for managing databases
without requiring extensive SQL knowledge. It is commonly used in businesses,
schools, and organizations for inventory management, customer tracking, and
reporting systems.
MS Access uses the .ACCDB or older .MDB file format to store data.
While it is ideal for small to medium-sized applications, it has a size limit of 2GB
per database file. For larger databases, it can connect to more powerful database
management systems like SQL Server.

 Part of Microsoft Office Suite – MS Access is included in the Microsoft Office

suite, often bundled with applications like Word, Excel, and PowerPoint.
 User-Friendly Interface – It offers a graphical user interface (GUI) that allows
users to create and manage databases without extensive programming
knowledge.
 Database Structure – Access databases consist of tables, queries, forms, reports,
and macros to store and manipulate data efficiently.
 Tables – The core component where data is stored in rows and columns, similar
to an Excel spreadsheet.
 Queries – Used to retrieve and manipulate data from tables based on specific
conditions.
 Forms – User-friendly interfaces that allow easy data entry and interaction with
the database.
 Reports – Designed to format and present data in a structured way for printing
or viewing.
 Macros & VBA (Visual Basic for Applications) – Automates tasks and
enhances database functionality using programming.
 Data Import & Export – MS Access supports importing data from various
sources like Excel, SQL Server, and text files, as well as exporting data for
external use.
 Multi-User Support – It allows multiple users to access and edit the database
simultaneously over a shared network.
 Integration with Other Microsoft Applications – Access integrates well with
Excel, Outlook, and SharePoint, making it a flexible tool for data management.
 Security Features – It provides password protection, encryption, and user-level
permissions for database security.
 Templates – Built-in templates help users create databases quickly for tasks
like inventory management, employee records, and customer tracking.
 Scalability – While MS Access is best suited for small to medium-scale
databases, it can connect to larger databases like SQL Server for enterprise
applications.
 Cost-Effective Solution – Compared to full-fledged database management
systems like SQL Server or Oracle, MS Access is a more affordable and
accessible option for small businesses and individuals.
3.2.2.FEATURES OF MS ACCESS

With Access we can develop easy-to-use input forms as you have seen from
other Windows applications. We can process your data and run powerful reports.
Access is also a powerful Windows application - probably the best
enduser/developer product ever written:

 Brings the productivity of database management to the usability and

consistency of Microsoft Windows. Because both Windows and Access are
from Microsoft, the two products work very well together.Can work very
well together with other MS products such as VB, VC++, .net etc.
 Runs on the Windows 95, Windows 98, Windows NT, 2000, or XP
platform, so all the advantages of Windows are available in Access. You
can cut, copy, and paste data from any Windows application to and from
Access. You can create a form design in Access and paste it into the report
designer.
 Using ActiveX (formerly called OLE - Object Linking and Embedding)
objects in Windows and Microsoft Office 2000 products (Excel, Word,
PowerPoint, and Outlook), You can extend Access into a true database-
operating environment by integrating it with these products With the new
Internet extensions, you can create forms that interact with data directly
from the World Wide Web and translate your forms directly into data
access pages for corporate intranets that work directly with your Internet
browser.

 Access is not only a database manager but also a relational database

manager:
• Provides access to all types of data and allows the use of more than one
database tables at a time.
• Can reduce the complexity of your data and make it easier to get your
job done.
 • Can link an Access table with mainframe or server data or use a table
created in dBase or Excel.
• Can take the results of the link and combine the data with an Excel
worksheet quickly and easily. If you use Microsoft Office 2000, there is
complete interoperability between Access and Word, Excel, Outlook,
and PowerPoint.
• Can easily manipulate Access data from your VB or VC applications.

 MS Access has several versions: Access 2, Access 95, Access 97, Access
2000, and Access 2003. If you are upgrading to Access 2000 from earlier
versions of Access, you should consider a few things. Earlier versions of
Access databases must be converted to Access 2000 format before they are
usable. After an Access 2.0 or Access 95 database is converted to Access
2000 format, it cannot be converted back; it’s unusable by Access 2.0, 95,
or 97. We can, however, save Access 2000 database in Access 97 format.
As an Access 2000 user, you can open and work with Access 2.0, 95, or 97
data by attaching to them as external databases, but you cannot modify any
of the objects (forms, reports, queries, and so on) you find in them.

3.2.3. MS ACCESS USABILITY HIERARCHY

Beginning at the lowest level of the hierarchy and moving upward, you see:

 Objects listed first; these give the end user the capability of creating tables,
queries, forms, and reports easily.
 By using functions/expressions, simple processing can be performed to
validate data, enforce a business rule, or display a number with a currency
symbol.
 Macros allow for automation without programming. However, VBA
(Visual Basic for Applications) code lets the user program complex
processes. Finally, by using Windows API (Application Programming
 Interface) calls to functions or DLLs (Dynamic Link Libraries) written in
other languages such as C, Java, or Visual Basic, a programmer can write
interfaces to other programs and data sources. Similarly, the programmer
can write the interfaces from other applications to connect to the Access
database. Access is a set of tools for end-user database management.
Access has a table creator, a form designer, a query manager, a data
access page creator, and a report writer.
 Access is also an environment for developing applications. Using macros
or modules to automate tasks, you can create user-oriented applications as
powerful as those created with programming languages —complete with
the buttons, menus, and dialog boxes. By programming in Visual Basic for
Applications (known as VBA), you can create programs as powerful as
Access itself. In fact, many of the tools in Access (such as Wizards and
Builders) are written in VBA.
 Microsoft Access (MS Access) is a Relational Database Management
System (RDBMS) developed by Microsoft. It is a part of the Microsoft
Office suite and is widely used for creating, managing, and analyzing
databases. MS Access provides a user-friendly interface for handling large
amounts of structured data efficiently.
 Unlike traditional databases that require complex programming knowledge,
MS Access allows users to create databases using built-in templates, tables,
queries, forms, and reports. It supports data entry, storage, retrieval, and
reporting, making it suitable for small to medium-sized businesses and
personal use.
 MS Access integrates seamlessly with other Microsoft applications like
Excel, Outlook, and SharePoint, allowing users to import and export data
easily. It also supports Visual Basic for Applications (VBA), enabling
automation and advanced customization.
 With features like multi-user support, security settings, and data validation,
MS Access is a cost-effective and efficient solution for managing databases
without requiring extensive SQL knowledge. It is commonly used in
 businesses, schools, and organizations for inventory management, customer
tracking, and reporting systems.
 MS Access uses the .ACCDB or older .MDB file format to store data.
While it is ideal for small to medium-sized applications, it has a size limit of
2GB per database file. For larger databases, it can connect to more powerful
database management systems like SQL Server.
Part of Microsoft Office Suite – MS Access is included in the Microsoft Office
suite, often bundled with applications like Word, Excel, and PowerPoint. Its key
features were,

 User-Friendly Interface – It offers a graphical user interface (GUI) that allows

users to create and manage databases without extensive programming
knowledge.
 Database Structure – Access databases consist of tables, queries, forms, reports,
and macros to store and manipulate data efficiently.
 Tables – The core component where data is stored in rows and columns, similar
to an Excel spreadsheet.
 Queries – Used to retrieve and manipulate data from tables based on specific
conditions.
 Forms – User-friendly interfaces that allow easy data entry and interaction with
the database.
 Reports – Designed to format and present data in a structured way for printing
or viewing.
 Macros & VBA (Visual Basic for Applications) – Automates tasks and
enhances database functionality using programming.
 Data Import & Export – MS Access supports importing data from various
sources like Excel, SQL Server, and text files, as well as exporting data for
external use.
 Multi-User Support – It allows multiple users to access and edit the database
simultaneously over a shared network.
 Integration with Other Microsoft Applications – Access integrates well with
Excel, Outlook, and SharePoint, making it a flexible tool for data management.
 Security Features – It provides password protection, encryption, and user-level
permissions for database security.
 Templates – Built-in templates help users create databases quickly for tasks
like inventory management, employee records, and customer tracking.
 Scalability – While MS Access is best suited for small to medium-scale
databases, it can connect to larger databases like SQL Server for enterprise
applications.
 Cost-Effective Solution – Compared to full-fledged database management
systems like SQL Server or Oracle, MS Access is a more affordable and
accessible option for small businesses and individuals.

3.2.4. ADDITIONAL FEATURES OF MS ACCESS:

1.Primary Key and Indexing:

Allows setting a primary key for unique identification of records and
uses indexing to speed up searches and queries.

2. Data Types and Field Properties :

Supports various data types such as Text, Number, Date/Time,
Currency, Yes/No, and Attachment. Field properties like input masks and
default values help maintain data integrity.

3. Lookup Wizard :
Helps users create dropdown lists in tables and forms by fetching
data from another table, ensuring consistency.

4. Switchboard Manager :
 Allows creating a menu-driven interface to navigate the database
easily, making it more user-friendly.

5. Attachment Data Type :

Unlike other database systems, MS Access allows users to attach files
like images, documents, and PDFs directly to records.

6. OLE (Object Linking and Embedding) :

Supports embedding objects such as Excel spreadsheets, Word
documents, and images inside the database.

7. Crosstab Queries :
Enables users to create pivot-style summary tables, similar to pivot
tables in Excel, for better data analysis.

8. Replication and Synchronization :

Provides the ability to replicate a database for offline work and later
synchronize changes when connected.

9. Action Queries :
MS Access supports Append, Delete, Update, and Make-Table
Queries to manipulate large datasets efficiently.

10. Split Database Architecture :

Allows separating the database into a front-end (forms, queries,
reports) and a back-end (tables, data) for better performance and multi-user
access.

11. Hyperlink Field Support :

 Stores clickable links to websites, emails, or files, useful for web-
integrated databases.

12. Calculated Fields :

Users can create fields that perform calculations directly within tables
without requiring queries or reports.

13. Data Macros :

Automates actions at the table level, such as automatically updating a
field when another field changes.

14. Cloud and Web Integration :

Can be published to SharePoint or Access Web Apps, enabling users
to access the database via a web browser.

15. Multi-Tenant Database Design :

Supports designing databases that serve multiple users with different
access levels, improving data security and organization.
3.2.5. A REVIEW OF DATABASE CONCEPTS

Database is a computer term for a collection of information concerning a

certain topic or business application. Databases help you organize this related
information in a logical fashion for easy access and retrieval. In a real manual file
filing database system, you probably have in/out baskets and some type of formal
filing method. Information is accessed manually by opening a file cabinet, taking
out a file folder, and finding the correct piece of paper. Paper forms are used for
input, per-haps with a typewriter. Information is found by sorting the papers
manually or by copying desired information from many papers to another piece of
paper.
A computer database is nothing more than an automated version of the
filing and retrieval functions of a manual paper filing system. Computer databases
store information in a structured format that you define. They can store data in a
variety of forms, from simple lines of text (such as name and address) to complex
data structures that include pictures, sounds, or video images. A relational
database management system (RDBMS) such as Access stores data in many
related tables. The user can ask complex questions from one or more of these
related tables, with the answers returning as forms and reports.
Microsoft Access follows traditional database terminology. The terms
database, table, record, field, and value indicate a hierarchy from largest to
smallest. In some computer software products, the database is the object that
holds the actual data; in Access, this is called a table. Access can work with only
one database at a time. Within a single Access database, however, you can have
hundreds of tables, forms, queries, reports, pages, macros, and modules - all
stored in a single file with the file extension .MDB (multiple database) or .ADP if
you are using SQL Server.
SAMPLE SCREENSHOTS
 SAMPLE SCREENSHOTS
INFORMATION ABOUT THE AIRWAY RESERVATION

LOGIN:
 SELECT YOUR OPTION:

RESERVATION FORM:
NEW DATA:

CANCELLATION FORM:
POSTPONE FORM:

FEEDBACK FROM PEOPLE:

SAMPLE CODING
 6.SAMPLE CODING

LOGIN FORM:

Private Sub Command1_Click()

If (Text1.Text = "MALATHI" And Text2.Text =

"MALALA") Then

MsgBox ("YOUR USERNAME AND PASSWORD IS CORRECT")

Form3.Show

Else

MsgBox ("YOUR USERNAME AND PASSWORD IS INCORRECT")

End If

End Sub

Private Sub Command2_Click()

End

End Sub

Private Sub Form_Load()

Text1.Text = ""

Text2.Text = ""

End Sub
 CHOOSE YOUR OPTION

CODING:

Private Sub_Click()

Form1.Show

End Sub

Private Sub Command1_Click()

MsgBox "FLIGHT BOOKING FORM"

Form2.Show

End Sub

Private Sub Command2_Click()

MsgBox "FLIGHT CANCELLATION FORM"

Form4.Show

End Sub

Private Sub Command3_Click()

MsgBox "FLIGHT POSTPONE FORM"

Form5.Show

End Sub

Private Sub Command4_Click()

MsgBox "FEEDBACK FORM"

Form6.Show

End Sub

FLIGHT BOOKING

CODING:

Private Sub Command1_Click()

Form3.Show

End Sub

Private Sub Command2_Click()

MsgBox "YOUR TICKET FOR FLIGHT IS BOOKED"

Form3.Show

End Sub

Private Sub Command3_Click()

Data1.Recordset.AddNew

MsgBox "ENTER THE NEW DATA"

End Sub

Private Sub Command4_Click()

Data1.Recordset.Update
MsgBox "CHANGES ARE UPDATED"

End Sub

Private Sub Command5_Click()

Data1.Recordset.Delete

MsgBox "SELECTED DATA ARE DELETED"

End Sub

Private Sub Form_Load()

Combo1.AddItem ("FIRST CLASS")

Combo1.AddItem ("ECONOMY CLASS")

Combo1.AddItem ("BUSINESS CLASS")

Combo1.AddItem ("PREMIUM ECONOMY CLASS")

Combo2.AddItem ("MALE")

Combo2.AddItem ("FEMALE")

Combo3.AddItem ("9.30 AM")

Combo3.AddItem ("12.30 PM")

Combo3.AddItem ("3.30 PM")

Combo3.AddItem ("6.00 PM")

 Combo3.AddItem ("9.30 PM")

Combo3.AddItem ("12.30 AM")

Combo3.AddItem ("3.30 AM")

Combo3.AddItem ("6.00 AM")

Combo4.AddItem ("AIR INDIA")

Combo4.AddItem ("INDIGO")

Combo4.AddItem ("SPICE JET")

Combo4.AddItem ("VISTARA")

End Sub

CANCELLATION OF FLIGHT

CODING:

Private Sub Command1_Click()

MsgBox "YOUR FLIGHT CANCELLED SUCCESSFULLY"

Form3.Show

End Sub

Private Sub Command2_Click()

Form3.Show

End Sub
Private Sub Form_Load()

Combo1.AddItem ("FIRST CLASS")

Combo1.AddItem ("ECONOMY CLASS")

Combo1.AddItem ("BUSINESS CLASS")

Combo1.AddItem ("PREMIUM ECONOMY CLASS")

Combo2.AddItem ("AIR INDIA")

Combo2.AddItem ("INDIGO")

Combo2.AddItem ("SPICE JET")

Combo2.AddItem ("VISTARA")

End Sub

POSTPONE FLIGHT

CODING:

Private Sub Command1_Click()

MsgBox "FLIGHT POSTPONED SUCCESSFULLY"

Form3.Show

End Sub

Private Sub Command2_Click()

Form3.Show

End Sub
 FEEDBACK

CODING:

Private Sub Command1_Click()

MsgBox "FEEDBACK SUBMITTED SUCCESSFULLY"

End Sub

Private Sub Command2_Click()

Form3.Show

End Sub
CONCLUSION
 7.CONCLUSION

This project entitled ―Airway reservation system‖ is developed using visual

basic with access . This project is used to login easily and help to register their
name under their needs . Existing customers as well as people can also
book,cancel, postone their flight ticket . So ,customer or people easily register and
book their tickets using this application.
BIBLIOGRAPHY
 8.BIBLIOGRAPHY

1. Visual Basic 6 for Windows. Berkeley. CA: Peachpit

Press, 2000.

2. VB COM. Chicago, IL: Wrox Press Inc., 1999 - Lewis,

Thomas.

3. Ted. Programming Distributed Applications with COM and Microsoft

Visual Basic 6.0. Redmond, WA: Microsoft Press, 1998 – Pattison.

4. Microsoft Visual Basic Design Patterns. Redmond. WA: Microsoft

Press, 2000 - Stamatakis. William.

5. Access 2010 For Dummies, by Laurie Ulrich Fuller, Ken Cook,

Paperback: 456 pages Publisher: For Dummies (May 10, 2010) Amazon

6. Access 2010 Bible, by Michael R. Groh, Paperback: 1392 pages

Publisher: Wiley (May 10, 2010) Amazon

7. Access 2010: The Missing Manual, by Matthew MacDonald, Paperback:

608 pages Publisher: Pogue Press; 1 edition (July 1, 2010) Amazon

8. Access 2010 Programmer's Reference, by Rob Cooper et al. Paperback:

1200 pages Publisher: Wrox (August 9. 2010) Amazon

HYPERLINK

www.webcrawler.com

www.ask.com/Reference+Books

www.visualbasic.about.com

www.booksnbytes.com/authors