|
::
Introduction
::
Database principles
::
Tables
::
Queries
::
Data security
::
Glossary
::
Resources
::
Student Files
:: Contact
:: Back to Main Site
:: Site
Map
|
Microsoft Access - Class 1 - Part II
|
>
Back |
Excel versus Access - Why would you use Access?
| Feature |
Excel |
Access |
| |
|
|
| Layout |
Tabular layout |
Spreadsheet view as well as form view |
| |
|
|
| Storage |
Limited to 65000 records |
Up to 2 gigabites |
| |
|
|
| Linked tables |
Manage single lists |
Allows links between lists of information |
| |
|
|
| Reporting |
Limited, spreadsheet view |
Sophisticated reporting features |
| |
|
|
| Security |
Limited |
Sophisticated |
| |
|
|
| Multiuser capabilities |
No simultaneous entry allowed |
Multiple users can access and update data |
| |
|
|
| Data entry screens |
Limited |
Extensive options through forms |
Print this page
|
