Plane Schedule
Tutorial
(You can print
this out by clicking on 'Print' in your browser)
How do I get a user name and password? (for
future users only)
1. These access items are handled by the Information
Services Department and can be requested should the need arise, by sending
an email to: IS Security.
2. Users permissions (what they are allowed to do) are also set by the
IS Department. They are Add, View, Modify, Delete and List All. Majority
of users will only be allowed View privileges.
What
do permissions mean?
1. 'View' means
you can only logon and do 'Search', 'View' as well as 'List All' of
records in the database.
2. 'Add'
means you can add flight schedule
record to the database.
3. 'Delete' means you are allowed to remove records from the database.
4. 'Modify' means you can make changes to the record if you need to.
How
do I view certain records?
1. Select the fields you want
to view. For example: you want to see the record where '1-Oct-2000'
is the departure date, 'Allan MacGilvray' is the pilot and "Joe
Lacaeyse' is the first leg passenger. You also want to sort it by 'departure
date' in ascending order(meaning the earliest departure dates first).
A sample window is shown below.
2. You select 'MacGilvray' from the pilot field, 'Joe Lacaeyse' from
the first leg passenger field and type '1-Oct-2000' (in this format)
from the departure date field.
3. Then scroll down to search options then click on 'departdate' under
sort by and 'ascending' under sort order then click on 'View Record'.
4. The following sample records will show you the match result:
What
is List Current for?
1. 'List Current' is one of
the options you can select at the bottom of any window. This will give
you a list of all the records with 'departdate' starting from today's
date into the future records of scheduled departures.A sample window
is shown below (graphic shortened to 3 records instead of 9):
What
is List All for?
1. 'List All' is one of the
options you can select at the bottom of any window. Select
this if you want to view all the records in the database. This is automatically
sorted in ascending order(meaning earliest to latest records). A sample
window is shown below.
***The remaining instructions only apply to the pilot currently.***
How
do I add records?
1. Record numbers are automatically
produced by the system. All other dates should be typed as: '1-Oct-2000'
to ensure accurate searching of these fields.
2. Departure and arrival times are typed in military time (0000-2400).
3. Only 1 airport code can be selected for each leg. Passenger and pilot
lists can be selected multiple times by holding the CTRL key while clicking
on the names.
4. Any additional info needed which is not provided by the form can
be entered under Notes/Instructions.
5. If done entering info, click on 'Add Record'.
6. If you want to start over, click on 'Reset Form'.
7. The following sample record
is added:
How
do I modify records?
1. On the main
menu or any window, scroll down to the bottom and click on 'Modify'.
This will bring you to the 'Search Database for Modifying'. Select fields
like you did for 'viewing records'.
2. After you click on 'Search', it will bring you to the the window below. Click on the checkbox located at the side of the record. Then scroll down and click on 'Modify Record'. This will bring you to the record you checked and modify from there (Make sure all fields are filled out). The sample record below shows your modification:
How
do I delete records?
1. On the main menu or any
window, scroll down to the bottom and click on 'Delete'. This will bring
you to the 'Search Database for Deletion'. Select fields like you did
for 'viewing records'. In the sample record below, 'Aztec' was selected,
which happen to only have one match.
2. After you click on 'Search', it will bring you to the the window below. Click on the radio button(s) located at the side of the record. Then scroll down and click on 'Delete Checked Record(s)'.
3. The following window will confirm your deletion:
For any other questions, you can email: IS Security or call ext 635.
