Author Archive for Emilie Musson

A great tool in Access is Relationship; which is used to combine information between two or more tables. You need more than one table to do this. So the first step would be to create two or more tables relative to your database.

To start, you need to Select the Database Tools tab in the Ribbon, in the Relationships command group and click Relationships.

If you haven’t yet defined any relationships between your tables, the Show Table dialog box will appear automatically. To find Show Table dialog box however, all you have to do is click on the Design contextual tab, in the Relationships group click Show Table.

Once the Show Table dialog box appears, it will display all of the tables and queries in the database. To see only tables, click Tables tab.

Select one or more tables, and then click Add. For this example, we are looking at creating a relationship between Customers and Employees tables. Click Close when you are done.

Drag a field (typically the primary key) from one table to the common field (the foreign key) in the other table. You can drag multiple fields by pressing the Ctrl key on your keyboard and click each field you want, and then drag them. You can do this between Multiple Tables to any field required.

Dragging from one field to the other is the easiest way of creating instant relationships.

The Edit Relationships dialog box appears.

Verify that the field names shown are the common fields for the relationship. If you want to edit it or if a field name is incorrect or you have changed your mind, simply click on the field name and select the appropriate field from the list.

To enforce referential integrity for this relationship, select the Enforce Referential Integrity box. Note that Relationship Type appears at the bottom. Click Create New button to create more relationship and add the details in the Create New dialog box

And if can set the Join Type by click the relevant button:

When you are finished in the Relationships window, click Save to save your relationship layout changes.

We hope that you found this tip insightful and helpful, if you would like any more access tip’s, check out our others.

The Skills Funding Agency (SFA) is a UK government funded scheme that funds skills training for further education (FE) in England. The scheme supports over 1,000 colleges, privatetraining providers , and employers with £3.7 billion funding each year.

The scheme is renowned for its selective properties and many SMEs struggle to become approved as it is such a prestige list. To quote SFA “Organisations that passed the due diligence questions at the Register refresh are listed on the Register. We look to deliver excellent business performance through our people”.

Here at Infero we are proud to state that we are a SFA registered training provider. The scheme is aimed at organisations that provide exceptional quality training and have a top priority of delivering an outstanding service, these are aspects in which we pride ourselves on. We were first approved in 2015 and now again re-approved in January as a SFA Training Provider.

We see the register as a guideline to ensure our customers receive outstanding services. This is also a testament to our company’s quality standards and our 100% Money Back Guarantee. We will continue to work hard to deliver to the standards of SFA and we would like to thank our customers for their feedback to help improve our services and courses.

Don’t forget, if you have any questions then don’t be shy, we’d love to hear.

With a New Year lurking around the corner, it’s around that time when people start to make New Years Resolutions, So here’s how you can use Microsoft Word to assist your goals.

Microsoft has features so that you can bullet point everything that you would like to accomplish, you can also highlight and underscore important sentences. By using Word you can also print out your document so you can tick things off and have it as a reminder to yourself.

Here’s a rough idea…

To be able to create bullet points, select the text you would like to change and just simply click Home and then click the 3 dots to access the bullet point tool.

We hope you found this helpful and that you have a wonderful New Year.

TImagine you’re working with a really long document in Microsoft Word, like an academic paper or a big report. Depending on the project, it might be dozens or even hundreds of pages long! When a document is this large, it can be difficult to remember which page has what information. Fortunately, Word allows you to insert a table of contents, making it easy to organize and navigate your document.

A table of contents is just like the list of chapters at the beginning of a book. It lists each section in the document and the page number where that section begins.

You could create a table of contents manually—typing the section names and page numbers—but it would take a lot of work. And if you ever decide to rearrange your sections or add more information, you’ll have to update everything all over again. However, with the right formatting, Word can create and update a table of contents automatically.

We’ll use Word 2013 to show you how to create a table of contents, but you can use the exact same method in Word 2010 or Word 2007.

Ever looked at your list of tasks wondering what to do first? Well, you are not alone.

The Italian economist Vilfredo Pareto (1848–1923) suggested that the results and the causes of those results are unequally distributed in the ratio of 80:20. The Pareto Principle, more commonly referred as the 80/20 Rule, states that:

20% of your activities will generate 80% of your success, or

20% of a well time managed effort will generate 80% of the desired results.

Although the ratio 80/20 is not always this precise, it is used to put emphasis on how much is lost or how much can be gained with time management. It is not a surprise that identifying the critical 20% is the key factor to success.

A simple Time Management course can certainly help you to learn some tips and tricks and teach you using yourtime efficiently. But what can we do NOW to minimise our time wastage?

The key in identifying those critical 20% is by prioritising your tasks. You may use the Eisenhower Method to help you with that. It said that former U.S. President Dwight Eisenhower used this method in prioritising his daily tasks.

To determine your priorities you will need to use a matrix, where you evaluate each task according to its Importance and Urgency. If you use this matrix then you will need to focus on Important tasks. If your tasks are:

Important and Urgent, then do them immediately

Important but Not Urgent, then enter them into your calendar to keep track of them

Urgent and Not Important, then delegate them to a competent person

Not Urgent and Not Important are time wasters, so minimise them

This is common sense but you would be surprised how much this method will positively affect your productivity. For more info, read our future blog articles, or come to our Effective Time Management Courses.

Finding recent documents has been made easier in Office. Looking at PowerPoint 2007 and 2013 we will look at the differences between the ease of access.

When you need to find a certain document you needed to click Open from Office button then search through your documents looking for the right one. With Microsoft PowerPoint 2007 you can find everything much easier.

If you click on the Office button on the top left and it comes up with the main menu and on it will be your most recent documents that you have worked on and saved. So if you need to open up one of those documents again you can just click on it from that list and it’s done. So it saves you looking through your documents trying to find the right one.

This feature can also be done in Microsoft PowerPoint 2013. All you need to do is click Open from the File Tab and your Recent Presentations can be viewed straight away just like below. In PowerPoint 2013 you are able to see the first slide, making it easier to remember what presentation you want.

In August 2015, Microsoft released a brand new software called, Sway – an online package to create and share your amazing stories, presentations and more!

It is a part of the MicrosoftOffice Online package; similar to Excel, PowerPoint, and Word Online. Sway can be used to create presentation style websites which are great for for telling stories or documenting an event. So how about having a go and documenting your fantastic Christmas and making it a one that no one will forget.

In a nutshell, Sway is an updated version of PowerPoint that is more user friendly. At a glance its easy to follow and if you wish to import media into your project then you don’t even need to leave the app.

Sway is currently available on Windows 10 and IOS, However it must be a downloaded app. alternatively it can be accessed through Office Online.

With Christmas just around the corner most families like to document the celebrations by videoing the special occasion, but using Sway takes it to another level. You can upload videos, pictures, and add text to a family friendly user face and share it directly to social media like Facebook and Twitter.

After much extensive research on Twitter, we worked out that the most used hashtag for PowerPoint was #dosanddonts. It was apparent that a lot of people wanted advice on how to produce a great PowerPoint but didn’t know how to keep it interesting and not too full on at the same time. So here are our best suggestions.

#DONTS

Minimal might be fashionable, however, no one likes a boring presentation. Creating something interesting is key, so make sure you avoid something like this at all costs.

There is nothing worse than black and white for a PowerPoint. It’s important to use the right colours so that it is eye catching and bold. Imagine that every slide is a billboard advertisement. It’s also crucial that you pick the right fonts, design, and layout. No one can take Comic Sans seriously and Times New Roman is is old and boring.

There is nothing more annoying than something that is loud and in your face, so imagine reading a PowerPoint that had that effect. It can put a reader off instantly. Also, make sure that is doesn’t look childish. If it’s for business purposes, then it’s important to keep it looking professional and not look like a child has created it. Something that is definitely a big mistake, is writing too much information on one page so the audience has too much to read. Space your text out across multiple pages, let your PowerPoint ‘breathe’. Bullet points are great at creating easy reading.

#DOS

Its difficult to say what is a good PowerPoint presentation depending on what it is being used for, However, if it’s for profession business purposes then its easy to pick out what makes it look appealing.

It does look more visually appealing if the fonts are matching and there aren’t a lot of different styles. It can also help if the layout is simple and not to busy; you don’t want distract the audience from what you’re trying to promote. They say a picture is worth a thousand words, so grab the audience’s attention and say what you want with an image instead of lots of paragraphs.

We hope this Tip helped, for anymore questions for may have you can drop us a message on Facebook or Twitter.

Christmas is nearly upon us and we know how stressful it can be trying to budget and keep on track of finances. So here’s a helpful tip showing how you can use Microsoft Excel to plan ahead.

Using Excel create you Christmas List. The one below is from one of our staff:

Using “=SUM(D5:D11)” we have calculated the total cost that has been spent on the presents. With a small budget of £100 we can also calculate what’s left to spend.

Now using the Filter function in the Data tab we can see what has been bought for each person. This works great if you have many presents like Santa.

Now when you click the down arrow next to “Who for?” we get the options below.

Below we can see what happens when “Mum” and “Blanks” are selected. Excel counted our calculations as a default but this can be changed. Right next to the Filter button used earlier is a smaller “Advanced” button. In there you can define your range. (So Mum has 3 presents)