POP OUT ALERT: OUT OF DATE

I am trying to run a simple database with 4 columns:
1. Product;
2. Date (purchase date),
3. Frequency (from date of purchase f.e. 6months),
4. Expire date
What is my database going to do is generate pop out alert when I open a
database informing about a product which f.e gone off.
Please bear on mind I am just a begginer ! I haven't use a MA for a long,
long time. Please, can anybody help me?

Create a macro named Autoexec with OpenQuery action. The query will run upon
opening Access.
Set criteria for Expire date to =Date()+7 to see
those that will expire within one week or already have.

"Michael" wrote:

I am trying to run a simple database with 4 columns:
1. Product;
2. Date (purchase date),
3. Frequency (from date of purchase f.e. 6months),
4. Expire date
What is my database going to do is generate pop out alert when I open a
database informing about a product which f.e gone off.
Please bear on mind I am just a begginer ! I haven't use a MA for a long,
long time. Please, can anybody help me?

Karl you are a STAR!!
Thank you so much for resolving my problem which was a pain in my arse!!
CHEERS!!