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

excel and access

ResolvedVersion 2007

Cassie has attended:
Excel Introduction course
Word Intermediate course
Word Advanced course
PowerPoint Introduction course

Excel and access

What are the main differences between Excel and Access e.g. why do you use Excel as opposed to Access for spreadsheet data entry and visa versa?

RE: excel and access

Hi Cassie

Thank you for your question and welcome to the forum.

Excel is useful for performing calculations/working with financial information. It can also be used for storing and manipulating data, but only to a limited extent.

Access is better for storing and manipulating large amounts of data. The power of Access lies in being able to store data within a series of tables, which are linked with each other. With Access you can create queries which allow you to extract lots of different combinations of information from your data.

You can find further discussion on this topic using the link below:
http://www.dslreports.com/forum/remark ,15487439

Kind regards
Amanda

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.