Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft access course london - why access better than

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access course london - Why is Access better than Excel?

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

ResolvedVersion Standard

Lu has attended:
Access Introduction course

Why is Access better than Excel?

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

RE: Why is Access better than Excel?

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

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.



Access provides an easy method of achieving a running total.



Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.