Get a FREE Microsoft Access 2019 Introductory Course here ►https://theskillstream.com/access-2019-intro-course

Get the complete 9-hour Access 2016 training course here ► https://www.simonsezit.com/courses/microsoft/learn-microsoft-access-2016-training-tutorials/

Get the complete 8-hour Access 2016 advanced course here ► https://www.simonsezit.com/courses/microsoft/learn-microsoft-access-2016-advanced-training-tutorials/

During this Microsoft Access 2016 training tutorial video, we will take you on a tour of the Access Workspace and Backstage. Get familiar with the available toolbars, panes, tabs, as well as the Backstage view accounts and options.

Check out some of our other training on YouTube:

Access 2016 training tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jb4HGldAc307RUUCn2lX4F

PowerPoint 2016 training tutorials:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jj_QkuckJNn8RddhwlQKOM

VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ

Excel 2016 training for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jUeMoLReqNzzuKj7rdLhZ2

Project 2016 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gPqakrFQ8fSNPu00rsOuzu

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 again and welcome back to our course on Access 2016. In this section I’m going to take you on a tour of the Access workspace. And in subsequent sections I’m going to look at various aspects of that workspace in more detail.

Now first of all when I open Access now my recent databases list is getting longer each time. As the list grows eventually databases start dropping off the bottom of that list. But if I have a particular database that I use perhaps not very often but which I want to always have available there, say the EspritDeTour database, you see a little pushpin over here on the side. Now if I click on that pushpin so that it changes from being a horizontal pushpin to a vertical pushpin I have pinned it to the list. And that means it won’t fall off of the bottom of the list. No matter how long the list gets EspritDeTour will still be on that list. Now on this occasion as I’m going to be going through several versions of Esprit DeTour I’m not going to pin it. But that’s a very useful tip if you want to have a particular database that’s always available.

So what I’m going to do now is to go into the Contacts database and we’re going to look at the Access 2016 workspace with the Contacts01 database open.

So let me now take you through the main features of the workspace and I’ll talk about some of the sections that we’ve got coming up to describe and explain these in more detail.

First of all at the top of the workspace we have this big block here called the Ribbon. And for those of you not familiar with the Ribbon interface I’m going to be covering that in a couple of sections from here. I am going to talk a little about the concept behind customizing the Ribbon but I’m not actually going to go through a full example of it. But I am going to talk about customizing the Quick Access Toolbar which we’ll come to in just a moment and that should give you a good idea of how to set about customizing the Ribbon.

Above the Ribbon and to the left of it is the Quick Access Toolbar. And if I click on the little dropdown at the righthand end that gives me a list of the most popular commands to use in Access and also access to facilities to customize the Quick Access Toolbar. And we’re going to cover that three sections from now.

Right at the bottom of the workspace we have the Status Bar. It’s above my Windows taskbar. And if I right click on the Status Bar you see the heading there Customize Status Bar. I’m going to explain the Status Bar to you in about five or six sections from now.
What you might consider to be the nerve center of an Access database is this panel on the left that we normally refer to as the Navigation Pane. And this lists all of the objects in an Access database. The objects are categorized. So we have Tables, Queries, Forms, etcetera. And with each category we can expand or collapse the category to see its contents. In the current Contact Management database we have two tables. We have a Contacts table and a Settings table. The tables category can be collapsed using the little double chevron on the right, as can queries, forms, etcetera. In a large, complex database you may have dozens or even hundreds of objects. And so being able to expand and collapse those categories can be very useful.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.