Posts

where you can type in the arguments

Learning about ms access query is the key to a good database management system as it is the heart of any database application. There are many ways and questions to ask a database using queries and mastering the special conventions and criteria will pay dividend and avoid silly mistakes, illogical record set results and even errors. One of the more commonly used criteria and prone to errors (if misunderstood) is the date/time data type and it's conventions. Take a look at the ms access query below showing orders before the year 2016 and the design of the query which suggested a date range from 1st January 2016 to 31st December 2016. The criteria for the above shows >=#01/01/2016 < #31/12/2016# which will not actually return the correct range and instead show what's known as logical errors (dates outside the range). It's missing the 'And' operator and better still adding the 'Between' operator will capture the correct range too. The # (hash sign) is the ...
Post a Comment
Read more

use the drop-down list to select an action

A standalone macro is a macro that is displayed under the Macro in the Navigation Pane. To create a standalone macro, take the following steps: 1. Click the Create tab. 2. Click Macro in the Macros & Code group. 3. You should be able to see the Macro Designer by now. To add an action, type in the macro action or click on the drop-down menu to display the list from which you choose the action that you want to use. 4. To add more actions to the macro, move to another action row, and then repeat the previous step. Access carries out the actions in the order in which you list them. 5. Click Save when your done. Create a macro group for several related macros. 1. Click the Create tab. 2. Click Macro in the Macros & Code group. 3. Once the designer is displayed, select Group from the drop-down list. 4. Input the name you want to use for the macro group in the text box. 5. Start adding the actions that you want to use. Input the macro action or use the drop-down list to select an ac...
Post a Comment
Read more