How to Setup and Easily Maintain Access Databases on a Windows Network
What you'll learn
• Modify an Access database into a front and back end, then install and maintain it on a network.
Requirements
• A basic knowledge of the layout of Microsoft Access is required, but no knowledge of macros or programming is necessary.
• You should have Office 2010. 2013, 2016 OR a the latest version from Office 365.
Description
If you have used Access but wonder what the best way is to setup Access on a network, this course is for you! Every step starting from a single database to a complete front end/back end network environment is shown in detail. I have spent many years working with businesses with multi-user networks and these are the methods I have developed to help me get the most done in a minimum of time! Why suffer through network headaches? I will show you how to avoid them completely!
From a Student Review -
With this course on networking, Bruce has hit it out of the park! This course is a great addition to the Access series taught by Bruce. He easily explains how to work with Access on a small network system with real world solutions to real world issues. This is a must take course to round out your Access training!" - Rodney
Although knowledge of VBA is not required, this course shows you how to create several programs in VBA. You don't need to understand VBA to just follow along and create the subroutines and functions for the course. Plus databases with finished VBA programs are provided for download.
Most of the employees in my client businesses have small networks staffed with people who know nothing about Access and the ribbon and navigator are always hidden, yet these people usually get more work done faster than experienced Access users! Right now there is a huge and growing need for people who can setup shared database networks like these and there just aren't enough people who know how to do it right.
Another Student Review -
"An excellent course. Bruce gives you the benefit of his extensive experience and is always prompt to reply to any query that you may have. I would rate this course at least 10 out of 5!" - Ray McConaghy
None of this is theory and you won't find these techniques in any book. The content of this course is a breakdown of the methods I successfully use to administer dozens of networks for my client businesses. I learned a long time ago that you have to automate every routine job that you can, but also you must eliminate downtime for your client and yourself by making silly mistakes. These methods of creating and maintaining small, shared folder networks remove many of the potential pitfalls and the wasted time taken up by periodically updating the network database.
Take a look at the demo video and watch as I update a network with a modified database in under 30 seconds!
A Student Review -
"Absolutely Amazing, like all courses from Bruce. Thank you for all the effort to make this stuff. It's invaluable for me!" - Grzegorz Kania
Follow along as I take you step by step through the creation of a network database and tools that let you update it easily. This course will show you :
1. Why a front end/back end arrangement is best for network usage.
2. How to split a database into front and back ends.
3. How to link the front end to the back end..
4. How to create a test so that the front end will know when an update has been added.
5. How to force the network users to do the database update themselves with a couple mouse clicks, so you don't have to update each computer.
6. How to create a work environment on your local machine, but then update the network easily.
7. How to remove the menus and ribbons and secure your database.
8. How to create a "back door" that lets you work on the database from any network computer and easily do updates.
9. How to implement your changes on the network in seconds, with no worries that you forgot to do anything.
If you take the time to learn these techniques you will save MANY HOURS of time and not have problems caused by improper updating of your network!
Another Student Review -
"Clear, easy to understand, easy to follow along with, Just exactly what I need for deploying my database next week." - Tonie Salzano
If you want to become the Network Database Guru, click the Take This Course button to get started on this journey to increased productivity and higher value for you in the marketplace. Think of it! In just a few HOURS you know more about implementing and updating Access on a network than almost everyone else!
Who this course is for:
• This course assumes that you have some familiarity with Microsoft Access. Although we create several VBA programs in this course, you do not need any programming background. The programs can be setup by anyone that can follow the detailed, step-by-step video instructions, plus you have the added advantage of a database with all the finished programs.
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
Microsoft Access- Networking Made Simple/1. Introduction/1. Introduction and a Quick Demo.mp4
9.6 MB
Microsoft Access- Networking Made Simple/1. Introduction/1. Introduction and a Quick Demo.vtt
5.6 KB
Microsoft Access- Networking Made Simple/1. Introduction/2. Course Database Download Links.html
1.2 KB
Microsoft Access- Networking Made Simple/2. Using Front and Backend Databases/1. How Does Access Share Data.mp4
21 MB
Microsoft Access- Networking Made Simple/2. Using Front and Backend Databases/1. How Does Access Share Data.vtt
8.9 KB
Microsoft Access- Networking Made Simple/2. Using Front and Backend Databases/2. Creating Front Ends and Back Ends.mp4
6.2 MB
Microsoft Access- Networking Made Simple/2. Using Front and Backend Databases/2. Creating Front Ends and Back Ends.vtt
4 KB
Microsoft Access- Networking Made Simple/2. Using Front and Backend Databases/3. Splitting a Database Manually.mp4
7 MB
Microsoft Access- Networking Made Simple/2. Using Front and Backend Databases/3. Splitting a Database Manually.vtt
3.6 KB
Microsoft Access- Networking Made Simple/2. Using Front and Backend Databases/4. Setting up the Backend on the Network.mp4
10.1 MB
Microsoft Access- Networking Made Simple/2. Using Front and Backend Databases/4. Setting up the Backend on the Network.vtt
5.2 KB
Microsoft Access- Networking Made Simple/2. Using Front and Backend Databases/5. Setup Multiple Front Ends.mp4
5 MB
Microsoft Access- Networking Made Simple/2. Using Front and Backend Databases/5. Setup Multiple Front Ends.vtt
2.9 KB
Microsoft Access- Networking Made Simple/3. How to Check for Front End Updates/1. Make the Front End Check for Updates.mp4
11.8 MB
Microsoft Access- Networking Made Simple/3. How to Check for Front End Updates/1. Make the Front End Check for Updates.vtt
5.2 KB
Microsoft Access- Networking Made Simple/3. How to Check for Front End Updates/2. Create an Update Test Subroutine.mp4
8.6 MB
Microsoft Access- Networking Made Simple/3. How to Check for Front End Updates/2. Create an Update Test Subroutine.vtt
5.3 KB
Microsoft Access- Networking Made Simple/3. How to Check for Front End Updates/3. Finish the Update Test Subroutine.mp4
9.5 MB
Microsoft Access- Networking Made Simple/3. How to Check for Front End Updates/3. Finish the Update Test Subroutine.vtt
4.4 KB
Microsoft Access- Networking Made Simple/3. How to Check for Front End Updates/4. Create the Autoexec Macro and Test the System.mp4
11.7 MB
Microsoft Access- Networking Made Simple/3. How to Check for Front End Updates/4. Create the Autoexec Macro and Test the System.vtt
5.9 KB
Microsoft Access- Networking Made Simple/4. How to Do Front End Updates/1. Create the Update database.mp4
8.5 MB
Microsoft Access- Networking Made Simple/4. How to Do Front End Updates/1. Create the Update database.vtt
4.5 KB
Microsoft Access- Networking Made Simple/4. How to Do Front End Updates/2. Start Building the Update Function.mp4
11.7 MB
Microsoft Access- Networking Made Simple/4. How to Do Front End Updates/2. Start Building the Update Function.vtt
6.5 KB
Microsoft Access- Networking Made Simple/4. How to Do Front End Updates/3. Finish Building the Update Function.mp4
16 MB
Microsoft Access- Networking Made Simple/4. How to Do Front End Updates/3. Finish Building the Update Function.vtt
7.1 KB
Microsoft Access- Networking Made Simple/4. How to Do Front End Updates/4. Create the Autoexec Macro and Test the Update Database.mp4
7.4 MB
Microsoft Access- Networking Made Simple/4. How to Do Front End Updates/4. Create the Autoexec Macro and Test the Update Database.vtt
3.8 KB
Microsoft Access- Networking Made Simple/4. How to Do Front End Updates/5. Setup and Test Update on a Network Computer.mp4
3.6 MB
Microsoft Access- Networking Made Simple/4. How to Do Front End Updates/5. Setup and Test Update on a Network Computer.vtt
2.3 KB
Microsoft Access- Networking Made Simple/5. Setup Your Production Environment/1. Build the Data Table List.mp4
8.2 MB
Microsoft Access- Networking Made Simple/5. Setup Your Production Environment/1. Build the Data Table List.vtt
3.7 KB
Microsoft Access- Networking Made Simple/5. Setup Your Production Environment/2. Build the DelTbl Subroutine.mp4
8.9 MB
Microsoft Access- Networking Made Simple/5. Setup Your Production Environment/2. Build the DelTbl Subroutine.vtt
5.3 KB
Microsoft Access- Networking Made Simple/5. Setup Your Production Environment/3. Build the Remove Links Function.mp4
10 MB
Microsoft Access- Networking Made Simple/5. Setup Your Production Environment/3. Build the Remove Links Function.vtt
5.9 KB
Microsoft Access- Networking Made Simple/5. Setup Your Production Environment/4. Create the Remove Links Macro and Test the Entire Update Process.mp4
12.3 MB
Microsoft Access- Networking Made Simple/5. Setup Your Production Environment/4. Create the Remove Links Macro and Test the Entire Update Process.vtt
6.1 KB
Microsoft Access- Networking Made Simple/6. Change Share Settings and Share a Folder/1. Setup Your Workgroup Name.mp4
6.1 MB
Microsoft Access- Networking Made Simple/6. Change Share Settings and Share a Folder/1. Setup Your Workgroup Name.vtt
2.9 KB
Microsoft Access- Networking Made Simple/6. Change Share Settings and Share a Folder/2. Change the Default Sharing Settings.mp4
5.6 MB
Microsoft Access- Networking Made Simple/6. Change Share Settings and Share a Folder/2. Change the Default Sharing Settings.vtt
2.5 KB
Microsoft Access- Networking Made Simple/6. Change Share Settings and Share a Folder/3. Setup a Shared Folder and Test From Another Computer.mp4
4.5 MB
Microsoft Access- Networking Made Simple/6. Change Share Settings and Share a Folder/3. Setup a Shared Folder and Test From Another Computer.vtt
2.4 KB
Microsoft Access- Networking Made Simple/7. Using Access RUNTIME/1. Explanation of What Access Runtime Is and How to Get the Correct Version.mp4
11.8 MB
Microsoft Access- Networking Made Simple/7. Using Access RUNTIME/1. Explanation of What Access Runtime Is and How to Get the Correct Version.vtt
4.9 KB
Microsoft Access- Networking Made Simple/7. Using Access RUNTIME/2. Installing Access RUNTIME.mp4
4.7 MB
Microsoft Access- Networking Made Simple/7. Using Access RUNTIME/2. Installing Access RUNTIME.vtt
2.2 KB
Microsoft Access- Networking Made Simple/7. Using Access RUNTIME/3. Testing Access RUNTIME.mp4
14.6 MB
Microsoft Access- Networking Made Simple/7. Using Access RUNTIME/3. Testing Access RUNTIME.vtt
7.2 KB
Microsoft Access- Networking Made Simple/8. Using Access ACCDE Compiled Databases/1. Working with Access ACCDE Databases.mp4
10.1 MB
Microsoft Access- Networking Made Simple/8. Using Access ACCDE Compiled Databases/1. Working with Access ACCDE Databases.vtt
4.9 KB
Microsoft Access- Networking Made Simple/8. Using Access ACCDE Compiled Databases/2. Modifying the Update Database to Use an ACCDE Database.mp4
14.3 MB
Microsoft Access- Networking Made Simple/8. Using Access ACCDE Compiled Databases/2. Modifying the Update Database to Use an ACCDE Database.vtt
6.4 KB
Microsoft Access- Networking Made Simple/9. Review and Conclusion/1. A Review of What We've Learned.mp4
4.5 MB
Microsoft Access- Networking Made Simple/9. Review and Conclusion/1. A Review of What We've Learned.vtt
2.1 KB
Microsoft Access- Networking Made Simple/9. Review and Conclusion/2. Bonus Lecture - Learn Even More!.html
22.9 KB
Microsoft Access- Networking Made Simple/ReadMe.txt