Building data for a report

[psrs0810]

I have created 8 tables that I need reference for building out another table called ReportBuilder. I am new to Access and need some guidance.
for building out the ReporBuilder Table, I want to reference the DeptXRef table and in the ExcludeDept field if it says Data Dependent, to copy the dept number in field AliasDept and put that into the ReportBuilder Table - Dept field

any help is greatly appreciated.

 

[Joe4]

You typically do not use tables to create data for other tables for the purposes of Reports.
If you have data from multiple Tables that you need to get into a single Report, you typically use Queries to combine your data (and use the Query as the Data Source of your Report), or you might use SubReports.

Note that you can use Queries for the source of Reports, Forms, and Exports just as easily as you can Tables.

 

[psrs0810]

oh boy! I have some learning to do.
I know what I need and I know the end result. it's a matter of getting there

 

[psrs0810]

what is a good resource for understanding the connections?
thanks

 

[Joe4]

what is a good resource for understanding the connections?

Can you be more specific?
Are you talking about the connections in your database (i.e. relationships between your tables)?
Whoever designed the database would be the best person to ask that.

 

[psrs0810]

I am doing this on my own. I need to understand the relationships between the tables and create other information of them

 

[Joe4]

They are whatever you make them, but there are rules/guidelines you want to follow when designing them.
I suggest doing some Google searches on "Database Design and Normalization". There are lots of good articles out there on it, some are even Access centric.
Here are a few to get you started:
http://www.informit.com/articles/article.aspx?p=27226
https://support.microsoft.com/en-us/help/283878/description-of-the-database-normalization-basics

It is really important to understand Relational Database theory, especially Rules of Normalization, when designing databases. If you design it correctly, it will give you the power to do almost anything you want. If you don't design it according to those rules, you risk creating yourself a ton of headaches, where even seemingly simple tasks become difficult! I know, I have been there and done that!