microsoft access course london - Why is Access better than Excel?

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

Resolved · Low Priority · Version Standard

Why is Access better than Excel?

Lu has attended:
Access Introduction course

by - delegate Lu [3 posts] (2007 Feb 13 Tue, 09:46) Reply

I'd like to know why access is better than excel...

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 9 Tue	Bloomsbury	3	book now	£210	£215
2002/XP	2008 Sep 11 Thu	Tooting	0	FULL
2003	2008 Sep 19 Fri	Bayswater	5	book now	£195	£205
2007	2008 Sep 23 Tue	Bloomsbury	5	book now	£212	£224
2002/XP	2008 Sep 24 Wed	Tooting	0	FULL
2003	2008 Oct 7 Tue	Southwark	6	book now	£193	£215
Full Schedule: See all 72 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Why is Access better than Excel?

by - trainer David gold contributer [428 posts] (2007 Feb 13 Tue, 12:22) Reply

Hi Lu

Access is not neccessarily better than Excel, it just depends what you want to do. If you want to create a database then use Microsoft Access however if you just want to create a spreadsheet then use Microsoft Excel.

So if you need to create something that has multiple tables that have a relationship with each other (ie they are linked) then use Microsoft Access. If you just on to create something that does not need linked tables then use Microsoft Excel

Hope this helps

David

· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Material covered on a Microsoft Access Course
· MS Access: Access your Personal Information with Ease
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Reasons to Consider Microsoft Access Training

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips