Being able to get information when and how you need it is one of the most important functions of a database. This class is designed for people who need to locate and extract data stored in an Access 97 database. A query is a request for specific information, based on search criteria. For example, you might query an Access table to see how many people work in the Sales department or who is enrolled in the company's medical insurance program. There are many different types of queries.
Some queries perform calculations, and other queries change data globally.
In this class, you will improve your query skills so you can extract virtually any data or combination of data from your Access 97 system. A picture is usually worth more than the proverbial 1,000 words. With a little help from Excel 97, you can transform your financial worksheets into clear, persuasive business charts You will learn how Excel thinks about worksheet data, and how Excel converts data into a visual representation. If you have little or no experience with charting or with charting in Excel 97, this class will teach you the fundamentals of business graphics. The essence of a successful chart is simplicity.