| Description |
xxiv, 775 pages : illustrations ; 23 cm. + 1 CD-ROM (4 3/4 in.) |
| Note |
Includes index. |
| System Details |
System requirements for accompanying CD-ROM: Acrobat Reader. |
| Contents |
Cover -- Contents -- Acknowledgments -- Introduction -- Part I: Getting Started -- 1 Quick Tour of Microsoft Office Access 2007 -- Starting Access and Opening a Database -- Looking at a Table -- Looking at the Wizards -- Getting Help -- Summary -- 2 The World of Relational Databases -- What is a Relational Database? -- Defining Database Objects -- Inspecting the Sample Database -- The Payoff -- Summary -- 3 Creating a Database -- Designing the Database -- Introducing Home Tech Repair -- Creating a Database from a Template -- Running the New Application -- Starting with a Blank Database -- Summary -- 4 Creating and Modifying Tables -- Creating a New Table from a Template -- Creating a New Table in Datasheet View -- Creating a New Table in Design View -- Modifying the Table Design -- Ensuring Data Validity -- Copying an Existing Table Structure -- Setting Table Properties -- Summary -- 5 Relating Tables -- Defining a Relationship -- Viewing and Editing Relationships -- Printing the Relationships -- Summary -- 6 Entering and Editing Data -- Entering New Data -- Customizing Data Entry -- Changing the Datasheet Appearance -- Changing a Table Definition -- Editing Record Data -- Printing Table Data -- Summary -- Part II: Retrieving and Presenting Information -- 7 Sorting, Filtering, and Printing Records -- Sorting Records -- Filtering Records -- Printing Table Data -- Summary -- 8 Extracting Information with Queries -- How Do Queries Work? -- Creating Select Queries -- Adding Selection Criteria -- Setting Query Properties -- Modifying a Query -- Performing Calculations in a Query -- Creating Special Queries with the Query Wizard -- Printing the Query Results -- Deleting a Query -- Summary -- 9 Creating Advanced Queries -- Creating Special Purpose Queries -- Designing Action Queries -- Introducing Structured Query Language -- Creating a Subquery -- Summary -- 10 Creating Form and Report Designs -- Deciding the Database Object Type -- Common Design Elements -- Working in the Design Window -- Modifying Form Sections and Controls -- Deleting Controls -- Adding Other Objects and Special Effects -- Changing Form and Report Properties -- Summary -- 11 Using the Form Tools -- Creating a New Form Design -- Using the Form Wizard -- Modifying the Form Design -- Using the Form for Data Entry -- Printing the Form -- Looking at the Other Wizards -- Creating a Hierarchical Form from Related Tables -- Summary -- 12 Customizing Forms -- Starting a New Custom Form -- Creating a Multiple-Page Form -- Adding Special Controls -- Introducing the Police Database -- Adding a Subform -- Adding Custom Help -- Validating or Restricting Data in Forms -- Summary -- 13 Using the Report Wizard -- Creating a New Report Design -- Previewing the Report -- Printing the Report -- Modifying the Report Design -- Saving the Report Design -- Using Report Snapshots -- Summary -- 14 Customizing Reports -- Creating a New Report Design -- Filtering, Sorting, and Grouping Records in Layout View -- Adding a Subreport -- Designing a Multiple-Column Report -- Printing Maili. |
| Subject |
Microsoft Access.
|
|
Database management.
|
| ISBN |
0072263504 alkaline paper |
|
9780072263503 alkaline paper |
|
