excel v access

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

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

Excel V Access

resolvedResolved · Low Priority · Version Standard

Siobh has attended:
Excel Intermediate course
Excel Advanced course

Excel V Access

What is the difference between Excel & Access?

RE: Excel V Access

Well access is a full database product. You can store data in tables and create queries on the tables to return data sets. You can also use the access functionality to create forms for user entry and reports. Excel uses tabs and worksheets to hold data in single tabs and sheets and not in a database format. Some of the functionality overlapps in places though.


 

Excel tip:

Create Equations in Excel 2010

Here's how to create basic mathematical
equations in your Excel 2010 worksheet.

1) On the Ribbon, click the Insert tab
2) In the Symbols group, click the arrow next to Equation
3) Select from the equations and the equation will be inserted in a text box

Or you can create your own equation:

1) Insert and select the text box
2) On the Ribbon, click the Insert tab
3) In the Symbols group, click Equation
4) The Equation Tools Design Ribbon will now be displayed

View all Excel hints and tips


Server loaded in 0.09 secs.