By Michael Alexander
Read or Download Microsoft Office Access 2007 Data Analysis PDF
Best databases books
This ebook brings all the parts of database layout jointly in one quantity, saving the reader the time and rate of creating a number of purchases. It consolidates either introductory and complicated issues, thereby protecting the gamut of database layout method ? from ER and UML strategies, to conceptual facts modeling and desk transformation, to storing XML and querying relocating gadgets databases.
Oracle Call Interface. Programmer's Guide
The Oracle name Interface (OCI) is an program programming interface (API) that permits functions written in С or C++ to engage with a number of Oracle database servers. OCI provides your courses the potential to accomplish the entire diversity of database operations which are attainable with an Oracle database server, together with SQL assertion processing and item manipulation.
Oracle Warehouse Builder 11g: Getting Started
This easy-to-understand educational covers Oracle Warehouse Builder from the floor up, and faucets into the author's huge adventure as a software program and database engineer. Written in a peaceful type with step by step causes, plenty of screenshots are supplied during the ebook. there are lots of counsel and necessary tricks all through that aren't present in the unique documentation.
Additional resources for Microsoft Office Access 2007 Data Analysis
Sample text
You will get six sections. Each section represents one of the six database objects: Tables, Queries, Forms, Reports, Macros, and Modules. The Tables selection is appropriately at the top of the list, because it is the precise location where your data will be stored. All other database objects will refer to the tables in your database for data, whether asking questions of the data or creating reports based on the data. This section covers the basics to get you working with Access tables. qxp 16 2/17/07 Part I ■ 12:50 AM Page 16 Fundamentals of Data Analysis in Access Figure 2-1: The navigation pane on the left enables you to navigate through the six types of database objects: Tables, Queries, Forms, Reports, Macros, and Modules.
After setting the sort order of the State column to ascending, the query output simply looks better and more professionally formatted, as seen in Figure 2-20. Figure 2-19: The sort order options for a column are provided by the Query Design view. Figure 2-20: The results of the query are now sorted in ascending order by the State field. qxp 42 2/17/07 Part I ■ 12:51 AM Page 42 Fundamentals of Data Analysis in Access Filtering Query Results Next, you’ll examine how you can filter the query output so that you retrieve only the specific records to analyze.
A quick scan of the results verifies that indeed only records with CA in the State column were returned, as shown in Figure 2-22. Figure 2-21: The Criteria section is where you type in a value for which you want to filter the data. qxp 2/17/07 12:51 AM Page 43 Chapter 2 ■ Access Basics Figure 2-22: The results of the query will be all records that match the criteria. T I P You can sort and filter query results just as if they were a Table. Simply click the drop-down arrow next to each of the column headings to active the sorting and filtering context menu.