Category Archives: Access courses

Access courses

Microsoft Access courses are delivered in two formats, classroom based and online based.  If you wish to complete an online course check out http://www.itseasytraining.co.uk . Classroom based course details can be found here.

You can assess your knowledge levels by completing the Excel document here Check Skill Level Once you have completed the document email to info@itseasy.co.uk You can book courses via email or by calling 01670 732139.

Prices and location can be found here General information about IT’s Easy Training and delivery methods can be found here

Update Queries

This video explains how to create an update query and how to qualify the query with a filtered field. The tutorial mentions that an update query does not display the result of the query, as is the case with a basic select query. An update query carries out the request and changes the data in the underlying table. It is very important that users understand that an update query can be dangerous if clicked and ran without understanding what will happen. Each time the query runs the data may be changed.

The example shown uses the parameter query feature to demonstrate the best way to create a flexible query. The parameter query uses the small square bracket symbols displayed on the keyboard to provide space for a data entry prompt. [Enter the city] for example.

Calculations in a query

The video explains how to create a calculation at query level. The example shown is a simple divide and multiplication calculation. This information is covered on the intermediate and advanced Access courses. Details can be found here.

Relational database

How to create a simple relational database

This video explains how to create a link between Microsoft Access tables to facilitate the first steps in a relational database. The video also explains how to view and edit the join properties feature and run queries based on different join options.

The content of this video is covered on the Microsoft Access course, to see the course outline click here. If you wish to complete an online course in your own time, click here.

All our courses offer after course support via email and video, which is the format shown below. To book a course email info@itseasy.co.uk or call 01670 732139. Courses can be delivered onsite using our laptops or at our training venue in Gateshead.

Linking Tables

Before you can link tables you must create a primary key and a foreign key to use as links. Once that has been achieved, select the Database tools options from the ribbon and drag the tables you require on to the screen. Once the tables are on the screen you should see the primary key and the foreign key. Drag from one to the other, it does not matter which way round you do it. You will now see the Edit Relationship box. Make sure you select the Enforce Referential Integrity option, this will stop orphan records being created. Also check that the relationship is what you require, One to Many, One to One or Many to Many relationship. In the video example there is a One to Many link in use.

Join Types

Once you have created your links you can now create a query based on your related tables. When you run a query where data comes from more than one table, you will only see records that appear in both related tables. However, if you change the join type to 2 or 3 to create either an outer or inner join, then the data displayed will include none related records as well.