Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Help   Contact   Merch   Join   Order   Logon   Forums   
 
Back to Access Forum    Comments List
Upload Images | @Reply | Bookmark | Link | Email | Next Unseen |
The Proper Sequence of Building Using a Database
Paul Jack Higginbotham 
     
15 days ago
I honestly don’t know how to ask what I need or in what order so here goes.

Do I create a table then type in all the airports in table data sheet view, or create the table and then create a form and type in all the airports or, create all the tables in the database first, and then populate each one with the data? I ask because I love Combo Boxes, but in order to use a combo box there has to be data in the tables to begin with right?

Then there’s the amount of tables. Too few or too many? How do I know what is the right amount of tables?

What I’m mostly interested in is Queries that use the One-to-Many relationships where I can ask a lot of different questions in the query but it seems to me that the database has to be 100% populated with the necessary data which leads back to the first questions above.
Debbie Heaney  @Reply  
     
15 days ago
I usually start with building tables and adding data first.
The data at the start makes it easier to see if you are then doing forms and right, then the queries, then the reports.
Then work on the forms for working with the data, adding in, deleting, reading, and such like.

Build it one table at a time. If your project needs 10 tables then use 10 tables. If you only need 1 then use one.
Projects can grow arms and legs real fast.
You starting off thinking you only need 2-3 tables but as the project grows you find yourself adding another, then another.
Same with everything else. 1 query suddenly becomes 2, then 3 (I have that very situation happening right now in one of my own projects).
Donald Blackwell  @Reply  
       
15 days ago
I typically start with a main table and then any necessary helper tables just to be able to populate ome sample data.

Once i have 3 to 5 sample records, I then create the forms I need.
Richard Rost  @Reply  
           
15 days ago
Both Debbie and Donald have the right general approach. I would start by designing the tables first, at least on paper. Figure out what information you need to store and how the pieces relate to each other.

For something like airports, you'd probably have an AirportT with one record per airport. If you have a FlightT, then each flight record can store the AirportID for its departure and arrival airports. Populate lookup tables like AirportT early so your combo boxes have something to display.

You don't need every table completely filled with real data before you begin building forms and queries. A handful of sample records is enough to test the relationships, combo boxes, and queries. Then you can adjust the design before entering hundreds or thousands of records.

As for the "right" number of tables, there isn't a magic number. Use as many as are needed to store each type of thing once, without repeating the same information over and over. Start with the data and relationships, not the queries. Good table design makes the queries much easier later.
Richard Rost  @Reply  
           
15 days ago
One more thought: this is definitely something you'll get better at the more you do it. Your first database or two aren't going to be perfect. I've built hundreds, if not thousands, and after a while you just learn what works and what doesn't.

The best advice I can give is to build a few different databases first. That's what I always say in my classes: build a hobby database. Track your baseball cards, Dungeons & Dragons characters - that was one of mine - Star Trek episodes, whatever sounds fun to you. Working on something enjoyable helps you learn the techniques without putting all the pressure on one database.
Monica Jones  @Reply  
       
15 days ago
Here's a video of how he approaches the design before opening Access. It can be really helpful to get your thoughts out and organized first. https://599cd.com/blog/display-article.asp?ID=2567
Richard Rost  @Reply  
           
15 days ago
Good choice, Monica. :)
Add a Reply Upload an Image
Next Unseen

 
 
What's This?

 

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 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 11/17/2026 1:56:39 AM. PLT: 1s