| |
| |
|
|
|
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.
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.
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.
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.
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.
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 |
| |
|
|
