Specifying Queries

This is a good idea.

Your database needs to specify (i.e. plan) the queries you're going to be using. This means it needs to

• say what the query will be called
• say what fields will be used in it - and which table they will come from

e.g.

qryInvoice
Csutomer ID - from tblCstomer
BookingID - from tblBookings

etc...