very new to access

[ryan21074]

I am absolutely new to access.

I just imported data from an excel file and saved it as a table in access 2007

the table contains data pertaining to miultiple vendors during a period.

I wanted transactions for each vendor in a report format how do i proceed

 

[Swillsy]

Hiya Ryan,

From your description I would proceed with this setup

tblCustomers
and
tblTransactions

in the customers table have fields with details about customers
have one field CustomerID and select this as the primary key using auto numbering

Then put transactions in the other table with customer id being a field there. This links the tables for a report

 

[sandrothaver]

Also new!

Hi all you fundis!

I am also new to access. I've created a form with checkboxes for 11 health districts (in order to mirror the data collection form). In a query or table, how can i get my data to reflect in one column instead of 11 columns as it is doing now?

Thanks!
Sandro

 

[Swillsy]

Hey Sandro

You will want to keep the 11 columns tbh otherwise you wont be able to add records easily.
you may want to add an extra table and put the questions in that table.

 

[Rabbie]

Hi all you fundis!

I am also new to access. I've created a form with checkboxes for 11 health districts (in order to mirror the data collection form). In a query or table, how can i get my data to reflect in one column instead of 11 columns as it is doing now?

Thanks!
Sandro

As a newcomer to access you need to familiarise yourself with the principles of data normalisation. See these links for more info

http://www.datamodel.org/NormalizationRules.html

http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

Remember that your users should only see forms/reports.

Your data should be stored in tables and you should use queries to get the data you need for Forms/reports from your tables.

If you have any specific questions just post them here and people will try to help you.

 

[ryan21074]

Hiya Ryan,

From your description I would proceed with this setup

tblCustomers
and
tblTransactions

in the customers table have fields with details about customers
have one field CustomerID and select this as the primary key using auto numbering

Then put transactions in the other table with customer id being a field there. This links the tables for a report

thanks, I have completed the report that I wanted to create. I did this by first making a blank report and then adding the data that I needed from the single table. I did not do any normalisation as I do not know what that means but will read from the site link you have attached.

Is there a way I can see see the report for a particular customer by combobox/dropdown; what I have done now is taken customer as group header and their transactions as group details.