Creating a new database or use an existing template to create a repository/staff database..

[Alfy]

Hi All,

Hope everyone is doing well.

I need some help creating a "repository" staff database I'm hoping to create in Microsoft Access.

Basically, my role is to source staff to travel overseas..

The requirement is minimum 2x staff one has to be a team leader.

However, I am currently using an excel database which is noted as a "next in line list" which I've copied below

When a staff member accepts to travel overseas they are placed on the bottom of the list, pending another trip when they reach the top.

I just copy the row in excel and paste it in the bottom

Would there be an easier way to create this in Microsoft Access?




Also, when someone has accepted the trip, to automatically send a template contract when they have accepted?

Kind Regards,
Alfred

[ranman256]

then you will need a date field to sort folks to the bottom or top.

[Alfy]

Hey Ranman,

date field for the acceptance? I'm assuming it would be them accepting the trip?