Sharing Your Access Database Online with Microsoft SharePoint

Welcome

I get asked all the time: "How can I share my Microsoft Access database with others online?" 

This seminar covers sharing your Microsoft Access database online using SharePoint. If you've got a small team and a small database, then a SharePoint solution might be right for you.

Resources

• Full Seminar Lessons Page
• Course Topic Outline
• Purchase the Seminar

Updates

• This seminar was recorded in 2020. I have been told that Microsoft has since changed the web-based interface for SharePoint since these videos were recorded, as companies are likely to do to websites every couple of years. Several students of mine have told me that they were able to very easily navigate the differences without any problems, but I just want you to be aware of it before purchasing this seminar. As of right now, I have no plans to update this seminar as my preferred method of connecting an Access database to the Internet is using SQL Server. 
   
• If you do not currently have SharePoint up and running in your organization, and you're trying to decide what tools you need to share your Access database online, I strongly recommend using SQL Server over SharePoint. It's a lot more flexible, powerful, and easier to work with - in my humble opinion. If your company is already using SharePoint and that's the platform you want to stick with, that's fine. No problem. It's a good solution. I just personally think SQL Server is better. But both will get the job done.

Topics Covered

In Lesson 1, you will learn what SharePoint is good for, what it's NOT good for, and what both you and your users will need to get started using a SharePoint Access solution.

In Lesson 2, you will learn how to create your first SharePoint Site, how to create a new List (analogous to an Access Table), and how to enter and edit data using the SharePoint web interface.

In Lesson 3, you will learn how to connect Access to your SharePoint Site, how to log in, export your CustomerT table to a SharePoint List, and then link to that list form your database.

In Lesson 4, you will learn about permissions in SharePoint, how to distribute your database, giving other users access to your SharePoint List, sending email invites, and distributing an ACCDE encrypted Access file.

In Lesson 5, you will learn to see what user modified records in your database, the hidden table fields, and how to remove and change permissions.

Enroll Now

Enroll now so that you can watch these lessons, learn with us, post questions, and more.

Questions

Feel free to post your questions or comments below