By Richard Rost 4 months ago
Microsoft Access Blank Database Template
In this Microsoft Access tutorial, I will teach you how to set up a blank database template that you can use for all of your projects. This way you don't have to keep making the same design changes over and over again. We'll make a single form, a continuous form, and main menu form. You will learn how to set your database to overlapping windows instead of tabs. For the menu form we'll disable record selectors, navigation buttons, and scroll bars and set it as the database startup form. We'll turn off alternating background colors in continuous forms. We'll set Allow Deletions to false. Better to "soft" delete records. Then I'll show you how to use all of that by creating a simple customer table, customer form, and customer list form.
Robert from Mexico City (a Gold Member) asks: I see in a lot of your videos you start off with a simple blank template. I, too, build a lot of new databases from scratch. How did you set that up? Any tips?
I'll show you which of the Access Options I like to change including setting up a Trusted Location, confirming document deletions and action queries, and more.
Silver Members and up get access to an Extended Cut of this video. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to contact me so I can set up your account here on my web site. If you're not a member, Join Today!
I've recenly added to this template: