Microsoft Access help

[idonovan]

I am working on a project and need help can somone help with a step by step on how to do this? I have no clue how to do this. I think I made the database tables but what is supposto be what key and how does that get linked? and then the rest. I never used this was never taught it and now am expected to do thisl

1. Database tables (2 marks) as given below
A. Table Name: AccountType
B. Table Name: ChartOfAccounts
C. Table Name: Transactions

The data type for each field should be defined, and the primary key and foreign keys should be identified via Relationships.

2. Forms (2 marks)
A. Account Types
B. Chart of Accounts
C. Transaction

3. Queries (3 marks)
A. Balance Sheet – Jan 1, 2011
B. Balance Sheet – Dec 31, 2011
C. Income Statement – Year ending Dec 31, 2011

Queries should include relevant fields that are needed to sort and prepare the financial statements. For example, in order to create a balance sheet, we need to include a field that will enable us to “select” the account types for a balance sheet, as well as the date of the balance sheet, e.g. as at Jan 1, or Mar 31 or Dec 31, etc.

[lecale]

.