Access Create and Insert
Action queries deserve more attention
Let's keep track of all my 40 cats:
insert into MyPets
values (1, "Fluffy", 8, "Brown", "")
Change the age:
update MyPets
set petAge = 9
where petID = 1
insert into subList (
values(2, "Timmy"), (3, "Fishy"), (4,"Catty"), (5,"Labrador")
)