Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74761 Viewers
80 Video lessons · 129849 Viewers
52 Video lessons · 64052 Viewers
59 Video lessons · 49843 Viewers
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.
Your file was successfully uploaded.