|
Free Lessons Courses Seminars |
TechHelp Fast Tips Templates |
Topic Index Forum ABCD |
|
||||||
|
SharePoint Seminar Lessons Welcome to the Microsoft Access SharePoint Seminar. Total running time is 54 minutes. Lessons
Resources
QuestionsPost your questions or comments below
IntroIn this lesson you will learn how to connect your Microsoft Access database to Microsoft SharePoint to share data with remote users over the web. We will talk about what SharePoint is useful for, what you and your users need to get started, setting up your first SharePoint site and list, sharing your list and setting permissions, and how to link your Access tables with SharePoint. We will also walk through publishing Access tables to SharePoint, letting others access your data, and managing permissions, including how non-Access users can view and edit information online.TranscriptWelcome to the Access SharePoint Seminar brought to you by AccessLearningZone.com. I am your instructor, Richard Rost.Today's seminar will cover connecting your Microsoft Access database to Microsoft SharePoint to be shared over the web with other users and remote locations. We will learn what SharePoint is good for and what it is not good for. We will learn what you and your users will need to get started. We will see how to set up a SharePoint site for the first time, and create our first SharePoint list, which is analogous to an Access table. You will learn about sharing your list and setting up permissions, connecting your Access database to SharePoint, and linking to your SharePoint lists basically as linked tables in your Microsoft Access database. You will see how to publish Access tables up to SharePoint, distribute your database to other users, and how non-Access users can view and edit data right over the web. Lesson 1 covers what SharePoint is good for and not good for, and what you and your users need to get started using SharePoint. Lesson 2 covers creating your first SharePoint site, creating a new list, and entering and editing data in the SharePoint site. Lesson 3 shows you how to connect Access to your SharePoint site, log Access into SharePoint, export your customer table, and link the customer table to SharePoint. Lesson 4 covers permissions and distribution of your database, giving others access to your list, inviting people to access the SharePoint site, and distributing your Access encrypted file. Lesson 5 will cover seeing who modified records, hidden table fields, and removing and changing permissions to your database. QuizQ1. What is the primary focus of the Access SharePoint Seminar?A. Teaching basic Microsoft Word skills B. Connecting Access databases to SharePoint for web sharing C. Creating VBA macros in Access D. Building websites with HTML Q2. What will you learn about SharePoint in this seminar? A. How to write SharePoint code B. Only how to back up SharePoint sites C. What SharePoint is good for and not good for D. How to uninstall SharePoint Q3. What is a SharePoint list most analogous to in Microsoft Access? A. A report B. A query C. A table D. A form Q4. What is required to get started using SharePoint with Access? A. Programmers only B. Nothing, just an internet connection C. Specific requirements and setup for you and your users D. Advanced networking hardware Q5. What does Lesson 3 cover in the seminar? A. Building forms in Access B. Connecting Access to SharePoint, exporting and linking tables C. Printing reports in Access D. Designing Access queries Q6. Who can view and edit data over the web according to the seminar? A. Only Access users with admin rights B. Any user with SharePoint access, including non-Access users C. Only guest users D. Only users on Windows 7 Q7. What is included in Lesson 4? A. Creating Access queries B. Setting up permissions and distributing your database C. Designing SharePoint sites D. Building advanced macros Q8. What does Lesson 5 cover? A. How to uninstall Access and SharePoint B. Monitoring record modifications and managing permissions C. Creating backup copies of databases D. Writing web applications Answers: 1-B; 2-C; 3-C; 4-C; 5-B; 6-B; 7-B; 8-B DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks. SummaryToday's video from Access Learning Zone focuses on connecting your Microsoft Access database with Microsoft SharePoint so you can share your data online with other users and at remote locations.I'll start by explaining the strengths and limitations of using SharePoint with Access. You will find out exactly what SharePoint is helpful for, and where it may not be the right solution. I'll also outline what you and your users will need before you can start working with SharePoint. Next, I'll walk you through setting up your first SharePoint site. We will create a SharePoint list, which functions very much like an Access table, and you will see how to start entering and editing data on your new SharePoint site. You'll also learn how to share your list with others by configuring permissions, and how to connect your Access database directly to SharePoint. You'll see how linked tables work in Access when they are connected to SharePoint lists, as well as how to publish your Access tables up to SharePoint. This allows you to distribute your database and let other users work with your data. Even users who do not have Access installed can view and update your data right from their web browsers. The seminar is organized in five lessons. In Lesson 1, I will discuss the advantages and disadvantages of SharePoint, and review everything you need to get up and running. Lesson 2 covers the step-by-step process of creating a new SharePoint site, setting up a list, and working with data on that list. Lesson 3 goes through the process of connecting Access to your SharePoint site. I'll show you how to log in, export your customer table, and link Access tables to SharePoint lists. In Lesson 4, we'll look at managing permissions, distributing your database, inviting others to access your SharePoint site, and sharing your encrypted Access database with other users. Lesson 5 addresses how to track changes made to your records, dealing with hidden fields in your tables, and how to change or remove permissions from your database as needed. You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends. Topic ListOverview of SharePoint for Access usersRequirements for using Access with SharePoint Setting up a new SharePoint site Creating and managing SharePoint lists Entering and editing data in SharePoint Connecting Microsoft Access to SharePoint Logging into SharePoint from Access Exporting tables from Access to SharePoint Linking Access tables with SharePoint lists Setting and managing SharePoint permissions Inviting users to a SharePoint site Distributing an Access encrypted file Tracking modifications and record history Managing hidden fields in SharePoint tables Changing and removing database permissions |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| |||
| Keywords: access sharepoint seminar lessons PermaLink How To Connect and Share Databases with Microsoft SharePoint and Set Permissions in Microsoft Access |
