ACCESS project

[iunanih]

Good morning everyone,




I’m writing this message as a last resort... I have to do a project on access but I can’t, I’ve watched hundreds of videos on Youtube and that little things work..
My project: it allows to manage flights, pilots, steward and consumption.


What I do not get is all that is employee management: put a bonus according to the number of flights and seniority and display it in a form according to the chosen month (I have flights for December and January).


That’s if someone could help me you would save my year of study!
Thank you in advance and have a good day!

[June7]

Need to explain what defines 'bonus'. How many flights and what seniority deserves what level(s) of bonus - the formula you follow if calculated manually. Possibly need a point system.

Unfortunately, I don't speak/read French so I probably won't be able help more.

[canyonraven]

Hello iunanih: Access is a SQL relational database so, to get you started, the first thing you need to do is create tables. Minimally, you want one or more data tables and some look up tables. Try creating a table called tblFlights. Then create a couple of look up tables like tluStaff (which would include pilots and flight attendants) and tluPassengers. Then think about how these three tables would be related to each other. Once you have your tables and relationships, the project will be more clear.

[canyonraven]

Number of flights and seniority would be properties of tluStaff.

[orange]

My project: it allows to manage flights, pilots, steward and consumption.

Where/how do you identify pilots and stewards? Seniority calculation?
What is a bonus and how is it calculated?
Can you share documentation describing the projects requirements? We need info in order to help you.