Category Archives: computer training

Access Form controls

The follow video is about Microsoft Access Form Controls and related tables used in Forms.

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

Access Tab Controls

The Access tab control feature is a great resource and helps users populate forms in a tidy easy to use format. This video demonstrates how to add the tab control and edit the labels and embed tables amongst other things.

Option groups

The video explains how to use the Forms option group control to add numerical data to an underlying table. The tutor explains a quick way to add additional option group control and change the properties.

Related tables in Forms

The video explains how to use the wizard to create a form with related tables. The database used has related tables, which when the form wizard is used, the form displays both related tables. The tutor shows this as well as how to create a manual form with two related tables.

Search Box

The video shows how to add a combo box and set it to search field information. This box can be used as a lookup field which I would normally do at table design level but there is an option to add it to a form if it has not been done at the table level. This example however uses the combo box as a find feature.

Microsoft Excel Maps

The following two videos explain how to use the Microsoft Excel maps feature and the 3D Maps feature powered by Microsoft Bing.

Both these topics are cover on the Excel courses provide either online at http://www.itseasytraining or classroom based onsite or in our Gateshead training room.

Details and course outline for Microsoft Excel training courses can be found by clicking here.

Excel Maps

The first video explains how to create a map based on geographical data. The example uses data from four European country. The tutor mentions how to change the layout, colour and style of the map. The Map feature is part of the Charts group and complements it very well.

3D Maps

When you use the 3D map feature you need an Internet connection for it to work. You also require geographical data so that the tool can plot the map. You create a series of tours, these tour will play along a timeline if you have date related data selected as shown in the video. If you are happy with the end product you have the option to save the tour as a video and then email or share it with colleagues. There are possibilities to create more complex tours by adding extra layers with additional animations.

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 in Microsoft Access

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.