Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Like the other programs in Microsoft Office 2013, Access offers some brand new templates to choose from. Not just for creating databases, but for creating web apps as well. Let's take a look. When you launch Access 2013, of course you're brought to this new start screen, which does display a number of templates for you, including the default which is a Custom web app. Whenever you see this logo in the background, the globe logo, you know you're going to be creating one that is web enabled. So as we go through this list, the default list, you can see some of them like Issue tracking, Contacts, they all have that globe in the background.
Sometimes you'll see a similar icon, but it'll say Desktop asset tracking, for example, as opposed to Asset tracking, which we see above with the globe symbol. So there are desktop versions of these apps that you can create, so you don't need to be connected to SharePoint for example. So all of these are fairly new, but if you're not seeing what you're looking for, notice there are some suggested searches. You can search for Assets, Business, Contacts, Employee, etcetera or you can type in your own as well. Let's type in Costumer for example.
When you hit Enter you'll notice it's searching through thousands of online templates and you're going to come up with a list. Some will look familiar, some of the old templates had access to in previous versions. The newer ones will have this new look, including the web apps and the desktop versions. You'll also have categories over on the right-hand side, so you can filter it out. If you're only interested in business ones, you can give that a click, and you can see it's whittled down now. You can also whittle it further down by choosing something like small business.
Now you can see we're down to an even smaller list and those two remain highlighted, and if we don't want to include them any longer, just click the Close button that appears next to them. So once you've found what you're looking for and let's go to Desktop contacts and give it a click. It's going to launch and prompt you for some information. In this case we're going to type in the name of our brand new database. So let's call it, NoObstaclesCustomerDatabase.
And you can choose the location. You'll see the default location right below, but click the folder icon if you want to change that and then click Create. It's going to prepare the template for you. Open it up and you may have to enable what I'm seeing here, the Getting Started screen. In the background you might see a Security Warning and if you wanted to you can watch videos to help you get started. Now there's Video Training, Browse Experts, lot of help here, we'll close this up and again, you might see the Security Warning that there is content that's been disabled.
You can Enable that Content to give you full access. This may reappear, we'll close it up and we're now ready to start working on our new Contact List. Of course, we're taken directly to the datasheet view, we could start inputting records using the defaults, but at any time with these templates they are really meant to get you started. You can go into Design view and start working on the design, changing the Titles, changing any of the components you see here. For example, maybe you don't use the Category field, we can remove that just by clicking and dragging from the right to the left or the left to the right, it doesn't matter, once we've highlighted those objects, hit your Delete key on the keyboard.
Everything is closed up nicely, let's return to Datasheet view now, and we could continue working with our new database, based on the template that we chose, from many, many more new templates in Access 2013.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 81438 Viewers
80 Video lessons · 133293 Viewers
52 Video lessons · 66651 Viewers
59 Video lessons · 52476 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.