Any help would be much appreciated.
I'm going to need the following data incorporated
name, test (multiple fields), pass or fail, and maybe a comments section
i know pretty much next to nothing about access, so again, all help is appreciated.
Any help would be much appreciated.
I'm going to need the following data incorporated
name, test (multiple fields), pass or fail, and maybe a comments section
i know pretty much next to nothing about access, so again, all help is appreciated.
Here is a good starting point.
http://forums.aspfree.com/microsoft-...es-208217.html
Here are some additional examples:
First you need to create tables to store your data. It sounds like you need an employee table to store information about each employee. You need a test table to store information about all tests an employee can take. You need an EmployeeTest Table to store information about each test an employee takes (this table will store the Pass/Fail field).
Here's a link on how to create tables in Access
http://support.microsoft.com/kb/304238
You need to learn about relationships between tables in order to link your tables to eachother:
http://databases.about.com/od/tutori...ccess-2010.htm
You will need to create a main form based on your employees table and a subform based on the employeeTest table.
Learn about creating main forms and subforms as well as Parent/Child fields here:
http://office.microsoft.com/en-us/ac...010098674.aspx
Hope this helps you on your way.