Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
 
 

< Previous: Access Expert 20

Next: Access Expert 22 >

Access Expert Level 21

Expert Microsoft Access Tutorial - 1 Hour, 54 Minutes
 
 
Access Expert 21 covers importing from and linking to other Access databases, setting up your database for a multi-user environment, splitting your database into front-end and back-end files, and record locking. Lots of good stuff in this course if you have any intention on sharing your database on a network. Topics include:
 
  - Import Access Database Objects
  - Linking to Other Access Databases
  - Splitting Your Database
  - Custom Front-End and Back-End DBs
  - Database Splitter Wizard
  - Shared Folder Permissions
  - Creating an Encrypted Front-End File
  - Preventing Design Changes
  -
Record Locking in a Shared Environment

Order Now

If you would like a preview of what's covered in this class,
click here to watch the first and last lessons of this course (free of charge), or scroll down for more information.




 

Access Expert Level 21
Description: Access Expert Level 21
Versions: Recorded with Access 2013. Also use with 2007 and 2010. Access 2003 users should get Access 308 for the lessons on importing, and Access 313 for the lessons on splitting your database.
Pre-Requisites: Access Expert Level 20 strongly recommended. This is NOT a class on Windows networking, so we will assume you have a Windows network already set up, and you know how to create user accounts and a shared folder at the Windows level. We will briefly go over creating shared folders, but we're not spending a lot of time on it.
Running Time: 1 Hour, 54 Minutes
Cost: $26.99


Today we will begin by learning how to import database objects from other Access databases. We'll import tables, queries, forms, reports, table relationships, menus, toolbars, import/export specs, and more. Then we'll learn how to Link to other Access databases to share data in real time. We'll learn how to create custom front-end forms for specific purposes.

import link access objects

 

Next we'll study multi-user database theory. It's always good to learn about how things work before starting to get your hands dirty, so we'll learn about sharing your database, why you want to split your database into front-end and back-end files, and the pros and cons of a multi-user database.

multi user database theory

 

Next we'll learn how to actually split our database. We'll learn about opening a database for exclusive use, the Database Splitter Wizard, the Linked Table Manager, renaming or moving a back-end file, setting up a shared folder, folder permissions, selecting users or groups, UNC path names, mapping a drive letter, and more.

splitting your database

 

Now that our database is split, we'll see how to move sensitive tables (such as credit history) to a different back-end file. This file can now be protected in a different network share for extra security. We will also create a separate custom front-end database file for different purposes. For example, your secretary might only need to see customer information. Your stock people might only need order information. Accounting needs order history and sales data. By splitting your database up you can create custom database files to fill specific roles, and not give people information they don't need access to. We'll learn how to create an encrypted front-end database file (ACCDE) so your end users can't make design changes.

 splitting database security

 

Finally, sharing a database on a network, in a multi-user environement can sometimes cause problems. We'll learn how to properly set up record-level locking so that two users can't edit a record at the same time. We'll learn about the Access record-lock file (LACCDB) and what it does. We'll see how to unlock a record that might be "stuck" if a user didn't shut down his database properly.

record locking

 

This is the 21st class in the Access Expert series. If you want to learn how to set up your database to be shared on a network by multiple users, this class is an absolute MUST. Of course, if you have any questions about whether or not this class is for you, please contact me.
 

 

Complete Outline - Access Expert Level 21

00. Intro (7:14)

01. Import Link Access Objects (14:45)
Import by Click-and-Drag
Import by External Data > Access
Browse to Database Folder
Import Objects Dialog
Import Options
Import Table Relationships
Import Menus and Toolbars
Import/Export Specs
Import Nav Pane Groups
Import All Images and Themes
Table Definition AND Data
Table Definition Only
Import Queries as Tables
Importing vs. Linking
Link to Customer Table
Custom Forms for Front End

02. Multi-User Database Theory (14:53)
Sharing a Database
Why Split Your Database
Front End vs. Back End Databases
Pros and Cons of Split Databases

03. Splitting Your Database 1 (20:38)
Compact & Repair First
Backup Your Data
Database Tools > Move Data > Access
Database Splitter Wizard
The database engine could not lock table
Already in use by another person
Notice Linked Tables
Set up Shared Folder
Linked Table Manager
Rename or Move Backend Database
Refresh Location of Backend Links
Setting up a Shared Folder
Folder Properties > Sharing
Assign Shared Folder Name
Setup Folder Permissions
Select Users or Group
UNC Path
Mapping a Drive Letter
04. Splitting Your Database 2 (21:15)
Storing Images on Server Share
Creating a 2nd Back End Database
Move a Secure Table to Different File
Creating a 2nd Front End Database
Custom Databases based on User Role
Distribute Encrypted Front End
Users Cannot Make Design Changes
File > Save As > Make ACCDE
Trusted Location - Shared Folder

05. Record Locking (28:42)
How Default Record Locking Works
Write Conflict Error Message
Save Record, Drop Changes
Copy to Clipboard
Form Properties > Record Locks
No Locks, All Records, Edited Record
What is an LACCDB file?
Database Client Settings
Page Level vs. Record Level Locking
Default Open Mode: Shared / Exclusive
File Open for Exclusive One Time Use
Default Record Locking
Open databases by using record-level locking
Changes take effect when first user opens db
Delete LACCDB file if record still locked

06. Review (6:15)

 


 
Keywords: Multi-User, Split Database, Record Locking, microsoft access tutorial, microsoft access tutorial, microsoft access training, access 2007, access 2010, access 2013, import access objects, external data, table definition, link to tables, sharing a database, front end, back end, move data, database splitter wizard, folder permissions, accde file, encrypted, record locks, laccdb file
 

You may want to read these articles from the 599CD News:

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP