Industry Regulations Document Database

[intoxiktu]

First of all, Hello.



I'm here looking for some assistance with a little project that I'm working on. So here we go:

I work in the aviation industry, and as you know, the aviation industry is very regulated. One of the requirements is to have a "List of Effective Pages (LEP)" towards the beginning of the document which is a list of every page in the document and the revision level and date for that page - this is a requirement of our regulatory oversight/flight safety so it's not optional. This LEP is one hell of a task when you have over 80 manuals and every single one has about 100 pages which almost weekly a couple dozens of them change and have a new revision date.

I am looking for an easier solution in Access, if it's possible, and some assistance due to the fact that I've never worked in Access before.

Now, I'm working with a self made LEP in Excell, which is limited by it's nature and hard to work with. I would really like to have an entire database of pages in which I can modify a page, and all the various LEPs would auto-process the new date/revision/deletion/renaming so the new LEP can be printed easily.

For example:

XX airport is in 30 of the 80 manuals. As I modify XX page 1 date in the database, all the correspondent manuals have the LEP updated with the new page.

The LEP is structured like this:
1. Name column; 2.Page Number column; 3.Date/revision column.


Thank you and best regards,

[June7]

Suppose could keep the LEP in an Access db - this is data. But trying to use Access to produce 100 page documents could be very difficult. Access is not a word processor.

An Access report design is limited to 22 inches in width and length.

Basically each page would be a single report. Then code could possibly manage printing the reports in whatever sequence you want.

[intoxiktu]

Ideea is that access would only supply the reports (LEP) not the whole manual. It would print a report that has only those 3 columns with name/page/date, and i think it can print in 22inches a 100 line report...

Clarification. The database contains only these 3 things. Name/page/date. Not the whole page. - List of effective pages - List of pages.

Example:

GMAD	AGADIR,MOR.10-9/10-9A	20-Jul-12
GMAD	AGADIR,MOR.11-1/11-2	10-Dec-10
GMAD	AGADIR,MOR.13-1/13-2	11-Apr-08
HEAX	ALEXANDRIA,EGYPT10-9/BLK	7-Jan-11
HEAX	ALEXANDRIA,EGYPT12-1/12-2	8-Mar-13

And when acces supplies me with a report - reports only this. If a manual contains only HEAX, it would print me with a report of only HEAX (by name):

HEAX	ALEXANDRIA,EGYPT10-9/BLK	7-Jan-11
HEAX	ALEXANDRIA,EGYPT12-1/12-2	8-Mar-13

[June7]

So, sounds like a one-table db. The table could easily be in Excel but Access does have the better tools for filtering and report design.

[intoxiktu]

This is what I thought.

Any pointers on how can I achieve this? Some guidance would be much appreciated.

[June7]

So far, what you describe is basic Access functionality. Get an introductory book on Access that will teach you the basics. Or on-line tutorials. Here is one: http://www.rogersaccesslibrary.com/