microsoft.access.courses - Staffing

Resolved · Low Priority · Version Standard

Thu 8 Mar 2007, 09:43 Delegate Anna said...

Anna has attended:
Access Introduction course
Access Intermediate course

Staffing

Does anyone have any experience of using access databases to sort out staffing at Major major sporting events

Thu 8 Mar 2007, 13:15 Trainer David said...

RE: Staffing

Hi Anna

I cannot say for definite whether anyone of our team has this type of experience, but basically, you would be able to use an access database for this purpose. You would need to carefully plan out all of the data that you wish to store, then work out what tables that it would go into, then how these tables link together. To extract the information you would then have to develop a series if SQL statements that would pull back data from the linked tables.

If you need assistance on this please get in contact with us and we can arrange for a consultant to assist you with this task.

Hope this helps
David

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips