How do I slow down my use of Access!!

%3CLINGO-SUB%20id%3D%22lingo-sub-1414805%22%20slang%3D%22en-US%22%3EHow%20do%20I%20slow%20down%20my%20use%20of%20Access!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1414805%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20a%20new%20user%20of%20Access.%20I've%20developed%20a%26nbsp%3B%20database%20to%20manage%20the%20membership%20of%20a%20small%20fishing%20club.%20I've%20used%20it%20once%20in%20anger%20and%20my%20problem%20is%20that%20it%20is%20too%20quick%20and%20easy%20to%20use!%20I%20find%20that%20I%20race%20ahead%20and%20then%20forget%20whether%20I%20have%20updated%20all%20of%20the%20fields%3B%20in%20particular%20has%20the%20member%20renewed!%20What%20I%20need%20is%20a%20way%20to%20stop%20myself%20proceeding%20until%20I've%20completed%20everything.%20Ideally%20there%20would%20be%20something%20that%20perhaps%20shows%20(in%20a%20different%20colour%3F)%20that%20a%20field%20had%20not%20been%20updated.%20Either%20that%20or%20perhaps%20something%20that%20simply%20stopped%20me%20proceeding%20until%20everything%20had%20been%20checked%20and%20updated.%20Your%20advice%20or%20suggestions%20would%20be%20gratefully%20received.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1414805%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I'm a new user of Access. I've developed a  database to manage the membership of a small fishing club. I've used it once in anger and my problem is that it is too quick and easy to use! I find that I race ahead and then forget whether I have updated all of the fields; in particular has the member renewed! What I need is a way to stop myself proceeding until I've completed everything. Ideally there would be something that perhaps shows (in a different colour?) that a field had not been updated. Either that or perhaps something that simply stopped me proceeding until everything had been checked and updated. Your advice or suggestions would be gratefully received. 

1 Reply
Highlighted

@Matthew328 

Perhaps the solution would be to make some fields required at the table level. That way, you'll get an error if you try to save a record with one or more of those required values missing.