Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  

< 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: This class was recorded with Microsoft Access 2013. The material is valid for Access 2007 up to 2021. Access has not changed that much over the years.
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: $27.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


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
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
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/17/2024 3:41:00 PM. PLT: 0s