50 likes | 162 Views
How to make a Query. Benedickte Gammelgaard. Open Microsoft Access and Click on New Blank Database on the top left . Write the file name of your Database on the right hand side of the same page. Click Create. Click Create on the top left corner. Click Query Wizard.
E N D
How to make a Query Benedickte Gammelgaard
Open Microsoft Access and Click on New Blank Database on the top left Write the file name of your Database on the right hand side of the same page. Click Create.
Click Create on the top left corner. Click Query Wizard
Select the fields you want for the Query Ex : Company, First name, Last name etc. Click Next. Write a Title for your Query. Click Finish.
To make any changes of the fields. Right click on the Query and click Design View You can change whether the field should be Text, Number, Currency etc. You can add a new field and you can also choose which to make visible by ticking and un ticking the boxes. When you’re done, click at the top left corner