How do i set up an Aviation Log Book

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stan - 24 Feb 2007 10:43 GMT

I have office 2007 ( access & excel ) and wish to record log book entries of
flying lessons, costs, comments etc

Reply to this Message

Pat Hartman (MVP) - 25 Feb 2007 04:12 GMT

That's a pretty broad question. sounds like you want someone to design the
application for you. Start by taking a look at the Northwind database. It
has functionality similar to what you need.

>I have office 2007 ( access & excel ) and wish to record log book entries
>of
> flying lessons, costs, comments etc

Reply to this Message

John W. Vinson - 25 Feb 2007 05:59 GMT

>I have office 2007 ( access & excel ) and wish to record log book entries of
>flying lessons, costs, comments etc

Just like setting up any other database - identify the Entities
(real-life things, persons or events) of importance; each type of
Entity will become a table. Identify each Entity's attributes -
discrete, atomic, nonrepeating "chunks" of information that you need
to know about the Entity; each such Attribute will be a Field.
Identify the relationships between your entities.

Create your tables, then build forms to edit them.

For some pointers see

Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

John W. Vinson [MVP]

Reply to this Message

Krazy Darcy - 27 Feb 2007 07:38 GMT

Once you have your tables set up as Pat Hartman said, create forms for
entering the information/data into the system.

Also before you start building the queries,

Work out "what do I want to find out?
for example, you may want to find out who has passed a particular test.

This will help in building the queries.
But also remember you will probably want a query where you can call up all
of a particular student's records (assuming you are running a flight school),
or all entries relating to a specific flight.

> >I have office 2007 ( access & excel ) and wish to record log book entries of
> >flying lessons, costs, comments etc
[quoted text clipped - 17 lines]
>
> John W. Vinson [MVP]

Reply to this Message