Atjaunināt sīkdatņu piekrišanu

Using Microsoft Access 2010 [Mīkstie vāki]

3.70/5 (18 ratings by Goodreads)
  • Formāts: Paperback / softback, 352 pages, height x width x depth: 228x156x18 mm, weight: 470 g
  • Izdošanas datums: 05-Aug-2010
  • Izdevniecība: Que Corporation,U.S.
  • ISBN-10: 0789742896
  • ISBN-13: 9780789742896
Citas grāmatas par šo tēmu:
  • Mīkstie vāki
  • Cena: 30,43 €*
  • * Šī grāmata vairs netiek publicēta. Jums tiks paziņota lietotas grāmatas cena
  • Šī grāmata vairs netiek publicēta. Jums tiks paziņota lietotas grāmatas cena.
  • Daudzums:
  • Ielikt grozā
  • Pievienot vēlmju sarakstam
Using Microsoft Access 2010Palielināt
  • Formāts: Paperback / softback, 352 pages, height x width x depth: 228x156x18 mm, weight: 470 g
  • Izdošanas datums: 05-Aug-2010
  • Izdevniecība: Que Corporation,U.S.
  • ISBN-10: 0789742896
  • ISBN-13: 9780789742896
Citas grāmatas par šo tēmu:
Permanent link: https://www.kriso.lv/db/9780789742896.html
Get comfortable with Access 2010. Dont just read about it: see it, hear it, with step-by-step video tutorials and valuable audio sidebars delivered through the Free Web Edition that comes with every USING book. For the price of the book you get online access anywhere with a web connection--no books to carry, updated content, and the benefit of video and audio learning. Way more than just a book, this is all the help youll ever need...where you want, when you want!

 

Learn fast, learn easy, using web, video, and audio:





Show Me video walks through tasks youve just got to see--including bonus advanced techniques Tell Me More audio delivers practical insights straight from the experts

 

Audio sidebars featuring Ross Pimentel

 

 

UNLOCK THE FREE WEB EDITION--To register your USING book, visit quepublishing.com/using.
Chapter 1 Manipulationg Data with Databases and Tables
Show Me Media 1.1 Viewing and Navigating Table Data
21(2)
Show Me Media 1.2 Editing Existing Records
23(1)
Show Me Media 1.3 Adding Records to a Table
24(2)
Show Me Media 1.4 Selecting and Deleting Records
26(5)
Show Me Media 1.5 Filtering by Selection
31(1)
Tell Me More Media 1.6 What's Stored In a Database?
31(6)
Chapter 2 Using Queries to Retrieve the Data You Need
Show Me Media 2.1 Selecting Fields
37(3)
Show Me Media 2.2 Ordering the Query Result
40(11)
Show Me Media 2.3 Refining Queries with Criteria
51(5)
Show Me Media 2.4 Building a Query Based on Multiple Tables
56(1)
Tell Me More Media 2.5 Updatability of Query Results
56(9)
Chapter 3 Using forms to Enter and Edit Table Data
Show Me Media 3.1 Working with Data
65(7)
Show Me Media 3.2 Filtering Form Data
72(1)
Show Me Media 3.3 Viewing the Design of a form
72(5)
Show Me Media 3.4 Using a form Wizard
77(2)
Show Me Media 3.5 Taking Advantage of Conditional formatting
79(1)
Tell Me More Media 3.6 Uses for Forms
79(4)
Chapter 4 Using Reports to Print Information
Show Me Media 4.1 Opening and Viewing a Report
83(2)
Show Me Media 4.2 Printing a Report
85(4)
Show Me Media 4.3 AutoReports and the Report Wizard
89(1)
Show Me Media 4.4 Viewing the Design of a Report
90(1)
Tell Me More Media 4.5 Types of Reports Available
90(4)
Chapter 5 Creating Your Own Databases and Tables
Show Me Media 5.1 Creating a Database
94(3)
Show Me Media 5.2 Designing a Table from a Datasheet
97(2)
Show Me Media 5.3 Designing a Table from Scratch
99(7)
Show Me Media 5.4 Creating Indexes
106(11)
Show Me Media 5.5 Working with Field Properties
117(1)
Tell Me More Media 5.6 The All-Important Primary Key
117(12)
Chapter 6 Relating the Information in Your Database
Show Me Media 6.1 Establishing a Relationship Between Two Tables
129(2)
Show Me Media 6.2 Modifying Existing Relationships
131(5)
Show Me Media 6.3 Working with Cascade Update and Cascade Delete
136(1)
Tell Me More Media 6.4 The Importance of Relationships
136(3)
Chapter 7 Enhancing the Queries That You Build
Show Me Media 7.1 Adding Fields to Queries
139(3)
Show Me Media 7.2 Moving Fields on the Query Grid
142(2)
Show Me Media 7.3 Ordering Query Results
144(3)
Show Me Media 7.4 Refining a Query with Criteria
147(1)
Show Me Media 7.5 Updating Query Results
148(5)
Show Me Media 7.6 AutoLookup in Multitable Queries
153(4)
Show Me Media 7.7 Creating Calculated Fields within the Expression Builder
157(1)
Show Me Media 7.8 Creating and Running Parameter Queries
158(9)
Show Me Media 7.9 Creating and Running Action Queries
167(4)
Show Me Media 7.10 Using Aggregate Functions to Summarize Data
171(2)
Show Me Media 7.11 Working with Outer Joins
173(1)
Tell Me More Media 7.12 Building Queries Based on Multiple Tables
173(10)
Chapter 8 Building Powerful Forms
Show Me Media 8.1 Working with Controls
183(3)
Show Me Media 8.2 Conditional Formatting
186(5)
Show Me Media 8.3 Working with Form Properties
191(9)
Show Me Media 8.4 Working with Control Properties
200(5)
Show Me Media 8.5 Working with Combo Boxes
205(3)
Show Me Media 8.6 The Command Button Wizard
208(2)
Show Me Media 8.7 Building a One-to-Many Form by using the form Wizard
210(2)
Show Me Media 8.8 Building a One-to-Many form by Using the Subform Wizard
212(1)
Show Me Media 8.9 Working with Subforms
213(1)
Tell Me More Media 8.10 The Command Button Wizard: Programming Without Typing
213(10)
Chapter 9 Building Powerful Reports
Show Me Media 9.1 Working with Controls
223(7)
Show Me Media 9.2 Basing Reports on Multiple Table
230(1)
Show Me Media 9.3 Working with Subreports
231(4)
Show Me Media 9.4 Working with Sorting and Grouping
235(7)
Show Me Media 9.5 Taking Advantage of Report Properties
242(1)
Tell Me More Media 9.6 Improving Performance and Reusability by Basing Reports on Stored Queries
243(11)
Chapter 10 Automating Your Database with Macros
Show Me Media 10.1 The Basics of Creating and Running a Macro
254(2)
Show Me Media 10.2 Ways You Can Launch an Access Macro
256(3)
Show Me Media 10.3 Modifying an Existing Macro
259(3)
Show Me Media 10.4 Creating an Embedded Macro
262(3)
Show Me Media 10.5 Creating a data Macro
265(3)
Show Me Media 10.6 Creating a Drillthrough Macro
268(2)
Show Me Media 10.7 Testing a Macro
270(3)
Show Me Media 10.8 Converting a Macro to VBA Code
273(1)
Show Me Media 10.9 Creating an AutoExec Macro
274(1)
Tell Me More Media 10.10 When Should You Use Macros and When Shouldn't You?
274(5)
Chapter 11 Sharing Data with Other Applications
Show Me Media 11.1 Exporting to Another Access Database
279(2)
Show Me Media 11.2 Exporting to an Excel Spreadsheet
281(7)
Show Me Media 11.3 Importing from Another Access Database
288(4)
Show Me Media 11.4 Importing Spreadsheet Data
292(6)
Show Me Media 11.5 Linking to Tables in Another Access Database
298(2)
Show Me Media 11.6 Linking to Another Type of Database
300(5)
Show Me Media 11.7 Linking to SQL Server Databases
305(3)
Show Me Media 11.8 The Linked Table Manager
308(1)
Tell Me More Media 11.9 Practical Applications of Working with External Data
308(4)
Chapter 12 Working with Web Databases
Show Me Media 12.1 Creating a Blank Web Database
312(6)
Show Me Media 12.2 Creating Publishable Objects
318(2)
Show Me Media 12.3 Publishing Your Database to Access Services
320(1)
Tell Me More Media 12.4 The Pros and Cons of Using a Web Database
321
Alison Balter is the president of InfoTech Services Group, Inc., a computer consulting firm based in Newbury Park, California. Alison is a highly experienced independent trainer and consultant specializing in Windows applications training and development. During her 25 years in the computer industry, she has trained and consulted with many corporations and government agencies. Since Alison founded InfoTech Services Group, Inc. (formerly Marina Consulting Group) in 1990, its client base has expanded to include major corporations and government agencies such as Cisco, Shell Oil, Accenture, Northrop, the U.S. Drug Enforcement Administration, Prudential Insurance, Transamerica Insurance, Fox Broadcasting, the U.S. Navy, and others.

 

Alison is the author of more than 300 internationally marketed computer training videos and CD-ROMs, including 18 Access 2000 videos, 35 Access 2002 videos, 15 Access 2003 videos, 14 Access 2007 User Videos, and 18 Access 2007 Developer Videos. Alison travels throughout North America giving training seminars on Microsoft Access, Microsoft SQL Server, and Visual Basic for Applications. She is also featured in several live satellite television broadcasts for National Technological University.

 

Alison is also author of 13 books published by Sams Publishing: Alison Balters Mastering Access 95 Development, Alison Balters Mastering Access 97 Development, Alison Balters Mastering Access 2000 Development, Alison Balters Mastering Access 2002 Desktop Development, Alison Balters Mastering Access 2002 Enterprise Development, Alison Balters Mastering Microsoft Access Office 2003, Teach Yourself Microsoft Office Access 2003 in 24 Hours, Access Office 2003 in a Snap, Alison Balters Mastering Access 2007 Development, three e-books on Microsoft Access 2007, and Teach Yourself SQL Express 2005 in 24 Hours. Alison is a co-author of three Access books published by Sams Publishing: Essential Access 95, Access 95 Unleashed, and Access 97 Unleashed.

 

An active participant in many user groups and other organizations, Alison is a past president of the Independent Computer Consultants Association of Los Angeles and of the Los Angeles Clipper Users Group. She served as president of the Ventura County Professional Womens Network for two years.

 

Alisons firm, InfoTech Services Group, Inc., is available for consulting work and onsite training in Microsoft Access, Visual Studio .NET, and SQL Server, as well as for Windows Server 2003, Windows 2000, Windows NT, Windows Vista, Windows XP, PC networking, and Microsoft Exchange Server.