Overview of Microsoft Access
59Introduction to Microsoft Access
Microsoft Access is a database application. Part of the Microsoft Office Suite (depending on version), Access makes it easy to organize and store data, as well as creating data presenttaion and capture applications.
While the most familiar data entry interface is very similar to Microsoft Excel, the underlying application allows you to:
- Query data
- Sort & Filter Data
- Create Reports
- Collate data from different tables
- Build User-friendly Forms for Data Capture
In addition, for developers, it's tight integration with the SQLdatabase programming labguage makes it perfect for use in a corporate environment
On the front-end, a series of well thought out wizards facilitate the setting up and editing of the inital database. Coupled with a reasonable set of help files, and great online support from a huge user base, it is an excellent choice for small to medium businesses.
For use on web servers, or for larger corporations, mySQL, Oracle or other relational databases would potentially be a better fit.
Useful Microsoft Access Links
- Access Keyboard Shortcuts
List of common Keyboard Shortcuts - Designing a Database : First Principles
Help creating your first database. - Looking up Lists with an Access Database
Good introduction to one of the foibles of Access - The Microsoft Access Minisite at About.com
Great introduction to the ins and outs of MS Access - The Top 10 Benefits of MS Access
The Microsoft Official list of selling points.
Microsoft Access 101 Tutorial Video
Books about Access
|
"When Microsoft Word and Microsoft Access for Dummies IS NOT Enough"
Price: $16.18
List Price: $17.98 |
|
Microsoft Access 2002 for Dummies
Price: $4.71
List Price: $21.99 |
|
Mastering Access Made Easy Training Tutorial v. 2007 through 97- How to use Microsoft Access video e Book Manual Guide. Even dummies can learn from this ... through Advanced material from Professor Joe
Price: $39.95
List Price: $39.95 |
|
Mastering Access Made Easy Training Tutorial v. 2003 through 97 - How to use Microsoft Access video e Book Manual Guide. Even dummies can learn from this ... through Advanced material from Professor Joe
Price: $39.95
List Price: $39.95 |
Advanced Access Example - Data Collection by Email
PrintShare it! — Rate it: up down flag this hub









elisabeth reid says:
2 years ago
Excellent...very useful information and links.
Thank you!!