Computer Learning Zone CLZ Access Excel Word Windows

The nitrogen in our DNA, the calcium in our teeth, the iron in our blood, the carbon in our apple pies were made in the interiors of collapsing stars. We are made of starstuff.

-Carl Sagan
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Courses > Access > Templates > ABCD > Part 1 < ABCD | Part 2 >
ABCD Core Part 1

Access Business & Contact Database Part 1

Welcome to ABCD Part 1: Core. Total running time is 3 hours, 27 minutes.


 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark Buy Now

Lessons

Contents

This is the foundation of the database. We will construct the tables and forms necessary to store information about people, organizations, and companies (called Entities). Each entity can have an unlimited number of phone, email, and physical addresses. We will use Helper data tables to store all of the minor information like name prefixes, suffixes etc. so that we don't clutter the database with dozens of tiny tables. We will create a function to assign EntityCode values to each person so we don't expose our AutoNumbers.

Database Files

Resources

Learn More

Notes

  • Importing Data: A few of you have asked for instructions on how to import data from your existing databases or Excel sheets to the ABCD. Considering the structure of the tables (Entity with Phone, Address, Email all in separate tables) this can be a challenge. I include a good example of how to do this in my Normalizing Data Extended Cut video. Enjoy.

Pre-Requisites Required

In order to purchase any level of the ABCD, you MUST have purchased all previous levels. For example, you cannot buy only Level 5. You must first have Levels 1 through 4, then you can buy Level 5. Sorry, but this is a hard pre-requisite.

Videos

I am recording videos showing how the database is built, but mostly so that you can understand the construction and be better equipped to make any modifications or additions you may need on your own. This will be marketed as a finished database without the need for any enhancements, but, of course, one of the main reasons to use Access is so that you can make changes yourself. The videos will be a quick run-through of how each feature is built, as I'm building it. I will be using advanced features like SQL and VBA from the start, so you may want some SQL or VBA Developer Lessons under your belt if you're going to try to follow along. This is NOT a teaching database. Free Technical Support will NOT be offered.

Tech Support

There is NO free Technical Support provided on the ABCD if you have not taken ALL of my previous Developer lessons. There are a lot of very difficult, advanced programming concepts used in the construction of this database. I do not have the time to provide free support if you get stuck trying to make modifications. All I will do is point you to the appropriate Developer lesson(s) that cover the issue. There is a reason why (a) I say this is NOT a teaching database, and (b) there are pre-requisites. Feel free to ask questions, but I can't spend half an hour explaining concepts that are already covered in my other lessons.

Licensing

Unlike my other courses and seminars which provide you with royalty-free databases that you can modify and distribute yourself, the ABCD does NOT come with a royalty-free license. You may only customize the database for your business needs and for use within your organization. You may not resell or distribute it to others without express written permission. In addition, if you are using it in an organization with more than 10 users, you must purchase additional licenses. Contact me for additional information. I will post additional details when the Core database is completed.

Ordering

There are two purchase options available for the ABCD.

  • You can purchase a fully editable and customizable copy of the database in addition to the video tutorials that show how it was built. This is the option you should pick if you want to make changes to the database for your own business needs, and you want to learn how the database was constructed to assist you. As a reminder, these are not teaching videos. They are simply provided to show you how the database was built. Free support is not guaranteed if you have questions. I do my best to answer questions, but I can't promise anything. You must purchase any pre-requisite parts or modules required. For example, you may not purchase Core Part 4 without first having parts 1 thru 3.
  • Once the Core is finished, you can optionally purchase a use-only version of the database. This is the best option if you only plan on using the database for your personal or business needs, but do not intend on modifying the structure of the database. Free instructional videos will be provided to teach your staff how to use it.

Your Feedback

I will be releasing new Core features and modules on a regular basis. You can see the list of features that are scheduled for development on the Coming Soon page. I would very much like your feedback on what features you think should be available. If you have a specific interest for your business type, let me know. 

 

Comments for ABCD Core Part 1
 
Age Subject From
32 daysEmbeded SubformsPhilip Carley
18 monthsPart numbers do not matchAlejandro Juarez
20 monthsSeveral People Same AddressDonald Lader
2 yearsABCDTim Anderson
2 yearsDifferent EntitiesJames Gray
2 yearsWebsitesRamona Woitas
2 yearsMake Entity CodeRamona Woitas
2 yearsSeveral People Same AddressAngelika Senn
2 yearsImporting Data to ABCDRichard Rost
3 yearsCore 1 Lesson 9 Person CodeRon VandeVelde
3 yearsTransfer DataHarold Sheats
3 yearsPerson Entity tableScott Axton
3 yearsHelper FormJoseph Messina
3 yearsHelperT questionRon VandeVelde
4 yearsABCD Part 1Michelle Maughan
4 yearsABCD Addressee LinesRichard Wilson

 

Start a NEW Conversation
 
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
 
Subscribe
Subscribe to ABCD Core Part 1
Get notifications when this page is updated
 
 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 10/10/2024 1:03:13 AM. PLT: 1s
Keywords: access ABCD 01 part 01 core  PermaLink  ABCD Core Part 1