Cargando…
Microsoft Access 2013 inside out /
Build an Access Services web app with Microsoft SharePoint Server; automate your Access web app with data macros; create tables in your Access web app using built-in templates; aggregate and display your web app data using totals queries; use the Autocomplete control to quickly search for related da...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Redmond, Wash. :
Microsoft Press,
©2013.
©2013 |
| Colección: | Inside out (Redmond, Wash.)
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | OR_ocn862826949 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 131112s2013 waua o 001 0 eng d | ||
| 040 | |a UMI |b eng |e pn |c UMI |d OCLCA |d DEBBG |d DEBSZ |d N$T |d TEFOD |d YDXCP |d NLE |d OCLCF |d OCLCQ |d B24X7 |d K6U |d COO |d OTZ |d AUD |d OCL |d OCLCQ |d EBLCP |d LIV |d OCLCQ |d OCLCO |d HCO |d CEF |d OCLCQ |d OCLCO |d UAB |d AU@ |d OCLCA |d OCLCQ |d BRF |d OCLCO |d OCLCQ | ||
| 019 | |a 854666830 |a 859879521 | ||
| 020 | |a 0735671230 | ||
| 020 | |a 9780735671232 | ||
| 020 | |a 9780735672307 |q (electronic bk.) | ||
| 020 | |a 073567230X |q (electronic bk.) | ||
| 020 | |a 9780735672314 |q (electronic bk.) | ||
| 020 | |a 0735672318 |q (electronic bk.) | ||
| 020 | |z 9780735671232 | ||
| 029 | 1 | |a AU@ |b 000051840555 | |
| 029 | 1 | |a AU@ |b 000052281158 | |
| 029 | 1 | |a DEBBG |b BV041776424 | |
| 029 | 1 | |a DEBSZ |b 404318630 | |
| 029 | 1 | |a NLGGC |b 36363083X | |
| 029 | 1 | |a NZ1 |b 15222219 | |
| 035 | |a (OCoLC)862826949 |z (OCoLC)854666830 |z (OCoLC)859879521 | ||
| 037 | |a CL0500000335 |b Safari Books Online | ||
| 050 | 4 | |a QA76.9.D3 |b C66 2013 | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.75/65 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Conrad, Jeff. | |
| 245 | 1 | 0 | |a Microsoft Access 2013 inside out / |c Jeff Conrad. |
| 260 | |a Redmond, Wash. : |b Microsoft Press, |c ©2013. | ||
| 264 | 4 | |c ©2013 | |
| 300 | |a 1 online resource (1 volume) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 1 | |a Inside out | |
| 588 | 0 | |a Online resource; title from title page (Safari, viewed October 31, 2013). | |
| 500 | |a Includes index. | ||
| 520 | |a Build an Access Services web app with Microsoft SharePoint Server; automate your Access web app with data macros; create tables in your Access web app using built-in templates; aggregate and display your web app data using totals queries; use the Autocomplete control to quickly search for related data; create a Summary view to consolidate and group information; display related data on your views with the Related Items control; package your web app for use by others in your organization; plus download chapters on building desktop databases. For intermediate and advanced users and database designers. -- |c Edited summary from book. | ||
| 505 | 0 | |a Intro -- Contents at a glance -- Table of contents -- Introduction -- Part 1: Working with Access Services web apps -- Chapter 1: What is Access? -- What is a database? -- Relational databases -- The architecture of Access -- Database capabilities -- Access as an RDBMS -- Data definition and storage -- Data manipulation -- Data control -- Access as an application development system -- Deciding to move to database software -- Extending the power of Access to the web -- Chapter 2: Exploring the Access 2013 web app interface -- Working with web apps -- Opening Access for the first time -- Getting started with Access 2013 -- Opening a web app template -- Exploring the Microsoft Office Backstage view -- Taking Advantage of the Quick Access Toolbar -- Understanding the Office Fluent ribbon -- Working with the Navigation pane -- Searching for web app objects -- Working in the web app design environment -- Add Tables screen -- Table Selector -- App Home View -- View Selector -- View preview window -- Viewing your web app in a web browser -- Saving a web app as an app package -- Installing app packages -- Uploading an app package to a SharePoint corporate catalog -- Installing app packages from a SharePoint corporate catalog -- Installing apps from the SharePoint Store -- Installing apps directly into a SharePoint site -- Creating a blank Access web app -- Downloading a web app into Access -- Chapter 3: Designing tables in a web app -- Creating a new blank web app -- Creating tables using table templates -- Starting with a blank table -- Defining fields in web apps -- Understanding field data types in web apps -- Setting field properties -- Completing the fields in the Vendors table -- Creating calculated fields -- Defining field validation rules for web apps -- Defining a table validation rule for web apps -- Defining a primary key for web apps. | |
| 505 | 8 | |a Adding indexes -- Single-field indexes -- Multiple-field indexes -- Creating value list lookup fields in web apps -- Working with data in preview datasheets -- Creating relationships using lookup fields -- Defining a restrict delete relationship -- Defining a cascade delete relationship -- Importing and linking data into web apps -- Considerations for importing lookups -- Importing Access desktop database tables -- Importing a spreadsheet -- Importing SQL tables -- Importing a text file -- Importing a list from a SharePoint site -- Linking a SharePoint list into a web app -- Chapter 4: Creating data macros in web apps -- Uses of data macros -- Touring the Logic Designer -- Working with table events -- Using On Insert events -- Using On Update events -- Using On Delete events -- Deleting table events -- Working with named data macros -- Creating named data macros -- Using parameters -- Saving named data macros -- Calling named data macros -- Renaming and deleting named data macros -- Working with return variables -- Studying other named data macros -- Debugging data macros with the Trace table -- Understanding recursion in data macros -- Sharing data macro logic -- Chapter 5: Working with queries in web apps -- Selecting data from a single table -- Specifying fields -- Viewing query results -- Entering selection criteria -- Using expressions -- Using the Expression Builder -- Sorting data -- Working in query preview Datasheet view -- Moving around and using keyboard shortcuts -- Changing data -- Sorting data -- Filtering Data -- Selecting data from multiple tables -- Creating inner joins -- Creating outer joins -- Summarizing information with totals queries -- Totals within groups -- Selecting records to form groups -- Building a query on a query -- Using query parameters -- Selecting specific groups -- Working with unique values. | |
| 505 | 8 | |a Using the Top Values query property -- Chapter 6: Working with views and the web browser experience -- Uses of views -- Understanding the App Home View -- Working with the Table Selector -- Working with the View Selector -- Starting with quick-created views -- Working within the web design surface -- Exploring Action Bar buttons -- Defining view properties -- Sizing and moving controls -- Defining control properties -- Understanding related items controls -- Customizing Datasheet views -- Working with views in a web browser -- Navigating to records using the List Control -- Filtering in views -- Understanding view and edit mode -- Using special controls for data entry -- Using Datasheet views -- Chapter 7: Advanced view design -- Creating Summary views -- Creating Blank views -- Defining subviews -- Using web browser controls -- Creating stand-alone views -- Understanding name fixup -- Adding fields -- Renaming fields -- Renaming objects -- Deleting objects -- Applying themes to web app views -- Exploring sample views in the BOSS app -- Extending your web app with desktop database reports -- Managing external connections -- Setting SharePoint site permissions -- Chapter 8: Automating a web app using macros -- The macro design surface-an overview -- Working with the Logic Designer -- Saving your macro -- Working with view and control events -- Defining macros for view events -- Defining macros for control events -- Controlling record navigation with macros -- Creating an On Start macro -- Opening views with OpenPopup actions -- Using Where clause syntax -- Referencing other view control values -- Passing parameters to views -- Exploring the audit invoices macros -- Using the SetProperty action with view controls -- Calling named data macros and using return variables -- Navigating to different views using ChangeView actions. | |
| 505 | 8 | |a Exploring other named data macro parameter examples -- Part 2: Creating tables in a desktop database -- Chapter 9: Exploring the Access 2013 desktop database interface -- Getting started with desktop databases -- Opening an existing desktop database -- Exploring the Microsoft Office Backstage view -- Modifying global settings via the Access Options dialog box -- Taking advantage of the Quick Access Toolbar -- Understanding content security -- Enabling a database that is not trusted -- Understanding the Trust Center -- Enabling content by defining trusted locations -- Understanding the Office Fluent Ribbon -- Home tab -- Create tab -- External Data tab -- Database Tools tab -- Understanding the Navigation pane -- Exploring Navigation pane object views -- Working with custom categories and groups -- Exploring the Navigation Options dialog box -- Sorting and selecting views in the Navigation pane -- Searching for database objects -- Using the single-document vs. the multiple-document interface -- Chapter 10: Designing tables in a desktop database -- Creating a new desktop database -- Using a database template to create a desktop database -- Creating a new empty database -- Creating your first simple table by entering data -- Creating a table using Application Parts -- Creating a table using Data Type Parts -- Creating a table in Design view -- Defining fields -- Understanding field data types -- Setting field properties -- Completing the fields in the Companies table -- Defining simple field validation rules -- Defining input masks -- Defining a primary key -- Defining a table validation rule -- Understanding other table properties -- Defining relationships -- Defining your first relationship -- Creating a relationship on multiple fields -- Adding indexes -- Single-field indexes -- Multiple-field indexes -- Setting table design options. | |
| 505 | 8 | |a Database limitations -- Chapter 11: Modifying your table design -- Before You Get Started -- Deleting tables -- Renaming tables -- Changing field names -- Moving fields -- Inserting fields -- Copying fields -- Deleting fields -- Changing data attributes -- Changing data types -- Changing data lengths -- Dealing with conversion errors -- Changing other field properties -- Reversing changes -- Taking a look at Lookup properties -- Working with Multi-Value Lookup Fields -- Compacting your database -- Appendix: Installing your software -- Installing the Office system -- Choosing options when you have no previous version of the Office system -- Choosing options to upgrade a previous version of the Office system -- Converting from a previous version of Access -- Conversion issues -- Installing the Office 64-bit version -- Installing the sample files -- Index. | |
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Microsoft Access. |
| 630 | 0 | 7 | |a Microsoft Access. |2 blmlsh |
| 630 | 0 | 7 | |a Microsoft Access. |2 fast |0 (OCoLC)fst01371910 |
| 650 | 0 | |a Database management. | |
| 650 | 0 | |a Relational databases. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 7 | |a COMPUTERS |x Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a Relational databases |2 fast |0 (OCoLC)fst01093575 | |
| 650 | 7 | |a Database management. |2 fast |0 (OCoLC)fst00888037 | |
| 776 | 0 | |c Paperback |z 9780735671232 | |
| 830 | 0 | |a Inside out (Redmond, Wash.) | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9780735672291/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Books 24x7 |b B247 |n bks00102550 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL4642675 | ||
| 938 | |a EBSCOhost |b EBSC |n 610613 | ||
| 938 | |a YBP Library Services |b YANK |n 10867949 | ||
| 994 | |a 92 |b IZTAP | ||