Muutke küpsiste eelistusi

E-raamat: Extend Microsoft Access Applications to the Cloud

3.33/5 (4 hinnangut Goodreads-ist)
  • Formaat: 432 pages
  • Ilmumisaeg: 22-Jan-2015
  • Kirjastus: Microsoft Press,U.S.
  • Keel: eng
  • ISBN-13: 9780133966237
Teised raamatud teemal:
  • Formaat - EPUB+DRM
  • Hind: 17,54 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Extend Microsoft Access Applications to the CloudSuurem pilt
  • Formaat: 432 pages
  • Ilmumisaeg: 22-Jan-2015
  • Kirjastus: Microsoft Press,U.S.
  • Keel: eng
  • ISBN-13: 9780133966237
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Build new Access cloud web apps and migrate desktop databases to the cloud

This is your complete, practical guide to creating Microsoft Access web apps and migrating existing databases to the cloud. Access MVP Andrew Couch guides you through the entire web app life cycle, from design through deployment and upgrades. After introducing Microsoft Office 365 and the web app development environment, he reviews key issues associated with moving data into a web app or creating cloud apps with new data. Next, he drills down into app construction, from table design to integration. Youll learn how to extend Access with Microsoft Azure SQL, PowerPivot, Visual Studio 2013, SQL Server Reporting Services (SSRS), and Apps for Office, and master important new enhancements in Office 365 SP1.

Learn best practices and techniques to:



Capitalize on key Office 365 features in your Access web apps Design and integrate all the features of Access web apps Make your desktop databases compatible with web app table structures Implement and test business rules by using the Macro Programming Tools Understand how your app design translates to objects in the cloud-based Azure SQL Database Use Microsoft SQL Server Management Studio (SSMS) to connect with and manage web apps Improve reporting with PowerPivot, Visual Studio 2013, and SSRS Extend Access web apps with Apps for Office features Capitalize on Office 365 SP1 improvements in change deployment, intellectual property protection, and integration



Get all code samples, including complete apps, at: http://aka.ms/AccessApps/files

About This Book



For experienced Access developers who want a deep understanding of web app design and implementation For new web app developers who want to develop Access web apps with Office 365
Introduction i
Chapter 1 Finding your way around Office 365
1(56)
Office 365 subscriptions
2(3)
Office products in a browser
5(1)
Getting started with Office 365
5(2)
Team site, personal site, and public site
7(3)
Installing Office Professional
10(3)
OneDrive and OneDrive For Business 2013
13(6)
Creating a web app using a template
19(4)
Opening a web app with Access
23(1)
Saving a web app as a package
24(2)
Uploading a web app package
26(4)
Editing a web app package
30(2)
Displaying a web app in a browser
32(1)
Sharing a web app with external users
32(4)
Creating sites and subsites
36(3)
Creating site collections (Enterprise subscription)
39(6)
Applying a theme
45(2)
Document storage and libraries
47(4)
Microsoft Azure SQL Database, Office 365, and Access
51(2)
App Catalog
53(2)
Summary
55(2)
Chapter 2 Finding your way around Access 2013
57(42)
A new way of building applications
57(4)
Create a custom web app
61(1)
Importing data from Access
62(2)
Using the navigation pane
64(1)
Working with tables, lookups, and relationships
65(3)
Displaying data in a browser
68(3)
Working with different views
71(2)
Controls available in a view
73(7)
Autocomplete control
74(1)
Related items control
75(1)
Subview control
76(1)
Action bar
77(1)
List control
77(1)
Hyperlink control
78(1)
Multiline Text Box control
79(1)
Web Browser control
79(1)
Overview of macro programming and data macros
80(2)
Upgrading and deploying a web app
82(14)
Side-loading a web app
96(1)
Designing and commissioning with existing data
96(2)
Summary
98(1)
Chapter 3 Converting a desktop database to a web app
99(34)
Tables and primary key fields
99(3)
Relationships and lookups
102(6)
Table and field properties
108(4)
Boolean data
112(1)
Value-based lookups
112(1)
Multi-value data
113(1)
Importing different data types
113(3)
Long Text (memo data)
115(1)
Calculated fields
115(1)
Image data type
115(1)
Attachments and OLE objects
115(1)
Reporting
116(5)
References
119(1)
Quick conversion to external writer
120(1)
Attachment and OLE data
121(11)
Uploading multiple files
122(1)
Extracting attachment files
123(2)
Uploading image files
125(7)
Summary
132(1)
Chapter 4 Creating a blank web app and using templates
133(16)
Creating a blank web app
133(1)
Adding template tables
134(2)
Creating a new table
136(1)
Editing the design of a table
137(2)
Creating lookups and relationships
139(3)
Adding indexing
142(1)
Adding validation rules
143(2)
Adding calculated fields
145(1)
Summary
146(3)
Chapter 5 Displaying data in views
149(46)
Customizing the table selector
150(1)
Customizing the view selector
151(1)
Creating a pop-up window interface
152(4)
Datasheet view
156(8)
Views and record sources
164(3)
Duplicating views
167(2)
List Details view
169(4)
Summary view
173(4)
Standalone view
177(3)
Related items control
180(2)
Subview control
182(4)
View controls
186(1)
Combo box control
187(1)
Combo box synchronization
188(2)
Autocomplete control
190(1)
Web browser control
191(1)
Adding color to controls
192(1)
Summary
193(2)
Chapter 6 Creating data sources by using queries
195(20)
Creating basic queries
196(2)
Adding criteria to queries
198(2)
Adding calculations to queries
200(2)
Adding parameters to queries
202(6)
Totals and queries
208(1)
Top value queries
209(3)
Unique values in queries
212(2)
Summary
214(1)
Chapter 7 Programming a web app by using macros
215(74)
Macro-programming capabilities
216(3)
Macro editor and standalone user-interface macros
219(3)
User-interface events for views and controls
222(5)
User-interface macros
227(1)
Named data macros and stored procedures
228(11)
Data macros and triggers
239(8)
Data macro tracing
247(2)
On Start macro
249(1)
Transactions and recursion
250(3)
Indirect recursion
250(1)
Direct recursion
251(2)
Presenting a view for printing
253(9)
Creating a cross-tabulation of data
262(5)
Side-loading a web app
267(7)
On Deploy Macro
274(13)
Using an alias with a macro action
287(1)
Summary
288(1)
Chapter 8 Managing security and a public-facing web app
289(12)
Creating a public website
289(2)
Creating a public-facing web app in Office 365
291(1)
Managing security in a public web app
292(8)
Summary
300(1)
Chapter 9 Looking under the hood at Microsoft Azure SQL Database
301(38)
SQL Server Management Studio
302(1)
ODBC drivers
303(1)
Connecting to Microsoft Azure SQL Database
303(5)
Schemas
308(1)
Security in SSMS
309(1)
Linked Microsoft SharePoint lists
309(1)
Manually creating an ODBC DSN connection
310(7)
Linking from the desktop to use an ODBC connection
317(2)
Creating DSN-less connections with program code
319(2)
Extracting information on relationships
321(9)
Displaying structural information using data access objects
323(4)
Displaying structural information using ADOX
327(3)
Displaying structural information with a query
330(1)
Validation rules
330(1)
Data macros under the hood
331(5)
Views and table-valued functions
336(2)
Summary
338(1)
Chapter 10 Other techniques for reporting
339(36)
Excel and data connections
339(5)
Excel PowerPivot
344(7)
Creating a report for SQL Server Reporting Services
351(9)
Publishing a report to SSRS
360(3)
Linking a web app to an SSRS report
363(1)
Using Visual Studio 2013 with a web app
364(10)
Summary
374(1)
Chapter 11 Using apps for Office with Access
375(12)
Apps for Access concepts
375(2)
Consuming apps for Access
377(4)
Developing apps for Access
381(5)
Summary
386(1)
Index 387
Andrew Couch has worked with Access since 1992 as a developer, trainer, and consultant. A founder of the UK Access User Group, he has been a Microsoft Access MVP for the past seven years. His Microsoft Press books include Microsoft Access 2013 Plain & Simple and Microsoft Access 2010 VBA Programming Inside Out. He also writes technical articles about Access at www.upsizing.co.uk/TechLibrary.aspx.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97801339662376e.html
Märksõnad: