Über dieses Produkt

Product Identifiers

PublisherWiley & Sons, Incorporated, John

ISBN-100764540815

ISBN-139780764540813

eBay Product ID (ePID)2354987

Product Key Features

Number of Pages336 Pages

LanguageEnglish

Publication NameAccess 2003 : Your Visual Blueprint for Creating and Maintaining Real-World Databases

Publication Year2003

SubjectDatabases / General

TypeTextbook

AuthorF. Scott Barker

Subject AreaComputers

FormatTrade Paperback

Dimensions

Item Height0.4 in

Item Weight26 Oz

Item Length9 in

Item Width8 in

Additional Product Features

Intended AudienceTrade

LCCN2003-105640

Dewey Edition22

IllustratedYes

Dewey Decimal005.75/65

Table Of ContentHOW TO USE THIS BOOK.1) ARCHITECT YOUR ACCESS DATABASE.Understanding Relational Databases.Overview of Access.Using the Access Database Wizard.Download Additional Database Templates.Create a Blank Database.Create a New Table Using Data.Create a New Table with the Designer.Create an Input Mask.Add a Validation Rule and Validation Text.Add the Default Value and Required Properties.Specify Lookup Values.Establish Relationships.Link Access Tables.Link SQL Server Tables2) CREATING QUERIES TO VIEW YOUR INFORMATION.Understanding SQL.Types of Queries Found in Access.Create a Basic Query.Sort Columns.View and Modify SQL Directly.Add Simple Criteria to a Query.Add Complex Criteria to a Query.Create a Parameter Query.Display a Calculated Column.Using Multiple Tables.Update Existing Records.Append New Records.Make a New Table Using a Query.Delete Records.3) ADVANCED QUERIES.Understanding Join Types.Create an Inner Join.Create Left and Right Outer Join.Summarize Data Using a Totals Query.Retrieve the Top Values.Create a Simple Crosstab Query.Control Order of Headings.Add Row Totals to Your Crosstab Query.Total Up Crosstab Columns.Create Data Definition Queries.4) WORKING WITH FORMS.Form Basics.Create a Datasheet View Form Using an AutoForm.Move Through the Datasheet.Filter By Selection.Filter By Form.Find and Replace Data in Your Datasheet.Using the Form Wizard.Tools of Form Design View.Introducing Form Properties.Create a Single Page Form Using the Design View.Set Form Properties.Work with Multiple Controls.Create a Form in the Continuous Form View.5) UTILIZING CONTROLS ON FORMS.Match the Control with the Correct Purpose.Display a Calculated Expression in a Text Box.Correct Control Errors.Create an Option Group Control.Add a Combo Box Control to Limit Data.Utilize Hidden Columns in a Combo Box.Add a List Box Control.Add Smart Tags to Controls.Add a Tab Control to a Form.Add Data to the Tab Control Pages.Add Graphics to a Form.Using a Subform to Display Main/Detail Data.Limit Data in a Subform with a Combo Box.Display a Summarized Subform Column in the Mainform.Using the ActiveX Calendar Control.6) VBA FOR AUTOMATING YOUR APPLICATION.Understanding VBA Basics.Why Use VBA and Not Macros?Convert Your Macros.Set Up the Integrated Development Environment.Learn to Code from the Command Button Wizard.Using DoCmd to Open Forms and Queries.Using Variables and Constants.Using the MsgBox Statement.Control Branching.Loop Using For...Next.Loop Using Do While/Until.Add Error Handling.7) USING VBA BEHIND YOUR FORMS.Using Code Behind Forms and Events.Work with Events for Forms and Controls.Syntax for Using Forms and Controls in VBA.Modify Form and Control Properties at Runtime.Using Form and Control Variables.Validate a Required Value Before Updating.Work with Data Behind a Form.Utilize a Combo Box to Locate Records.Toggle a Form's Viewing or Editing.Display or Hide Tab Control Pages.8) CREATING REPORTS.Introducing Access Reports.Various Report Possibilities.Take Advantage of the Report Wizard.Create a New Report.Work with Calculated Expressions.Hide Rows Based on the Value of a Field.Sort Information on Reports.Add Groupings to a Report.Open a Report Based on a Form Filter.Supply a Parameter Using a Form.Display Different Views of the Same Report.9) ANALYZING DATA USING PIVOTTABLE AND PIVOTCHART VIEWS.Introducing the Pivot Table and PivotChart.Using the PivotTable Wizard.Add a Filter to the Pivot Table.Using Top/Bottom Values and Other Filters.Display Summary/Detail Data.Create a Simple PivotChart Form.Drill, Filter, and Get Data on PivotCharts.10) IMPORTING, LINKING, AND EXPORTING DATA.Import or Link Data.Export Data from Access.Using Windows SharePoint Services.Introducing XML.Split and Link an Access Database.Import Data from Microsoft Excel.Import Data from Text Files.Import Data from SQL Server.Import Lists from Windows SharePo

SynopsisAccess is the world2s most widely used database application. This book explains database concepts, then shows how databases are built to perform in real-world business situations. ., Access is the world's most widely used database application. This book explains database concepts, then shows how databases are built to perform in real-old business situations., Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 140 key techniques to help you make the most of Access 2003, including:Building charts and graphsDesigning user-friendly formsCreating tables, queries, and Data Access PagesWriting macrosConverting macros to VBA codeSetting up database relationshipsProgramming Access with VBAWriting and using classesManaging databasesUsing ActiveX Data ObjectsUsing Data Access Pages in a Web siteTrial software and more on CD-ROM!Demo versions of Speed Ferret and Total Access AnalyzerTrial versions of Total Visual SourceBook code library, Total Access Admin database maintenance control, and Total Access Components (ActiveX controls written for Access)Sample databases from the bookAssorted other database tools from FMS Inc.Links to various downloadable filesA searchable e-version of the book'Apply It' and 'Extra'sidebars highlight useful tipsHigh-resolution screen shots demonstrate each taskSuccinct explanations walk you through step by stepTwo-page lessons break big topics into bite-sized modules

LC Classification NumberQA76.9.D3