microsoft office ® access 2007 microsoft office access 2007: introduzione allo sviluppo fabio...
TRANSCRIPT
![Page 1: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/1.jpg)
![Page 2: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/2.jpg)
Microsoft OfficeMicrosoft Office®® Access Access 20072007Microsoft Office Access 2007: Microsoft Office Access 2007: Introduzione allo sviluppoIntroduzione allo sviluppo
Fabio Santini.NET Developer EvangelistMicrosoft Italy
![Page 3: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/3.jpg)
Introducing Access 2007Introducing Access 2007Allows end users to easily track information, quickly build business applications, and collaborate via Windows SharePoint Services (WSS)Gives professional developers and IT extensible and manageable business applications that combine the best of the client and server
End UsersPower Users
Pro Developers / IT
Much easier to useOut-of-the-box applicationsEasy to add a field, form, or report
WSS for collaborationWYSIWYG authoringfor forms and reports“Codeless” macrosData collection e-mails
Whole new class of applications integrated with WSSRich and reach interfacesServer-side manageabilityUtilize managed codeConfident upgrade path
![Page 4: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/4.jpg)
New Scenarios EnabledNew Scenarios Enabled
Build solutions more easilyEnd users can track and report on their dataFar less code needed
Build better solutionsModern, beautiful applicationsSolutions can utilize screen real estate
Build new WSS collaboration solutions
Solutions with Rich and Reach user interfacesOffline applications
![Page 5: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/5.jpg)
A Rich Client SolutionA Rich Client Solution
Fabio Santini.NET Developer EvangelistMicrosoft Italy
![Page 6: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/6.jpg)
Making Browse Time Making Browse Time RicherRicher
ShellExternal DataFormsReportsDatasheetsNavigation ButtonsExtensibility
Non-modal Security Warnings
New Look
Ribbon
Tabbed Document Mode (SDI)
Navigation Pane
Encrypt with Database Password
![Page 7: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/7.jpg)
Making Browse Time Making Browse Time RicherRicher
ShellExternal DataFormsReportsDatasheetsNavigation ButtonsExtensibility
Data Collection E-mails
Offline SharePoint Lists
Windows SharePoint Services v3
Save as PDF
Save as XPS
Saved Import/Export Specifications
Save as Outlook Contacts
Add from Outlook
![Page 8: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/8.jpg)
Making Browse Time Making Browse Time RicherRicher
ShellExternal DataFormsReportsDatasheetsNavigation ButtonsExtensibility
Filtering and Sorting Menus
Attachments
Multi-valued Fields
Column History
Rich Text
Alternating Row Color
Hyperlink Expressions
Transparent Images
Bound Image Control
Hyperlink Style Buttons
Gridlines
![Page 9: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/9.jpg)
Making Browse Time Making Browse Time RicherRicher
ShellExternal DataFormsReportsDatasheetsNavigation ButtonsExtensibility
Split Forms
Auto-Resize via Control Anchoring
Edit List Items Command for Combo Boxes and List Boxes
![Page 10: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/10.jpg)
Making Browse Time Making Browse Time RicherRicher
ShellExternal DataFormsReportsDatasheetsNavigation ButtonsExtensibility
Report View (like Form View)
Ad Hoc Filtering
Ability to Copy data
Find (Ctrl + F)
Events (e.g. OnClick, GotFocus…)
![Page 11: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/11.jpg)
Making Browse Time Making Browse Time RicherRicher
ShellExternal DataFormsReportsDatasheetsNavigation ButtonsExtensibility
New Look
Better Accessibility
Sort and Filter Dropdowns
Edit List Items Command for Combo Boxes
![Page 12: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/12.jpg)
Making Browse Time Making Browse Time RicherRicher
ShellExternal DataFormsReportsDatasheetsNavigation ButtonsExtensibility
New Look
Search Box
Navigation Caption
Toggle Filter
![Page 13: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/13.jpg)
Making Browse Time Making Browse Time RicherRicher
ShellExternal DataFormsReportsDatasheetsNavigation ButtonsExtensibility
Ribbon Extensibility
Managed Add-in Support
Custom Task Panes Support
Trusted Locations
Disabled Mode
Macro Support in Disabled Mode
More Macro Actions
Macro Error Handling
![Page 14: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/14.jpg)
Application Building Made Application Building Made EasyEasy
Fabio Santini.NET Developer EvangelistMicrosoft Italy
![Page 15: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/15.jpg)
Making Design Time Making Design Time EasierEasier
ShellExternal DataSchemaForms and ReportsMacrosProgrammabilityDeployment
Getting Started
Database Templates
The Ribbon
Tabbed Document Mode (SDI)
Navigation Pane
Save Database as…
Office Center for Options
![Page 16: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/16.jpg)
Making Design Time Making Design Time EasierEasier
ShellExternal DataSchemaForms and ReportsMacrosProgrammabilityDeployment
External Data Ribbon
Move to SharePoint Site
SharePoint Offline
SharePoint Site Manager for WSS linked tables
Field Import Specs for Excel
Updated Import/Export Wizards
![Page 17: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/17.jpg)
Making Design Time Making Design Time EasierEasier
ShellExternal DataSchemaForms and ReportsMacrosProgrammabilityDeployment
Database Templates
Table Templates
Field Templates
Table Design Ribbon
Schema by Datasheet
Paste from Excel into New Table
Attachments
Multi-valued fields
Column History for Memos
Editable Value Lists
![Page 18: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/18.jpg)
Making Design Time Making Design Time EasierEasier
ShellExternal DataSchemaForms and ReportsMacrosProgrammabilityDeployment
Layout View
Ribbons: Layout, Design…
Quick Create Forms and Reports
Tabular and Stacked Layouts
Gridlines and Padding
Control Anchoring
Data Source task pane
Property Sheet task pane
Sorting, Grouping, and Totals pane
Embedded Macros
![Page 19: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/19.jpg)
Making Design Time Making Design Time EasierEasier
ShellExternal DataSchemaForms and ReportsMacrosProgrammabilityDeployment
Embedded Macros
Support for Variables
Error Handling
Arguments Column
Macro Design Ribbon
More Macro Actions
Warning for Actions not allowed in Disabled Mode
Hide/Show Actions not allowed in Disabled Mode
Help for RunCommands
![Page 20: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/20.jpg)
Making Design Time Making Design Time EasierEasier
ShellExternal DataSchemaForms and ReportsMacrosProgrammabilityDeployment
Scroll-wheel support in the VBE!!!
Better Macros
TempVars for Globals
Managed Add-in Support
Improved Managed Code Support
No need to cast everything
Managed Code can listen to Access events
![Page 21: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/21.jpg)
Making Design Time Making Design Time EasierEasier
ShellExternal DataSchemaForms and ReportsMacrosProgrammabilityDeployment
Trusted Locations
SharePoint Site for Front-end Deployment
Publish to SharePoint Site
Runtime-Only File Type (ACCDR)
Package as CAB & Sign (ACCDC)
![Page 22: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/22.jpg)
Using Managed CodeUsing Managed Code
Fabio Santini.NET Developer EvangelistMicrosoft Italy
![Page 23: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/23.jpg)
Template ExtensibilityTemplate Extensibility
Templates (ACCDTs) use the Open Packaging Conventions
You can build your own templates
The Access Developer Extensions will add “Save as Template…” support
![Page 24: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/24.jpg)
Key TakeawaysKey Takeaways
Microsoft is committed to making Access easy for end users and developers
Microsoft is committed to Access as a platform
SharePoint Services integration enables new types of collaborative applications
![Page 25: Microsoft Office ® Access 2007 Microsoft Office Access 2007: Introduzione allo sviluppo Fabio Santini.NET Developer Evangelist Microsoft Italy](https://reader031.vdocuments.us/reader031/viewer/2022032702/56649ced5503460f949baf4a/html5/thumbnails/25.jpg)
© 2006 Microsoft Corporation. All rights reserved.This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.