This week in class we learned how to use different skills within access. Specifically we went over database and tables, queries, forms, and reports. I learned that using these 4 tools together there is an infinite possibility for maximizing efficiency within your company database. Using access you can create tables that record information as rows and columns which are then used as values for queries, forms, and reports. Tables can be created by importing external data as well such as spread sheets from excel which is extremely useful. Queries can then be made from this data in your tables. This can be very useful in many instances. For example if your database took in orders for different pizzas, you would want to know at what time your orders came in and for maximum efficiency, have them listed in the order the pizzas should be delivered and are to head out the door.
Forms are also very useful because they can use the data from your queries and tables to make an actual interface for your database to be interacted with. You can add fields to a form where values can be entered by say, customers or employees and that information is used however you see fit. It can be stored as a new data input if you make an invoice in the form of a report which then is accounted for in your queries and can be used for business. Lastly reports were used to construct a summary of information which can be easily grouped and sorted and is very useful for quick access to vital information for decision making. These skills are extremely important and can be used in many real world situations.
I am currently in the beginning phases of starting my company and learning all these new skills has given me confidence that starting my company is more attainable now than ever!
Here is a link of a database file i made for practice and below that a site and video with tips for use and organizing your life with access.
https://docs.google.com/open?id=0B22B348ZyC7jeGZZUERWNWJTV3kzX1FjaGo4MERKUQ
http://msaccesstips.com/
No comments:
Post a Comment