microsoft.access.courses - Staffing

The UK's most regular instructor-led training courses.
Training information: microsoft.access.courses · Courses in microsoft access · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Staffing

Anna has attended:
Access Introduction course
Access Intermediate course

by - delegate Anna [1 post] (2007 Mar 8 Thu, 09:43) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 26 Wed	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 28 Fri	Bloomsbury	3	book now	£240	£245
2003	2008 Dec 3 Wed	Southwark	7	book now	£203	£230
2003	2008 Dec 19 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
Full Schedule: See all 47 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Staffing

by - trainer David gold contributer [428 posts] (2007 Mar 8 Thu, 13:15) Reply

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

· Microsoft Access Training Opens Doors
· The Benefits of Certified Microsoft Training in Access
· How Reorganising Your Data Can Take Your Business to the Next Level
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· How To Find Good Access Database Courses In London

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips