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.

Access Reports

This video below explains how to create Access reports. The tutorial is a part seven of a series. If you are interested in completing a Microsoft Access classroom based courses, details can be found by clicking here. If you would like an online course click here

Access reports in design mode

There are several ways to create an Access report, the temptation is to use one of the automated options but in my experience that may be unwise. The wizard often creates a report with truncated text and field boxes, you will have go into design to fix this issue.

Using report design as your first option enables you to get a better understanding on how reports in Microsoft Access work. You first attach the table or query required then add the grouping options if any. You can start to add your fields and position them as required. It may take a little bit longer to finish but once you have, the end product will be far better.

Print Preview

In Microsoft Access report design mode you can select how you want your records to be displayed. They can be shown altogether as the wizard creates or you could select the one record per page option. First select the details bar in design mode, then right click into properties. Once in properties, select force page break after section.

Microsoft Training Courses

Overview

The Microsoft Office , Project and Visio buttons displayed below link to the course outlines for classroom based courses. If you wish an online course go to http://www.itseasytraining.co.uk

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

Microsoft Office Courses

Microsoft Office course delivery is broken down in to three parts Introduction, Intermediate and advanced levels. Some courses have only one level but may take more than one day. All courses can be customised, the layouts are a guide only.

Microsoft Project classroom based courses in Newcastle, Gateshead and UK wide, onsite if required.
Microsoft Project helps managers to plan, organise and resource projects of all sizes, with features that help you to save time, money, stress and avoid missing key deadlines.
Microsoft Access classroom based courses in Newcastle, Gateshead and UK wide, onsite if required.
Microsoft Access is a powerful database package, yet many people find it difficult to use fully. Our courses will equip you with the skills and experience you need to master Access databases.
Microsoft Visio classroom based courses in Newcastle, Gateshead and UK wide, onsite if required.
Microsoft Visio is a powerful diagrammatic tool that is great for flowcharts, process diagrams, organisational charts and much more
Microsoft Outlook classroom based courses in Newcastle, Gateshead and UK wide, onsite if required.
Microsoft Outlook provides an information hub for contacts, calendars, tasks and emails
Microsoft Excel classroom based courses in Newcastle, Gateshead and UK wide, onsite if required.
Whether you are new to Microsoft Excel or need to develop existing skills, our popular Excel courses will help you to develop your skills and feel more confident using Excel
Microsoft Word classroom based courses in Newcastle, Gateshead and UK wide, onsite if required.
Many people struggle using Microsoft Word. On our courses you’ll learn basics such as typing and layout skills through to advanced features, making you more confident and productive
Microsoft PowerPoint classroom based courses in Newcastle, Gateshead and UK wide, onsite if required.
Microsoft PowerPoint in a visual presentation tool that provides exciting and comprehensive delivery techniques to aid with predestination style and content
Microsoft Publisher classroom based courses in Newcastle, Gateshead and UK wide, onsite if required.
Microsoft Publisher provide a template based set of documents, leaflets, brochures and much more

Microsoft Access database table design

The video is part 2 of the how to create a Microsoft Access database series, Access database table design. The information covered in this video is available as part of the Introduction Access course, details can be found at https://www.itseasy.co.uk/courses/access-training/ Online training courses are also available at http://www.itseasytraining.co.uk We can deliver training at your site with our laptops or you can come to our site in Gateshead. All courses have free after course support for each delegate via email and or video examples.

Calculations

This video explains how to use calculations in a Microsoft Access database table. The tutor covers how to create a calculated field and then use it. I have used many calculated fields in my own database, for example to flag up if an item has vat due or not. Creating an Access database calculation can save a lot of time on data entry and make data entry more accurate. The more automated features you have, such as database calculations and lookups the safer the data.

Data Types

All the data types are explained with examples of how to use them. The short text data type is now the default setting but the date/time data type is used very often. It is important to put an input mask on date field and not just rely on the format feature.

Primary Key

The primary key is a unique identifier and is not duplicated, fields like staff id or payroll number are usually best as a primary field. The primary key is used extensively when you start to join tables and create relationships in Microsoft Access database. You must take care in choosing a primary key, because if you get it wrong it can have a catastrophic effect on your data.

Validation rules

You can add data validation rules to your fields to make sure data entry is correct this video explains how this can be done. The video also covers how to add data validation rules at table level.

Access database

This video explains how to start and create your own Access database. This tutorial is part one of many. The next series in this blog will be all about building a Microsoft Access database.

Access Database

Course details and outline can be found at https://www.itseasy.co.uk/courses/access-training/ Courses can be delivered onsite at your location, we can provide laptops or you can come to our training room in Gateshead. Every delegate will receive a training manual and after course support via email. Online courses are available at http://www.itseasytraining.co.uk

Table Design

The most important feature in Microsoft Access is the database design. The column titles and the data type are absolutely crucial to the database integrity. The video explains how to create input mask to prevent inaccurate data entry and how to add data validation rules to make sure dates for example are entered in the correct sequence. The video also explains the field properties, such as input masks, data validation, formatting and field size. It is important to get this foundation correct. The field sizes will impact on the database size if not set correctly, 255 characters is the default setting but often fields are much smaller.

Lookup tables

This first module quickly explains how to create a lookup table and name it. The tutorial covers how to add the lookup table to a field. lookup tables are a safe way to add data to a field because the data entry is already present and correct in the lookup table, therefore cannot be entered incorrectly. In follow up modules more details will be given on how lookup tables work and the different types.

Street Map in Visio

Street Map in Microsoft Visio

Using the 2D and 3D directional shapes in Microsoft Visio to build a street map can be frustrating if you only use the shapes that are available in the template. This video explains how to get the best out of custom shapes and a personal stencil and why they are so useful

Training

IT’s Easy Training provides two forms of training, onsite in out Gateshead training rooms or online at http://www.itseasytraining.co.uk. Course details for the classroom based courses can be found at https://www.itseasy.co.uk/courses/visio-training/ Courses are available on your own site anywhere in the UK if you prefer onsite training. We will provide laptops and a trainer.

Custom shapes

Creating custom shapes and adding them to your own stencil is a great way to speed up your drawings in Microsoft Visio. You may need to create several different stencil to cater for different template drawings and scaling issues, but once done you will find it well worth your while.

Stencils

It is a simple process to create new stencil, just select More Shapes and click on New stencil, name it and save it. To add shapes simply drag and drop them on to your stencil, remember to save the stencil. You will have to rename any shape that you add or create, simply double click on it and rename it.

Street Map

I find it useful to create groups of houses and road segments and then add them to my stencil. I achieve consistency of design and size doing it this way. There is nothing worse than shapes that are suppose to be the same appearing all over the place in terms of size and scale.

Lookup Images in Microsoft Excel

This video explains how to use the Indirect function and the DGet function to lookup images and data in an Excel sheet. The tutorial covers how to use named cells and ranges, also how to use data validation lists.

Training courses are available at https://www.itseasy.co.uk/courses/excel-training/ courses can be delivery onsite or at our site in Gateshead. Online courses are available at http://www.itseasytraining.co.uk We have laptop which are available to use at your site and convenience. Call or email steve@itseasy.co.uk Business Mobile 07966503354

Lookup Images

The process in this video starts off explaining named cells and ranges, each photo sits inside a named cell. The tutor explains how to create a data validation list that displays the names of the photos. The indirect function is added in the name manager to reference the data validation box.

Indirect

The Indirect function is added to the name manager, by selecting new and creating a name. The Indirect function returns data from a referenced cell, in this case the image.

Images

Any of the images in the data set can be copied and placed in the relevant location on the lookup sheet. With the image selected the tutor explains that the formula must be typed using the Indirect name, (Flag) in the video example.

DGet

The DGet function is used to bring the remaining data across using the Data Validation list as its trigger. The DGet function works in a similar way to a Lookup working with a database of information.

I think that the best uses of these functions is in a catalogue of stock or parts. The parts or stock could have a photo which would be returned as and when required along with all the other data normally associated with lookups. Check out our YouTube channel at http://www.itseasytraining1st for more videos like this. Feel free to ask questions or ask for more videos.