Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
Discover what's new in the latest version of Microsoft Office, from Word 2013 to OneNote 2013. In this course, David Rivers reviews the suite-wide enhancements to Office, like cloud integration, Touch Mode for interacting with touch-enabled devices, and Ribbon customization, as well as individual app improvements added to the new Office. Take a look at PDF editing in Word, flash fill and quick analysis in Excel, the new Presenter view in PowerPoint, new templates in Access, social media integration with Outlook, and much more.
If you've installed Office 2013 Professional or Professional Plus, you'll have access to Microsoft Access 2013. If you're using the Home & Student or Home & Business versions, you won't have access, but you can get it with the cloud Editions. Every single cloud editions of Office 365 include Microsoft Access. We're going to take a look at it now. There's not a whole lot new that's going on with Access, but when we launch it, we will see that first new option that we're used to seeing with all of the programs in the Office Suite, and this is this welcome or start screen.
Here on the left-hand side, you will see Recent documents you've worked on. You'll also have Access to Open your files from here and you'll see a list of Templates, which we'll talk about in the next lesson. Also in the top right-hand corner, you'll see your Current Login information if you are logged in to your Microsoft Account and at the top you'll see the Help option, as well as your Minimize, Maximize and Closed buttons for closing this up when you're done. Now, all we're going to do to get started is start a Blank desktop database.
One of the things you'll notice with the templates here is that, the default is now a Custom web app. So Access continues to move in the direction of a web development application as opposed to a database application, but we're going to click the next option, which is Blank desktop database, we'll give it a name, let's call it, No Obstacles Customer and click Create and this takes us to a brand New Blank database ready to start adding records.
We have all of the ribbon that you're used to seeing across the top. We have the File tab going back here. This does look a little bit different from previous versions. You'll see Info at the top. You'll also see the new option, which gets us back to those templates. Here's where we go to Open, Save, Save As, Print and if we wanted to close any files we're working on, in this case our brand new customer database, we could close it from here. We have access to our Account options and other options from this Start screen as well. Let's just go back.
Also on the ribbon you'll see your Home tabs, Create External Data. Over here in the right-hand side under Table tools you'll notice this Field and Table highlighted because that's what we're doing. We're starting to create brand new fields in our first table here in our New blank project. Across the bottom, you'll see your navigation buttons for moving through the various records once you start to add them, and there's our View buttons down on the bottom right-hand corner. Currently selected you'll see the data sheet view, if we want to go to Design view, we can click there, we'll have to give our table a name if we want to do that, so let's click Cancel and remain in data sheet view.
Again, we have this new flat look, so we don't see the buttons on the ribbon for example, with that 3D effect. All of the tabs and the ribbons, all flat against the background, two-dimensional our Quick Access toolbar in the top left corner as well. Now, when we're done, we just simply click the Close button. We haven't actually done anything, there's nothing to Save and it will take usback to our old desktop environment Access runs. So in the next lesson we'll take a look at some of the new templates you have available to you here in Access 2013.
There are currently no FAQs about Office 2013 New Features.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.