Get a FREE Microsoft Access 2019 Introductory Course here ►https://theskillstream.com/access-2019-intro-course
In this video, you will discover the new main features of Access 2013. Learn new features like the several templates on the start screen. Some of which are the table templates, external data wherein you can import data from external sources.
To add to these are the new features which involve primarily with web apps like opening a browser, UI created automatically including the navigation needed to get through records in the database, new action bar which is a standard set of buttons for adding, editing, saving and deleting data.
Get the full beginning and advanced courses for Microsoft Access 2013 here: hhttps://www.simonsezit.com/course-category/access/
Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel -)
Hello and welcome back to our course on Access 2013. In this section we’re going to create a first database. But as part of doing this, rather than concentrating on what’s in the database, I’m going to talk to you about the Access 2013 workspace. Let’s start with the Access 2013 start screen.
In the top right hand corner of this screen you can see the conventional Windows buttons for Close which will close Access 2013, maximize to maximize the window in the available space, and minimize. To the left you have a little question mark icon and the question mark icon is the one that’s used to access Help. We’ll be looking at Help later on in the course.
Below that we have the details of the current user or, to be more precise, the current account that Access is running in. Now the significance of an account in Office 2013 in general and Access 2013 in particular I will also be talking to you about later on, but you’re going to need to have an account if you want to be able to use web apps. That gives you access to Microsoft SharePoint. But as I say, more of that later.
On the right hand part of the workspace when you’re in the start screen, these individual tiles represent templates. You can think of templates as sort of half built databases, sample databases, databases you can start from. So if you like, if you were going to build your own house, maybe here somebody’s given you some plans, done the walls and windows for you and left you to do the rest, that sort of thing. And we’ll look at templates in a lot of detail later on. If I wanted to create a new database, I might choose one of these templates. One of the templates I can use is this one, Blank desktop database. That gives me a blank desktop database that is a blank database nothing in it. I can start completely from scratch. If I want a database that I’m going to run as a web app, then the equivalent for that is Custom web app. If I want to start my own web app I’m going to start there.
Now as I mentioned earlier on in the course, in the initial stages I’m really going to concentrate on desktop databases but I will do a little web app demo in a while just to show you some of the key differences and we will be coming back to web apps in more detail later on.
Now in its most straightforward form, an Access database is a file. And as with any other component of Office 2013, you usually have the option: Do I want a new file? In this case, a new database. Do I want to open an existing file? That’s what this option on the left does open other files. If you want to browse to find another database, you can click on Open other files. But Access 2013 also keeps track of databases you’ve opened recently. So you also have a list of recent, recently opened databases.
Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters. Get 10+ MS Access courses at Simon Sez IT here ️ https://www.simonsezit.com/course-category/access/