Access 2016 for Beginners Part 3: Creating, Saving, and Opening Access Databases

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 show you how to create, save, and open databases.
Check out some of our other training on YouTube:
Access 2016 training tutorials: https://www.youtube.com/playlist?listPLzj7TwUeMQ3jb4HGldAc307RUUCn2lX4F
PowerPoint 2016 training tutorials: https://www.youtube.com/playlist?listPLzj7TwUeMQ3jj_QkuckJNn8RddhwlQKOM
VBA for Excel tutorials: https://www.youtube.com/playlist?listPLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ
Excel 2016 training for beginners: https://www.youtube.com/playlist?listPLzj7TwUeMQ3jUeMoLReqNzzuKj7rdLhZ2
Project 2016 training: https://www.youtube.com/playlist?listPLzj7TwUeMQ3gPqakrFQ8fSNPu00rsOuzu
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 the preceding section we created a first database, a contacts database. I’ve just restarted Access and if you look at the start screen sure enough there is the name of that contacts database in my Recent Databases list. So the first thing I’m going to do is to open that. Note the welcome screen. I am going to close that for the moment. And what I’m going to do now is to save this database using a name of my choosing and I’m going to save it into the course files folder.
Now I mentioned to you right near the beginning of the course that I’ll be setting various exercises. This is not one of those exercises but it’s a good idea for you to create a database using one of the templates and to save that in a set location as well just to make sure that you’re familiar with that procedure.
Now the first thing to note is that in order to save this database I need to close any open objects such as tables and forms. We have no form open. I opened the welcome form just now. But we need to close the contacts table. So I’m going to close that using its little Close button there, Close Contact List. Now there are no objects in the database open and I can go to File, click on Save As, click on the Save As button here, and I have browsed to the course files folder. Now the standard file type for an Access desktop database is ACCDB. So the extension is .accdb but I’m going to change the file name. And I’m changing it to Contacts01. So that’s the name of my contacts database. All I do now is click on Save.
Now note that once I save it I have to go through the enabling routine again. Now that’s not a problem because I know that this is a safe database. I’m now working on Contact01 in the course files folder.
What I’m going to do now is to close Access yet again and I’m going to start it up yet again. Now of course this time when I start it up as you would expect you can see both of those databases in my recent databases list. Note that they are now separate databases. Now clearly if I wanted to work on Contact01 then I just click on it and away I go. But we also have the Open Other Files option there. If I click on that I get there also a list of recently opened files and when they were last opened. And as you can see both of those were opened today.
Now notice that if the database I want to open isn’t in the list on the right there I have options for where to open a database from. And amongst the options that I have are the OneDrive cloud storage that I get as part of this particular Office 365 subscription. If you’re using an Office 365 copy of Access 2016 you should see OneDrive here. There is a Sites – TobyA option there. That is actually a SharePoint option. If you do have SharePoint as part of your Office 365 subscription then you’ll have access to SharePoint there as well. I’m not going to talk about the interaction between Access and SharePoint on this course.
And then I also have another available OneDrive cloud storage facility there as well. Exactly which of those features, OneDrive and SharePoint, that you see will depend on your account. You may not see anything at all there if you’re using a bought copy of Access 2016 or Office 2016 and you don’t have OneDrive, for example, as part of an Office 365 subscription.
Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.