To be honest, I have never used MS Access at all. After getting some information on line to learn about it, it is actually a great program to manage data as Excel at some point.
“Microsoft Access works in the same manner any database does, by storing related information together, and letting you create connections (commonly called relationships) between different things. The relationships between two different things in MSAccess can be very simple (such as a contact at a customer and the customer itself) or complex.
Once you have your MS Access tables, fields, and relationships set up, you can create data entry forms that use those tables to store your information and later create reports with the data. Microsoft Access forms are incredibly easy (and fun) to design with a wysiwyg form design tool. And you can use MS Access forms to simplify data entry for users by grouping related fields together, and hiding fields they don’t need to enter. ”
Here is an example of how people use Access for creating and managing invoices step by step:
“Step 1
Download the Desktop Time and Billing template for Access 2003 and 2007 or the Desktop Services template for Access 2010. Both are available from the Microsoft Office website under the “Templates” tab at the top of the page (see link in Resources).
Step 2
Launch Access. In 2003 or 2007 go to “File | Templates | Time & Billing | Project List | Reports | Invoice.” In Access 2010, a “Quotes & Invoices” tab automatically appears on the dashboard.
Step 3
Select the invoice template you want to use in Access 2003 or 2007, or click the “Add New Invoice” button on the Access 2010 dashboard. From here the invoicing steps are the same regardless of version.
Step 4
Enter the status, employee name, customer name and amounts into the appropriate fields. You’re prompted to create a new customer record if the name isn’t already found in Access.
Step 5
Click “Save & Close” and then “Next” to exit. The invoice appears in the “Report Center” tab of Access 2003 and 2007 and the “Invoices” tab in Access 2010. Choose to sort by “Unpaid,” “Past Due” or “Paid.”
Step 6
Click the invoice number to edit, print or change the status of an invoice. Choose “Save & Close” to save changes.”
Obviously Access helps a lot in saving time and better management. With skills of using Excel and Access, people can boost up efficiency and lead to a higher level productivity.
Source come from these cite:
http://www.opengatesw.net/ms-access-tutorials/What-Is-Microsoft-Access-Used-For.htm
http://smallbusiness.chron.com/use-microsoft-access-invoicing-47733.html
Posed by Wenshi Cao
