PT wrote:
Just started using Access to track pupils within a school including
personal details and assessement details.
Have imported one table from Excel detailing names, DOB, address etc.
I want to create other tables detailing classes, ability sets etc.
What is the quickest and most efficient way?
Well, you could click on the Tables tab in the database window and click
New/Design.
If you are an Excel guru, you could create a new spreadsheet. Give each
column a heading. Then in Access, select File/GetExternalData/Link and
select the excel file. The Excel file will now be an Access table
(linked). Now you can create a dataentry forms using the linked table
within Access.