Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS


SuperbHosting.net have generously sponsored dedicated servers to ensure a reliable and scalable dedicated hosting solution for BigResource.com.





Best Training Course London


Hi,

Myself and a few of my colleagues want to petition our boss to be given Microsoft access training. Most of us are fairly experienced excel users but
do not write our own macros or anything of that sort.

None of us have any prior experience with Access. Ideally we want a course based in London that will take us from ground up to expert users.

There seem to be loads of courses out there but we want to know which ones you feel are good and in particular which lecturers within a given company are best.

Cheers

Baz




View Complete Forum Thread with Replies

Related Forum Messages:
VBA Course Based In London
Good afternoon,

Can anyone suggest a good place I can go to learn VBA for access.. I have spent the entire afternoon trying to find a place but they all sound the same.


Any comments would be helpful.


Thanks

Shane

View Replies !
Access 2007 Roll Out: London
hi

does anyone work for a bank in London who has rolled out Office 2007 yet?

or indeed any large company anywhere i suppose...

View Replies !
Training
I've been reading books to learn VBA for Access 2007, but I would like to take some training classes. Can anyone suggest any good online or onsite courses that I could take?

View Replies !
Training Videos
I was looking at purchasing the following set of training cds and noticed there is a 5 user license included. Would anyone else be interested in going in together and buying this?

Link (http://www.youlearn.com/products/lk-products/A/access2003dev/access2003dev.html)

I thought I might even rent them out after I go through them.. Anyone have any interest or other ideas?

If so, pm me. :)

I'm guessing that I already know about 60-70% of what is teaches but the other stuff looks interesting plus I'm really needing to train my replacement at some point in the near future...

View Replies !
Training Tracking
Does anyone have a sample training tracking system / database they'd be willing to share?

Or, barring that, can someone point me in the direction of where I might find one?

Thanks in advance! Looking forward to it!

View Replies !
Tracking Training
Does anyone have a sample training tracking system / database they'd be willing to share?

Or, barring that, can someone point me in the direction of where I might find one?

Bee replied once, suggesting I look in the Samples Databases section of this forum, but I could not find anything even remotely related there.

All replies are gretly appreciated!!

View Replies !
Need Training Database
I am trying to create a Microsoft Access training database for us at work and I’m not having much success. Can someone look at what I’ve done so far and see if they can make it work or if you know of one out there already that I could download and use that would probably even be better. If there is more to it than just training then that it’s probably better too because I want to expand this as I get time.

Thanks,

Mike

View Replies !
Tracking Training
I have a DB I'm using to track training for assigned people. Right now the training gets put in the DB at the end of the day by going through each persons record and adding the training that they did for the day. As you can see when training 30+ people a day, putting this in the system can take awhile. I'm trying to find a way to do a mass input to cut down time and could use some help with this.

My tbls are as such,

1st Table:EMPLOYEEtbl
EmployeeID
EmployeeName
(Other information)

2nd Table:CLASStbl
className
classID

3rd Table:CompleteClasstbl
EmployeeID
classID
DateTaken

What I like to do at the end of the is select the ClassID/DateTaken items once and then type in a just the 30+ list of employeeID's click a button and append it to the my 3rd table. Of course writing it out like this makes me think it should be easy but for some reason I'm lost. Does anybody have any suggestions?

View Replies !
SQL Training Courses
Morning all

I am currently working with IT and am looking for a course/courses to further advance within the IT sector.

My employer is willing to fund and/or allow me time from work to obtain the qualification.

I am writing to see if anyone could advise on the best courses i should be looking at or are available. I am looking into doing something with SQL and have been looking at the MCITP course with Computreach.

Can anyone recommend this course or has anyone any other recommendations?.

Regards
Nathan

View Replies !
Online Training
Have any of you ever used some really good online training? I really need to get good with ASP.NET, VB.NET, ADO.NET and SQL 2007 Server ect. I want to do some self pased online training, anyone used a really good service for this?

Thanks you!

View Replies !
Need Training Database
I am trying to create a Microsoft Access training database for us at work and I’m not having much success. Can someone look at what I’ve done so far and see if they can make it work or if you know of one out there already that I could download and use that would probably even be better. If there is more to it than just training then that it’s probably better too because I want to expand this as I get time.

Thanks,

Mike

View Replies !
Fitness Training Form
I'm trying to set up a training program for my gym database but I'm having alot of problems, I will be in debt to anyone who can help me out!

My current "training" tables"

ExAttributes

ExID - PKEY
ExType - (Sets, Reps etc)

ExerciseTypes

ExerciseID - PKEY
TrainingType - (Lookup from TrainingTypes, cardio etc)
ExerciseName - (jogging, swimming etc)

Training

TrainingID - PKEY
MembershipNo - FKEY
TrainingType - (Lookup from TrainingTypes, cardio etc)
ExerciseName - (Lookup from exercisetypes)

TrainingTypes

TypeID - PKEY
TrainingType - (Cardio, Strength etc)

---

Hope that makes things abit clearer

Just to clarify I have most of the other things done, the membership, payment, measurements and health forms are working great, I can also search for members and run queries as to when membership runs out & who hasnt attended in a set period of days.

What I am looking for from this training form is just a form where I can bring up a membership ID, and below that have a series of drop down boxes, one under the heading Cardio and one under the heading Weights. I should be able to select an exercise in one of the many combo boxes (for example jogging) - and then enter the time / distance in text boxes.

I should be able to do the same then with the weights but with sets / reps / weight instead.

I also want to have Sessions 1,2 and 3 for each member ID, as part of the training plan they will have to do 3 sessions a week, these should be able to be different.

Thanks in advance.

View Replies !
Gym Training Form / Table
Hi,

I want to create a simple training form which would allow a personal trainer to input a series of exercise types, name, sets / reps for a member which then could be printed out as a "Session" for them.

I have completed the rest of the database which deals with members, payment and so on but this part is leaving me stumped, any help greatly appreciated.

Jon

View Replies !
Tracking Employee Training
I am tracking training for employees. I have a database that keeps track of the dates a particular training was taken. Employee training is ongoing from year to year. I have an Employee Training with a subform showing only the specific employee's training. I need a help with a few things. I need to keep track of training by the year. If I enter 2006 dates it will show in one line, if 2007 dates, another, all the way across the list of training classes for an employee. I also only want to limit a person enter more than one date for a particular class for a calendar year...Are these things possible. I have attached the database. Please help, make changes and suggestions. Thank you so much in advance.:eek:

View Replies !
Setting Up A Training Database Help!
I have a table with the following fields

flddate
fldclassname
fldemployeename
fldstatus

I have data entered all current employee training and dates that training was done.

I am looking for an explanation on how I can set it up so i can see who of the employees have not recieved the training.

I am also looking for code for the query to calculate recurrent training dates (when the next training is due for each employee) Dates of initial training for each employee may be different, as well the training may be required every one year or every two years etc.

I am hoping that I am explaining this more clearly in hopes to get some input back from the experts on this site.

Thanks in advance.

View Replies !
Tracking Expired Training
Hi

I have a query that tracks employee training that is incomplete. The query grid includes a yes/no fieldsthat show if it is completed, so I put criteria to say no, so if the course is not done, it will show up, But it also has to show if the training was already completed but expired, So i created an expired field in the query grid which calculated the expiry date. To show if training is expired, I put in an OR condition, training complete =yes, and expiry date <=now. It does show the correct results.

My problem is, if someone completes one of the expired courses, and the data is entered with a new expiry date (calculated) I want the previous courses (the expired one) to be removed from the view of the query. Right now it still shows because of the criteria.

What can I add to the criteria for the expired training to make it dynamic, based on the data entered into the table, or do I have to put a new or condition in.


any help would be appreciated

Marlie

View Replies !
Linking Job Titles To Training Courses
Hi,

I'm new to this forum so forgive me if this thread is in the wrong section.

I'm currently creating an OHS&W (Occupational Health Safety & Welfare) database. My boss has just requested if I can possibly have it so that when a Employee has a job title selected for them it automatically lists the courses that are required for that job.

Can anyone help me please?

Cheers

View Replies !
Database To Record Training Data
Hi All

I am trying to setup a database to record details of who and where I trained staff. The ones I have found all include grades and marks which I don't want.

Does anyone have a sample database that can help get me started please.

Tee.

View Replies !
Query To Find Ee's With Training Not Completed
I am working with a training database. I am a fresh newbie to access (more of an excel user).

I need to find employee's who have never completed a certain training (DPW Medication Training), which is mandatory.

I have the following tables:
Employee data TBL - Contains active ee's names
CompletedTrainings - Contains all trainings completed by individual
Events - name of all the trainings, including mandatory trainings

I have the following queries:
DPW Med Training - Lists all who have completed the training
DPW-Med-Last - Lists when each employee last had the training
Med_01 - Lists those who have had the training, but need it renewed

Any thoughts?

View Replies !
Query For Missing Values From Training Database
Hi

I have inherited a database that contains details of staff training data and the tables contain the following:

Personal Information Table:
PersonalID
Surname
Forename
EmploymentStatus (this contains either Staff, Operative, or Supervisor)

Training Courses Table:
CourseID
Course Name
Course Description
Supervisor (Yes/No)
Operative (Yes/No)
Staff (Yes/No)

Training Courses Attended Table:
RecordID
PersonalID
CourseID
Date

Each of the courses in the Training Courses Table should be attended by one or more of the groups identified in the EmploymentStatus field (ie. Supervisor, Operative, Staff) and the relevant field in the Training Courses Table is flagged eg.
Training Courses Table:
CourseID, CourseName, Supervisor, Operative, Staff
100, basic safety, Yes, Yes, Yes
101, safety management, Yes, No, No
102, working with ladders, No, Yes, No
103, VDU, No, Yes, Yes

I need to identify which individuals have not attended the courses that they should have been completed (ie. compare courses attended with the list of courses associated with the EmploymentStatus associated with individual staff members, and identify which courses have no attendance dates).
How can I structure the query, I can't see how to do this with the existing tables, but I think it should be possible, but my Access expertise is just not good enough to work through this.

Any advice would be much appreciated.

View Replies !

Copyright © 2005-08 www.BigResource.com, All rights reserved