Microsoft Access: Networking Made Simple (Udemy.com)

How to Setup and Easily Maintain Access Databases on a Windows Network

Created by: Bruce Myron

Produced in 2021

icon
What you will learn

  • Modify an Access database into a front and back end, then install and maintain it on a network.

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100

icon
Course 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 :

Why a front end/back end arrangement is best for network usage.
How to split a database into front and back ends.
How to link the front end to the back end..
How to create a test so that the front end will know when an update has been added.
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.
How to create a work environment on your local machine, but then update the network easily.
How to remove the menus and ribbons and secure your database.
How to create a "back door" that lets you work on the database from any network computer and easily do updates.
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.

icon
Instructor Details

Bruce Myron

Hello, my name is Bruce Myron. I am a self employed Access programmer and general computer consultant to small and medium sized businesses. I got into programming because I was tired of all the jargon most programmers use and how they don't seem to care about business.
"Technology is great but I've always been more interested in how it can be used to make companies more profitable." - Bruce
I live in Portland, Oregon and have many long term relationships with local businesses. Many of the systems I have built for these companies are critical to the success of the business. My specialty is taking the needs of the business and translating them into a system that facilitates, rather than obstructs, what they are trying to do.
I have also spent time as a full time trainer providing group classes on the Microsoft Office programs.
In my opinion the computer industry as a whole is a colossal failure in helping businesses solve their problems. I listen carefully to the needs expressed by my clients and then deliver the simplest, most flexible solution possible.
Over the years I have found that many of the techniques I have used enabled me to survive and thrive when many others have tried the computer programming business and failed.
My goal is to show my students how to create systems that business will value and that will create long term income.

icon
More courses by Bruce Myron

Excel to Access: Intro to Microsoft Access for Excel Users

$11.99

Microsoft Access VBA for Non Programmers - YOU Can Do This!

$11.99

Microsoft Access VBA, Design and Advanced Methods Workshop 1

$11.99

Microsoft Access VBA: Automating Import of Excel Files

$11.99

Access to Excel- Instant Excel Reports & Excel Pivot Tables

$11.99

Microsoft Access Networking 2: Maximum Security

$11.99

icon
More it & software courses

Kubernetes Certified Application Developer (CKAD) with Tests

$11.99

Angel Oracle Card Reader Course; Become the Oracle

$11.99

Cisco CCENT Packet Tracer Ultimate labs: ICND1 Exam prep lab

$11.99

Microsoft Access Networking 2: Maximum Security

$11.99

Oracle 12c Multitenant Architecture Administration

$11.99

Certified Kubernetes Administrator (CKA) with Practice Tests

$11.99

icon
Reviews

4.7

180 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By fxmith . on 10/26/2020

Bruce Myron delivers. To the point with clear explanations and usable content. Excellent.

By Joanna Cotterell on 10/21/2020

Yes learning value information!

By Prahlada Nayaka on 9/13/2020

Just started. Great, as usual.

By Abdalla abbas on 8/24/2020

good course , simple and practical ,would like if there is notes at the end of every section like vba course

By Athanasios Litsakos on 8/22/2020

Great Lecture, you dont need to check elsewhere

By Varunya Borvornpadungkitti on 7/24/2020

Totally useful

By Aladdin Eid on 7/19/2020

Bruce is a great instructor , and he is knowledgeable too, he opens good points which everyone can use in a different way from the other to do the job

By Peera Tienthong on 7/11/2020

The explanation is clear, useful and practical!

By James Krueger on 6/12/2020

This course will help me deploy a database for an RV Park Coop on either a local network or a network based on use of DropBox (if that is possible). It will also help me understand how to allow people to update elements of the database without causing a conflict. Very important!

By Mike Landon on 6/3/2020

teaches many new things about networking access that i was not aware of. great instructor

By Bharatkumar on 5/25/2020

Two person must take this course one who suffer speed issue and other who want to take benefit of Bruce experiences thank you very much Bruce

By Johan Welman on 5/10/2020

Brilliant information that address real-world, practical issues in networked environments. Highly recommended.