How do i set up an Aviation Log Book

[Guest]

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

 

[Pat Hartman \(MVP\)]

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.

 

[John W. Vinson]

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]

 

[Guest]

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.