• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 1. What Is Microsoft Access? > Microsoft Access as an Application Devel...

Microsoft Access as an Application Development System

Being able to define exactly what data you need, how it should be stored, and how you want to access it solves the data management part of the problem. However, you also need a simple way to automate all the common tasks you want to perform. For example, each time you need to enter a new order, you don’t want to have to run a query to search the Customers table, execute a command to open the Orders table, and then create a new record before you can enter the data for the order. And after you’ve entered the data for the new order, you don’t want to have to worry about scanning the table that contains all your products to verify the order’s sizes, colors, and prices.

Advanced word processing software lets you define templates and macros to automate document creation, but it’s not designed to handle complex transaction processing. In a spreadsheet, you enter formulas that define what automatic calculations you want performed. If you’re an advanced spreadsheet user, you might also create macros or Visual Basic procedures to help automate entering and validating data. If you’re working with a lot of data, you’ve probably figured out how to use one spreadsheet as a “database” container and use references to selected portions of this data in your calculations.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint