Hide Access: Customizing Your Database to Conceal the Microsoft Access Interface, Part 2
Vložit
- čas přidán 26. 07. 2024
- In this Microsoft Access tutorial, I will show you how to professionally mask the Access interface to impress your clients with functionality while dispelling biases. From custom startup forms, shortcuts with unique icons, to splash screens, we tackle it all in a straightforward, actionable checklist. This tutorial is designed to elevate your database, making it look less like Access and more like a bespoke software solution. Stay tuned for how to streamline your applications aesthetic. This is Part 2 of 2.
BECOME A MEMBER:
CZcams: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
Hide Access 2: 599cd.com/HideAccess2
PREREQUISITES:
Hide Access, Part 1: 599cd.com/HideAccess
LINKS:
Intro to VBA: 599cd.com/IntroVBA
Error Handling: 599cd.com/ErrorHandling
Compact & Repair: 599cd.com/Compact
Create ACCDE File: 599cd.com/ACCDE
Access Runtime: 599cd.com/Runtime
Aesthetics: 599cd.com/Aesthetics
Custom Form Backgrounds: 599cd.com/CFB
RECOMMENDED COURSES:
Access Security Seminar: 599cd.com/Security
Access Developer Courses: 599cd.com/Developer
Access SQL Server Online: 599cd.com/SQLOnline
CHECKLIST:
Startup Form (Main Menu)
Put DB in it's Own Folder
Make a Shortcut to the DB with Custom Icon
Set Application Title and Icon
Turn Navigation Pane Off (File, Options, Current DB)
Optional: Turn Full Menus, Shortcut Menus Off
Database Spash Screen (BMP in DB Folder)
Hide Ribbon and Status Bar (VBA Code on Startup)
Make Sure ALL Errors are Handled
Debug, Compile the Database
Compact It
Make an ACCDE File
Install Access Runtime
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
TechHelp Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Custom startup forms, unique icons, splash screens, Access concealment, bespoke software aesthetics, VBA coding, hide ribbon interface, shift key Access trick, ACCDE encryption, disable right-click menus, remove navigation pane, interface customization, secure database, custom controls, form design, pop-up forms, minimize Access window, Access interface tricks.
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
Live long and prosper my bro!!
Great series, Richard! I'm going to start following this checklist when I deploy a new version of a DB!
Sounds great
Hi Rick. Well since you asked for installer recommendations in this video, I will once again recommend SSE Setup. I mentioned it in my comment on part one of this video series as well. SSE Setup will automatically create a safe location for Access so that users don't get the warning when starting up the database. Also, it will detect if Access is installed on the computer. If not, it will automatically install Access Runtime.
Hi Richard that was excellent videos again more like please. Steveb
Literally just came across this yesterday.
Thanks
Welcome again
How to "create" table using VBA?
Hi Rick, first of all I'd like to tank you for all you've done for us sharing amazing knowledge, thanks to your lessons I could improve far beyond my septations my maintenance app, I have just a quick question, I tried to install the run time in a computer without office according to your orientation but some of the functionalities didn't work, have you heard anything about it? many thanks!
A little more work but good info.
Hello sir, how do you deal with the problem of control + G, as it can take you direct to the code builder from anywhere in the database.....
I ask for support to resolve an issue that constitutes a doubt in the process of creating an access program:
- I have a database with several items, with their respective values.
- I want to list items with values greater than a certain defined value (click on the button)
- I want to print items with values greater than a certain defined value (click on the button)
599cd.com/Ask
Best way to hide access is just to hide main access window from code, not minimized, but totally hide.