Atnaujinkite slapukų nuostatas

El. knyga: Professional Access 2013 Programming

3.92/5 (19 ratings by Goodreads)
, , ,
  • Formatas: PDF+DRM
  • Išleidimo metai: 01-Aug-2013
  • Leidėjas: Wrox Press
  • Kalba: eng
  • ISBN-13: 9781118530825
Kitos knygos pagal šią temą:
Professional Access 2013 ProgrammingDidesnis paveikslėlis
  • Formatas: PDF+DRM
  • Išleidimo metai: 01-Aug-2013
  • Leidėjas: Wrox Press
  • Kalba: eng
  • ISBN-13: 9781118530825
Kitos knygos pagal šią temą:

DRM apribojimai

  • Kopijuoti:

    neleidžiama

  • Spausdinti:

    neleidžiama

  • El. knygos naudojimas:

    Skaitmeninių teisių valdymas (DRM)
    Leidykla pateikė šią knygą šifruota forma, o tai reiškia, kad norint ją atrakinti ir perskaityti reikia įdiegti nemokamą programinę įrangą. Norint skaityti šią el. knygą, turite susikurti Adobe ID . Daugiau informacijos  čia. El. knygą galima atsisiųsti į 6 įrenginius (vienas vartotojas su tuo pačiu Adobe ID).

    Reikalinga programinė įranga
    Norint skaityti šią el. knygą mobiliajame įrenginyje (telefone ar planšetiniame kompiuteryje), turite įdiegti šią nemokamą programėlę: PocketBook Reader (iOS / Android)

    Norint skaityti šią el. knygą asmeniniame arba „Mac“ kompiuteryje, Jums reikalinga  Adobe Digital Editions “ (tai nemokama programa, specialiai sukurta el. knygoms. Tai nėra tas pats, kas „Adobe Reader“, kurią tikriausiai jau turite savo kompiuteryje.)

    Negalite skaityti šios el. knygos naudodami „Amazon Kindle“.

Authoritative and comprehensive coverage for building Access 2013 Solutions

Access, the most popular database system in the world, just opened a new frontier in the Cloud. Access 2013 provides significant new features for building robust line-of-business solutions for web, client and integrated environments.  This book was written by a team of Microsoft Access MVPs, with consulting and editing by Access experts, MVPs and members of the Microsoft Access team. It gives you the information and examples to expand your areas of expertise and immediately start to develop and upgrade projects.









Explores the new development environment for Access web apps Focuses on the tools and techniques for developing robust web applications Demonstrates how to monetize your apps with Office Store and create e-commerce solutions Explains how to use SQL Server effectively to support both web and client solutions Provides techniques to add professional polish and deploy desktop application Shows you how to automate other programs using Macros, VBA, API calls and more.

Professional Access 2013 Programming is a complete guide on the latest tools and techniques for building Access 2013 applications for both the web and the desktop so that developers and businesses can move forward with confidence. Whether you want to add expand your expertise with Client/Server deployments or start developing web apps, you will want this book as a companion and reference.
Introduction xxvii
Part I: Access Web Application Design and Development
Chapter 1 Introduction To Access Web Apps And Architecture
3(22)
Deprecated Components
4(8)
Access Data Projects
5(1)
Jet Replication
6(1)
Menus and Toolbars
6(1)
Import/Export/Link to Jet 3.x and dBASE Files
7(1)
PivotTables and PivotCharts
8(1)
Collect Data via E-mail
8(1)
SharePoint Workflow
8(1)
Source Code Control Extension
9(1)
Packaging Wizard
10(1)
Upsizing Wizard
10(1)
Creating Access Web Databases
11(1)
New Components Added
12(1)
Database Compare
12(1)
Audit and Control Management Server
13(1)
What Is an App?
13(2)
How Is an App Hosted?
15(1)
How Is an App Distributed?
16(2)
App Marketplace for Publicly Available Solutions
16(1)
App Catalogs for Internal-Facing Solutions
16(2)
How Are Security and Trust Managed in Apps?
18(6)
Setting Up a SharePoint Site for Your Apps
20(1)
Setting Up an Office 365 Trial Account
21(3)
Solving Business Problems
24(1)
The Maid To Order Work Schedule Database
24(1)
Summary
24(1)
Chapter 2 Designing Tables
25(20)
Creating a Blank App
26(1)
Keeping Your Log Ins Straight
27(2)
Creating Tables
29(9)
Creating Tables Using Nouns
29(2)
Creating Tables from Imported Data Sources
31(5)
Creating Tables the Traditional Way
36(1)
Tables and Their Related Views
37(1)
Data Type Changes from Previous Versions
38(2)
Text Data Type
38(1)
Hyperlink Fields
39(1)
Numeric Data Type
39(1)
Date/Time Data Type
40(1)
Image Data Type
40(1)
Lookup Data Type
40(1)
Field Properties
40(1)
Linking SharePoint Lists
41(1)
Summary
42(3)
Chapter 3 Understanding The New User Interface
45(28)
Web Navigation
46(14)
Navigation Tools
46(5)
The New Approach to Layout
51(4)
The New Ribbon
55(5)
Mobile Devices Support
60(5)
SharePoint and Office 365
65(5)
Creating a Web App via Team Site
67(2)
Deleting Web Apps
69(1)
Sharing Web Apps with Others
69(1)
Summary
70(3)
Chapter 4 Designing Views
73(42)
View Design Surface
74(19)
Ribbon
75(1)
Tiles
76(2)
Links and Creating Views
78(1)
Field List
79(5)
Popup Properties
84(4)
Manipulating Control Placement
88(4)
Duplicating a View
92(1)
Action Bar and Action Bar Buttons
93(3)
Action Bar Button Properties
93(1)
Default Action Button
94(1)
Custom Action Buttons
95(1)
Controls
96(18)
Changed Controls
96(7)
New Controls
103(5)
Common Properties
108(1)
Client Controls with No Counterparts
109(1)
Web Browser Control
110(4)
Summary
114(1)
Chapter 5 Creating Queries And Writing Expressions
115(34)
Query Architecture
116(3)
SQL Server Views
116(1)
Table-Valued Functions
117(2)
Changes in the Query Designer
119(9)
Creating, Editing, Saving, and Previewing Queries
119(6)
Action Queries
125(1)
Parameterized Queries
125(1)
Aggregates, Unique Values, and Top Values
126(1)
Query Properties
127(1)
Functions and Expressions
128(20)
Delimiters
129(1)
Operator Differences
129(2)
New Constants
131(1)
Data Type Inspection and Conversion
132(3)
String Functions
135(4)
Date and Time Functions
139(2)
Math Functions
141(4)
Other Functions
145(1)
Availability by Context
146(2)
Summary
148(1)
Chapter 6 Creating Macros
149(28)
Why We Need a New Web-Compatible Macro Language
150(2)
Where We've Been
150(1)
Access's Traditional Role as Tool of First Choice
151(1)
Macro Designer
152(5)
Action Catalog
153(1)
Expressions and Expression Builder
153(1)
Data Macro Tracing
154(1)
Parameter Box
155(1)
Macro Links
155(1)
Interacting with the Macro Designer
155(2)
Different Types of Macros
157(3)
UI Macros
157(1)
Data Macros
157(1)
Data Macro Architecture
158(1)
UI Macro Architecture
159(1)
Block Macro Action
160(1)
Creating and Editing Data Macros
160(6)
Creating a Standalone Data Macro
162(1)
Using the Action Catalog
162(1)
Using the Add New Action Drop-Down
162(1)
Using Program Flow Actions
162(3)
How to Use the LookupRecord Data Block
165(1)
How to Use ForEachRecord and EditRecord
165(1)
How to Use DeleteRecord
166(1)
Creating and Editing UI Macros
166(6)
How to Use SetProperty
168(1)
How to Use ChangeView and OpenPopup
169(2)
How to Use RequeryRecords
171(1)
How to Use Data Entry Operations
171(1)
Using UI and Data Macros Together
172(3)
How to Create and Use Parameters
172(2)
How to Return Values
174(1)
Summary
175(2)
Chapter 7 Designing The Table Structure
177(26)
New Data Types
178(15)
Short and Long Text Fields
178(4)
Number Fields
182(1)
Date/Time Fields
183(4)
Currency
187(1)
Yes/No
188(1)
Hyperlink
188(1)
Image
189(1)
Calculated Fields
190(1)
Lookup Fields
191(2)
Validation Rules and Text
193(4)
Field Level Validation
193(2)
Record Level Validation
195(1)
Editing Validation Rules with Existing Data
195(1)
Validation Rules Design Consideration
196(1)
Leveraging Calculated Fields
197(3)
Creating Concatenated Fields
197(2)
Configuration Tables
199(1)
Tally Table
199(1)
Utility Table
200(1)
Summary
200(3)
Chapter 8 Designing The User Interface
203(62)
Naming Convention for Web Apps
204(1)
Planning the User Interface
205(1)
Reusing Create, Read, Update, and Delete Views
205(1)
Effective Navigation Design
206(10)
Traditional Navigation Patterns
206(5)
Web Design Principles
211(4)
Tile-Bound View and Popup Views
215(1)
Creating a Splash Screen
216(3)
Designing an Index Form
219(18)
List View: Searching on a field
219(4)
Summary View: Searching on an Aggregated Value
223(7)
Datasheet: Filtering Cumulatively
230(7)
Creating a Query By View
237(26)
SQL Construction
237(4)
Techniques for Filtering
241(5)
Design Requirements
246(2)
Creating Filter Tables
248(1)
Creating Data Macro to Clear Selections
249(1)
Creating Query By View
249(3)
Filtering Query
252(5)
Building Data Macros to Populate Filter Tables
257(3)
Building a Popup View to Display the Filter Results
260(1)
Building a Click Event Handler
261(2)
Summary
263(2)
Chapter 9 Solving Business Problems With Macros
265(40)
Macro Design Considerations
266(4)
When to Use Data Macros
266(2)
When to Use UI Macros
268(1)
On Start Macro
269(1)
Using Freestanding Macros
270(26)
Cloning a Record
270(8)
Generating a Set of Records with Variable Parameters
278(12)
Generating Records in Different Tables
290(4)
Updating and/or Deleting Several Records
294(2)
Using Table Events
296(7)
Performance Considerations
297(1)
Preventing Deletions of Completed Records
298(2)
Acquiring Default Values from Other Tables
300(1)
Maintaining a History of Change
301(2)
Summary
303(2)
Chapter 10 Extending Web Apps
305(92)
Integration Options
306(5)
Security Considerations
307(3)
Introduction to Web Services
310(1)
Linking a Web App for Additional Functionality
311(11)
Locating and Adding the Locations Mapper App
311(4)
Configuring and Using the Locations Mapper App
315(7)
Inlining a Web App in Access Web App
322(11)
Adding a PayPal Button
333(8)
Getting the PayPal HTML
333(3)
Authoring a Custom Page in SharePoint Designer
336(2)
Allowing Framing of Custom Page
338(1)
Adding the PayPal HTML
339(1)
Showing a PayPal Button on an Access Web App
340(1)
Adding a Site Mailbox
341(21)
Configuration for a Site Mailbox
342(1)
Setting Up the Site Mailbox
343(4)
Team Site Mailbox as a Shared Tool
347(15)
Using APIs with a Web Browser Control
362(9)
Building a Page to Handle JavaScript Code
363(3)
Development Experience
366(2)
Adding the Charting Page to Access Web App
368(3)
Consuming ZIP-Lookup Web Services in the Client
371(23)
Creating a User Account for the Web Service
372(1)
Library References and Code
373(21)
Summary
394(3)
Chapter 11 Connecting To Your Web App
397(52)
Info Backstage
398(1)
Connections
399(2)
Enable/Disable Connection
400(1)
Getting Connection Details
401(1)
Reset Passwords
401(1)
Using the Access Client
401(11)
Adding VBA Code to Relink
406(3)
Best Practices
409(3)
Using Excel
412(18)
Creating an ODC Connection
412(3)
Creating an Excel Table
415(1)
Creating an Excel PivotChart
416(4)
Creating an Excel PivotTable
420(1)
External Data Considerations
421(4)
Sharing Excel Workbooks on the Web
425(5)
Using SSMS
430(16)
Connecting to a Web App Database
430(3)
Adding a Linked Server on the Web App Database
433(4)
Querying Data in a Linked Server
437(5)
Using Linked Server Programmability Objects
442(4)
Summary
446(3)
Chapter 12 Web Apps In The Enterprise
449(32)
Creating a Document Library
450(13)
Creating a Custom Content Type
452(3)
Importing Image Files
455(1)
Customizing a Library
456(2)
Customizing a Library Ribbon
458(2)
Version Control
460(3)
Customizing an App Package
463(4)
Linking to a Template File
467(1)
Synchronizing Data Between App Databases
468(11)
Local Differential Backup
468(11)
Choosing Approaches
479(1)
Summary
479(2)
Chapter 13 Implementing Security Models For The Access Web App
481(58)
Security Considerations
482(3)
File-Based Security
482(1)
Agent-Based Security
482(1)
Securing Web Apps on SharePoint
483(1)
Security in the Application Layer
484(1)
SharePoint Security
485(9)
Team Sites and Personal Storage
486(1)
Managing User Accounts
486(4)
Extending Permissions
490(1)
External User Accounts
491(1)
Anonymous Access
492(2)
Securing Web Apps in the Web Browser
494(15)
Using Subsites to Restrict Users to Specific Apps
498(1)
Sites and Subsites
499(10)
Traditional Methods for Security in Client Solutions
509(4)
Web App Linked File Security
513(24)
DSN-Less Linking and Relinking
514(1)
Password Storage/Non-Storage
515(17)
Local SQL Server
532(5)
Summary
537(2)
Chapter 14 Deploying Access Web Apps
539(26)
Deploying Access Web Apps
540(22)
Web Apps and App Catalogs
540(1)
On-Premises SharePoint Server
541(10)
Versioning Web Apps
551(11)
Summary
562(3)
Part II: Client-Server Design and Development
Chapter 15 Managing Data Sources
565(20)
Normalization
566(2)
First Normal Form: Eliminate Repeating Groups
566(1)
Second Normal Form: Eliminate Duplicate Data
567(1)
Third Normal Form: Eliminate Fields That Do Not Depend on the Key
567(1)
Other Normalization Forms
568(1)
Normalization Examples
568(2)
Un-Normalized Table
568(1)
First Normal Form: Eliminate Repeating Groups
568(1)
Second Normal Form: Eliminate Duplicate Data
569(1)
Third Normal Form: Eliminate Fields That Do Not Depend on the Key
569(1)
Primary Keys
570(2)
Overview of Access Files and the Database Engine
572(1)
Other Data Sources
572(7)
Overview of ODBC Linking
573(3)
Managing Linked Objects
576(3)
Querying External Data Effectively
579(3)
Linked Object Performance and Query Optimization
579(1)
Passthrough Query and T-SQL
580(1)
Comparing Access SQL and T-SQL
581(1)
Summary
582(3)
Chapter 16 Programming Using VBA, APIs, And Macros
585(58)
VBA
586(11)
Procedures
586(1)
User-Defined Functions
586(5)
Error Handling
591(5)
Debugging
596(1)
Leveraging Queries
597(11)
Enhancing Query Techniques
597(7)
Query by Form
604(2)
Creating a Query On the Fly Using VBA
606(2)
API
608(16)
Obtaining Documentation for API Functions
609(1)
Mapping Data Types
609(1)
VBA User-Defined Types and C-Style Structs
610(1)
Pointers and Handles
611(1)
32-Bit vs. 64-Bit
611(2)
Putting It All Together: Create and Manage an Explorer Window
613(4)
API Declaration
617(1)
Declaring the Enumeration Function
618(1)
Declaring the Callback Function
619(1)
Determining the Class Name of a Window
619(1)
Preparing the EnumChildProc for Two Different Uses
620(1)
Creating the Main Procedure
620(1)
Retrieving Window Information
621(1)
Tips and Techniques
622(2)
Introduction to Data Macros
624(4)
Why Use Data Macros?
625(1)
Differences in Client and Web Data Macros
625(1)
Use Cases for Data Macros
626(2)
Creating Data Macros
628(13)
Maintaining Calculated Values to Support Indexing
628(3)
Maintaining Quantity On Hand to Support Business Logic
631(9)
Data Macros and VBA
640(1)
Summary
641(2)
Chapter 17 Creating Intuitive Forms
643(44)
Creating Intuitive Forms
644(3)
Clean Layout
645(1)
Guiding the User Through the Process
645(1)
Showing and Verifying Data in a Timely Manner
646(1)
User-Friendly Messages and Tips
646(1)
Leveraging Built-in Functionality
647(6)
Textbox
647(1)
Label
648(1)
Command Buttons
649(1)
Split Forms
650(2)
Pop-up, Modal, or Dialog Forms
652(1)
The Demo Forms
653(10)
Tag Property
653(1)
Displaying Images
654(2)
List and Combo Boxes
656(1)
Datasheet View Search Forms
657(3)
Multiple Instances of a Form
660(3)
Multi-Value Fields
663(5)
Appending MVFs
664(1)
Appending Attachments
665(3)
Report Runner
668(17)
Creating the Foundation
668(1)
Setting Up the Report and Its Criteria Fields
669(4)
Selecting the Criteria and Running the Report
673(12)
Summary
685(2)
Chapter 18 Creating Powerful Reports
687(30)
Introduction to Reports
688(1)
Creating Reports
689(11)
Fundamentals
689(4)
Creating and Customizing Reports
693(3)
SubReports
696(2)
Drill Down Reports
698(2)
Report Examples
700(9)
Grouping Data
700(1)
Reports with Simple Criteria
701(1)
Reports with Simple Groupings
702(1)
One Flexible Report
702(4)
Calling the Criteria Form from the Report
706(1)
Reports that Compare Values
706(3)
Professional Polish
709(3)
Report Criteria
709(2)
Confidentiality Statement
711(1)
Page Numbers and Report Date
711(1)
Report Name
711(1)
Using Work Tables
711(1)
Filling Out PDF Forms Using Access
712(3)
Using Reports
712(1)
Using an XFDF file
713(2)
Summary
715(2)
Chapter 19 Automating And Integrating With Other Programs
717(46)
Overview of Interoperability
717(2)
Getting Started with Automation
719(5)
Declare and Instantiate Variables
721(1)
Early Binding Versus Late Binding
722(2)
Automating Office Programs
724(1)
Microsoft Excel Integration
725(12)
Integration with Excel Using Ribbons, Menus, and Macros
725(3)
Referencing the Excel Object Library
728(1)
Working with the Excel Object Model
728(1)
Using Automation to Send Data to Excel
728(3)
Creating an Excel PivotTable from Access
731(3)
Generating an Excel Chart from Access
734(3)
Word Integration
737(7)
Integration with Word Using Ribbons, Menus, and Macros
737(1)
Referencing the Word Object Library
737(1)
Working with the Word Object Model
738(1)
Sending Access Data to Word with Automation
738(3)
Using Access Automation to Create Word Tables
741(3)
PowerPoint Integration
744(5)
Setting a Reference to the PowerPoint Object Library
745(1)
Working with the PowerPoint Object Model
745(1)
Creating a Presentation from an Access Table
745(4)
Outlook Integration
749(10)
Sending Outlook Mail Using a Macro Action
750(1)
Referencing the Outlook Object Model
751(1)
Sending Mail Using VBA and Automation
751(2)
Reading and Moving Mail Using VBA and Automation
753(2)
Creating Other Outlook Items Using VBA and Automation
755(4)
Integrating Access with Other Applications
759(3)
Summary
762(1)
Chapter 20 Securing, Deploying, And Maintaining Access Applications
763(32)
User Level Security and Audit Trail
764(8)
Local User Table
765(1)
Network Identity
766(1)
Network Identity with a User Table in Access Database
766(1)
Different Front-end Files for Different User Roles
767(1)
Security Summary
767(1)
Converting from .mdb with User Level Security to .accdb
768(1)
Audit Trail
769(1)
Using VBA
770(1)
Using Data Macros
771(1)
Remote Query
772(1)
Deployment Considerations
772(6)
Deploying Front-end Files
773(2)
Auto-Updating the Front End
775(1)
Deploying Back-end Changes
776(2)
Maintaining Different Environments
778(1)
Development, Test, and Production Environments
778(8)
Promoting Files from Test to Production
784(1)
Version Control
785(1)
Data Maintenance
786(5)
Automating Backups
786(3)
Automating Maintenance
789(2)
How to Kick Users Out of the Application
791(1)
Ownership of Code
791(3)
Intellectual Property Rights
791(1)
Trial Version
792(2)
Summary
794(1)
Chapter 21 Maximizing SQL Server Capabilities
795(28)
Upsizing
795(12)
When to Upsize
796(6)
The Upsizing Process
802(3)
Things to Watch for When Upsizing
805(2)
Working with SQL Server as the Back End
807(13)
SQL Server Management Studio
807(7)
SQL Server Objects
814(3)
Troubleshooting
817(3)
Summary
820(3)
Index 823
Teresa Hennig, an Access MVP and business owner of 15 years, creates innovative and effective Access solutions for her clients. She is the president of two Access User Groups, the author of six books on Access, and an acclaimed presenter and trainer.

Ben Clothier, an Access MVP since 2009, is an Access and SQL Server expert at the forefront of Access web apps. Ben is an administrator at UtterAccess.

George Hepworth, an Access MVP, is an Access/SQL Server developer and consultant. He has written numerous books on Access and Access web apps, and is an administrator on UtterAccess.

Dagi Yudovich, an Access MVP, develops Access SQL Server solutions to support BI needs. He is an administrator on UtterAccess.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
Daugiau apie elektronines knygas Daugiau apie elektronines knygas
Pastovi nuoroda: https://www.kriso.lt/db/97811185308252e.html
Raktažodžiai: