OK, Access students... I mentioned a few days ago that I've got a new Access seminar coming. I've already got over FIVE HOURS of material recorded.
In a nutshell, this database is for tracking and recording service calls, but that's only the practical example. The concept is to show you how to have a database work realistically in an office with MULTIPLE USERS, and each has his/her own piece of the database they have to work with.
Joe enters a work order. Steve has to perform the work. Manager Sue has to approve it. Joe follows back up with the customer. Everyone needs their own screens and can't mess everyone else's data up.
I'll also show you how to SECURE your Access database (both the code and the data) as best as possible with JUST Access.
I expect to release this seminar in a day or two. It still needs a little more work. Here's what I've recorded so far. Let me know what you think, and if there's anything that you can think I need to add BEFORE it's finished...
1. Database Setup, Login Form (12:23)
Create a New Database
Trusted Locations
Set Overlapping Windows
Setup UserT Table
Access User Level Security
Why ULS is Not Very Secure
"Good Enough" Security
Create Login Form
Popup
Modal
2. Login Form Code (11:42)
Docmd.Quit
Check for blank username/password
DLOOKUP Username and Password
NZ Function
3. Main Menu (9:43)
Exit Database Button
UserID, Username Fields on Main Menu
4. User Groups (14:35)
GroupT Table
Group to User Cross Reference Table
Junction Table
UserF Form
GroupF Subform
Adding Users to Groups
5. Checking Group Permissions (12:35)
Open User Form Button
Code to Check if User in Group
Is the User an Admin
Defining Your Own Function
Public Function
Return a Boolean
Global Modules
6. Service Process (9:06)
Define Service Processes
Create CustomerT Table
CustomerF Form
StatusT Track Work Order Status
ServiceT Detail on Service Call
7. Service Form (10:40)
Build Service Form
Create Combo Boxes
8. Service Listbox (11:23)
Listbox Service for Current Customer
OnCurrent Event
Modify SQL for Listbox to Format
Format Function in SQL
9. Sales Rep Security 1 (10:51)
Security: Who can Browse Customers
Assigning Customers to Sales Reps
Query to Show Only Sales Reps
Sales Rep Combo Box for Customers
10. Sales Rep Security 2 (10:43)
AllowAdditions
AllowDeletions
AllowEdits
Setting Properties in VB Code
Change Properties Based on User Group
Change Properties Based on SalesRepID
11. Locking Fields on Form (8:56)
Locking All Fields on a Form
For Each Control Loop
RGB Color Function
12. Unlocking Needed Fields (7:08)
Unlock Fields for Sales Reps
Unlock Fields for Service Techs
13. Create Service Order 1 (10:08)
Create New Service Order Button
Enable/Disable the Button
Get Default Value from Another Form
14. Create Service Order 2 (14:01)
Requery Service Listbox OnGotFocus
Open a Specific Service Order
Set a Default Sales Rep
Security Opening Service Orders
15. Assign to Service Tech (10:27)
MsgBox vbYesNoCancel
Lock Fields Once Assigned to Tech
16. Unassigned Service List (12:47)
UnassignedServiceQ Query
service List Form
17. Accepting Service Call (7:33)
Accept Service Call Button
Perform Service
18. Unassigned or My Calls (7:58)
Show Unassigned Service Calls
Show My Service Calls Button
Show ALL Service Calls
Dynamic SQL in RowSource of ListBox
19. Service Completed (11:32)
Mark Service Completed
Show Status on Service List
Show New, Open Service Calls
20. Hide Buttons on Main Menu (14:30)
Show/Hide User Form Button
Show/Hide Browse Customers Button
Open Service List Show Different Things
Private v. Public Form Functions
21. Fixing Some Problems (8:01)
Fix Problem with Sales Reps
Fix Missing Button Problem
Force Service Details to be Entered
22. Manager Review (12:29)
Manager Review 1 Button
Show Service Calls to be Reviewed
Assign For Followup Button
Hiding All Buttons on ServiceF
23. Followup, Closing Call (11:38)
Sales Rep Followup Completed Button
Manager Closed Button
24. Sending Email Notices (13:00)
Sending Email using Microsoft Outlook
Docmd.SendObject
25. Admin User Combo (11:51)
Make the UserID a Combo Box
Quick Change to Another User
26. Locking the Database 1 (9:43)
Split the Database
Front End v. Back End Databases
Encrypt Database with Password
Open Exclusive
Linked Table Manager
Get External Data
Create Links to Backend Tables
27. Locking the Database 2 (13:28)
Backup Your Database
Turn off Navigation Pane
Turn off Database Window
Show Startup Form - LoginF
Application Title
Display Navigation Pane
Allow Full Menus
Allow Shortcut Menus
Hold SHIFT Key to Bypass Security
VBA Code to Shut Off Bypass Key
AllowBypassKey
Database CreateProperty
Properties Collection
17 years ago
