Computer Learning Zone CLZ Access Excel Word Windows

An investment in knowledge pays the best interest.

-Benjamin Franklin
 
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

Lessons

Resources

Questions

Post your questions or comments below

 

Forms Queries on Sharepoint Upload Images   Link 
Kirsten Allen 
18 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
14 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?

Thanks
Sabina
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.
 
Subscribe
 
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
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