Computer Learning Zone CLZ Access Excel Word Windows

All things good to know are difficult to learn.

-Greek proverb
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Home > Courses > Access > Seminars > SharePoint > Lessons
SharePoint Seminar Lessons

Welcome to the Microsoft Access SharePoint Seminar. Total running time is 54 minutes.

 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  Buy Now




Post your questions or comments below


Forms Queries on Sharepoint Upload Images   Link 
Kirsten Allen 
15 days ago
Question - I have several tables built in Access (11 tables all mapped 1:1 to the main table).

I want to allow users to interact with the forms and queries I have built, but they do not necessarily need access to the tables. Read More...
Richard Rost
11 days ago
Whatever tables your users need to get data from (via your forms and queries) will have to be in Sharepoint.
Add a Reply
Linking Access to SharePoint Upload Images   Link 
Sharon Esdaille 
2 months ago
If I am linking my database to SharePoint for other users to be able to use it, do I need to split the database or just create an encrypted version? If I need to split it, do I split it first then link to SharePoint? Or do I link to SharePoint first then split it?
Richard Rost
2 months ago
All of these questions are answered in the Seminar.
Add a Reply
SharePoint Seminar Upload Images   Link 
Sharon Esdaille 
6 months ago
I have a database I want to distribute. I watched the seminar on how to host it in SharePoint. My database has log in security. Do I need to upload the log in form, main menu form, etc. to SharePoint in order for it all to work for the person who is using an ACCBDE?
Richard Rost
6 months ago
No. Sharepoint only holds your tables. Your ACCDE file will contain all of your forms.
Sharon Esdaille
6 months ago
Thank you. Final follow up question - I exported a table that had a calculated field to SharePoint. Now that field shows as #null in SharePoint. Is there a problem with exporting tables that have calculated fields?
Add a Reply
Multiple Tables in a Query Upload Images   Link 
Sabina Compassi 
13 months ago
All set after Session 3.
Now, what if the data that need to be published in SP come from more than one table and are combined in access in a query?

Richard Rost
13 months ago
That shouldn't be a problem. Once you have them set up as linked tables in Access, they should work fine joined together in a query. You lose referential integrity, meaning Access can't cascade update or delete, but you lose that with ANY linked tables.
Add a Reply

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access sharepoint seminar lessons  PermaLink