Table and form design

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have one table for a persons details and all the fields are single entry.
ie they have only one date of birth. However I want to create another table
that has one field for each of the following
Name of Training Company; Name of Course; Start date; End Date; Expiry Date
and Passed (yes/no). How do I design the table(s) and how can i use a form to
input all the different courses and companies, get it to save the info and
clear the fields ready to input another line of course data.
 
Start by clicking on the new table button in the database window. You can
then enter field names and datatypes. Consider using a naming convention and
have an understanding about reserved words.

Once you create the table, you can click on the new form button and select
the new table as the record source.
 
Back
Top