1 / 19

What’s New in Access 2013

What’s New in Access 2013. by Lisa Friedrichsen. Johnson County Community College, Overland Park KS. lisalfri@jccc.edu. Microsoft® Access 2013: Illustrated Series. New Perspectives : Portfolio Projects for Business Analysis. I am such a good teacher that…. …I taught my dogs how to talk!.

ray
Download Presentation

What’s New in Access 2013

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. What’s New in Access 2013 by Lisa Friedrichsen Johnson County Community College, Overland Park KS lisalfri@jccc.edu Microsoft® Access 2013: Illustrated Series New Perspectives: Portfolio Projects for Business Analysis

  2. I am such a good teacher that… …I taught my dogs how to talk!

  3. …yes, I taught them how to talk. I didn’t say they learned how to talk!

  4. To keep in touch … • www.wikispaces.com • You must set up an account • Two choices to participate… • Find it yourself: CourseConference • Be invited by sending an email to lisalfri@jccc.edu

  5. What’s New for Access 2013? • Text data type = Short Text • Memo data type = Long Text • No PivotTable, PivotChart views • No Outlook integration • Create Email • Manage Replies • No replication DESKTOP (traditional) databases

  6. Let’s do it! • Desktop demo • New Access 2013 “desktop” (traditional) features Northwind2007.accdb Northwind.accdb (the old .mdb file)

  7. New! Access 2013 Web Apps! • What is an Access Web app? • created in Access 2013 or SharePoint 2013 • deployed to SharePoint 2013 • available to users via a common browser

  8. To create an Access Web app… • Start Access 2013 • Choose Custom web app or • Choose nonDesktop (Desktop = traditional) template or • Create an Access Web app from within SharePoint 2013

  9. A desktop database is not… • …an Access Web app • There is no easy way to convert an existing desktop database to an Access Web app

  10. An Access Web app is not... • …an Excel or Word Office app • Insert tab, Apps for Office

  11. An (Access) Web app is…. • A fully functional database application • Tables • Queries • Forms • Reports • Macros (recall Macros in 2010 were improved) • (not modules, no VBA) (I wish they would have called it aWeb database)

  12. An (Access) Web app requires…. • SharePoint Server 2013 • SQL Server 2012 • Configure Access Services SharePoint 2013 – Access Services

  13. (Access) Web app progression… • Access 2007, 2010 had the ability to share tables, forms through SharePoint, .accdb • Access 2013 web app file =.accdw (uses SQL Server 2012 for tables) • Complete Web-deployable database / application • Hybrid databases still have .accdb extension • “desktop” vs. “web” icons in database file

  14. Free trial Access hosting site…. www.accesshosting.com

  15. Free trial site…. www.accesshosting.com

  16. Let’s do it! • (Access) Web app demo • Use an Web app with a browser • 3 to choose from • Create a Web app • File|New in Access 2013 • Deploy an Web app • Need a SharePoint account • You may use my account at www.AccessHosting.com

  17. To use a Web app go to… lisalfri.accessontheweb.com ~ Colleagues (upper left) (created by SharePoint 2013) lisalfri.accessontheweb.com/northwind traders (created by Access 2010 template) lisalfri.accessontheweb.com ~ Assets (upper left) (created by Access 2013) UserName: SPH\lisalfri Password: Acce$$45

  18. To create a Web app… • File|New in Access 2013 • Features to Watch for… • Views (known as “forms”) • List • Datasheet • The Tile Pane • Add, Delete, Edit, Save records (Action bar) • Customizing a “view” • Related Items control • AutoComplete control

  19. Thank you! Lisa Friedrichsen lisalfri@jccc.edu

More Related