English Español Português Italiano
Tutorials Guide Help
Sitemap Adobe Autodesk Microsoft Corel Sony GNU Others

PFM Windows Microsoft Access Tutorial


 









PFM Windows Microsoft Access Tutorial

PFM Windows Microsoft Access Tutorial FREE DOWNLOAD THIS TUTORIAL
Tutorial in pdf format so you can save it to your PC, e-book reader or print.


Sponsored link



Note: The tutorial you are about to download is compressed format. Rar, if you do not have a decompressor rar files you can download 7-zip and you can display the Foxit PDF Reader.



Index PFM Windows Microsoft Access Tutorial


PFM Windows Microsoft Access Training Manual
Database Terminology
Database
Relational Database
Opening Microsoft Access
PFM Tables
AirplaneInfo=Aircraft database
Airport2=Airport database
AirportInfo=Primary airport database info
Authorizers=Record keeping auth per leg
ChargeAcctInfo=Pax database
CrewData=Record keeping: crew per leg
CrewRatings=Ratings from crew database
Crewsched=Crew from scheduling
Dispatch=Scheduling module
FBO=Airport database
Flightlog=Record keeping, front page, mostly
Flitelog2=More record keeping
Hotel=Airport database/hotels
paxData=Pax data from record keeping (per leg)
PaxInfo=Pax database
PaxSched=Pax from scheduling
Pilot=Crew database
XtraPax=More pax database
XtraPax2=Even more pax database
Tables
Fields
Record
Records
Field caption
Fields
Total number of records
Selected record
Queries: Creating Queries Using a Single Table
The first step to is decide what information you want to see
How many times each aircraft has flown to a city pair over a date range
pair over a date range
On the Queries tab, click the New button
New query dialog box
A New Query window and the Show Table dialog box appear
The Flightlog table (list of fields) is added to the table pane (top of the screen) of the query window
View
Totals
Totals line
Date parameters
Run query
The completed query
AZ button
ZA button
Reports
PFM Access Tables and Unique Field Identifiers
Table Name Location of Data Unique Field
AirplaneInfo Aircraft Database ACNumber
AirportInfo Airport Database Air ident
Airport2 Airport Database Airport ID
Authorizors Record Keeping Auth Tab YR+AC#+PFMprt+Authpos
Charge AcctInfo Pax Database Rec ID
CrewData Recordkeeping YR+AC#+Ptr+POS
CrewRatings Crew Database Crew_Number+Aircraft_Type
Crewsched Crew from Scheduling Pilot+Date+Aircraft
Dispatch Scheduling Module Aircraft+Phystrpdate+Thisleg
FBO Aircraft Database FBOID
Flightlog Record Keeping Yr+AC#+PFMptr
Flitelog2 Record Keeping Yr+AC#+PFMptr
Hotel Airport database/Hotels Unique_ID
PaxData Record Keeping Yr+AC#+Ptr+POS
PaxInfo Passenger Database PFMAcct
PaxSched Passengers in Scheduling Tripdate+Leg+Index+Aircraft
Pilot Crew Database Crew#
XtraPax Passenger Database Acct
XtraPax2 Passenger Database Acct+Company
PFM Access Tables and Unique Field Identifiers
A unique Field Identifier, also known as a Primary Key, is the field that uniquely identifies each record
Adding Criteria to a Query
Setting Parameters
Table of Common Criteria used by Queries







Download the file decompressor 7-zip.
Download the PDF reader Foxit PDF Reader.




TutorialsPDF.com © 2008 - This work is licensed under a Creative Commons License.