Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel v Access

Excel v Access

ResolvedVersion 2003

Wed 31 Mar 2010, 16:24 Delegate Andrew said...

Andrew has attended:
Excel Advanced course

Excel v Access

Hello,

I my role I record non-numerical data. I work in training and record people's names, what courses they have done, what courses they haven't done, what courses they need to do etc. Is access a better programme for me to use for this kind of data?

Many thanks and kind regards,

Andy

Tue 6 Apr 2010, 14:26 Trainer Stephen said...

RE: Excel v Access

Hi Andrew

Thanks for your question

I think there is little doubt that Access would be a better tool here. Excel works with simple lists, while you have collections of related data, Students, Courses, Attendances etc.

Thus you need to use a relational database tool

Regards

Stephen

Training courses

98.6 % recommend us

More live stats...

Training information:

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

Excel v Access

Excel v Access

RE: Excel v Access

Excel articles

Excel tip:

Display pictures on Chart Data Point