Monthly Archives: September 2019

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