Group items tagged

ACCESS 2016: DESIGNING A SIMPLE QUERY MARCH 27, 2017 TRAINING / WWW.OFFICE.COM/SETUP ADMIN LEAVE A COMMENT WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: The real power of a relational database lies in its ability to quickly retrieve and analyze your data by running a query. Queries allow you to pull information from one or more tables based on a set of search conditions you define. In this lesson, you will learn how to create a simple one-table query. Throughout this tutorial, we will be using a sample database. If you would like to follow along, you'll need to download our Access 2016 sample database. You will need to have Access 2016 installed on your computer in order to open the example. Watch the video below to learn more about designing a simple query in Access. WHAT ARE QUERIES? Queries are a way of searching for and compiling data from one or more tables. Running a query is like asking a detailed question of your database. When you build a query in Access, you are defining specific search conditions to find exactly the data you want. HOW ARE QUERIES USED? Queries are far more powerful than the simple searches or filters you might use to find data within a table. This is because queries can draw their information from multiple tables. For example, while you could use a search in the customers table to find the name of one customer at your business or a filter on the orders table to view only orders placed within the past week, neither would let you view both customers and orders at once. However, you could easily run a query to find the name and phone number of every customer who's made a purchase within the past week. A well-designed query can give information you might not be able to find out just by examining the data in your tables. When you run a query, the results are presented to you in a table, but when you design one you use a different view. This is called Query Design view, and it lets you see how your query is put

www.office.com/setup Blogs: I've been installing Office 2013 on a lot of computers lately and I've ran into quite a few problems along the way. From annoying messages like "Sorry we ran into a problem" and "Something went wrong" to slow downloads, hanging at certain percentages during the install, it's been typical Microsoft problems all along the way. If you've been trying to install Office 2013 on Windows 8 or Windows 7 and you're running into issues, I'm going to try and give you as many possible solutions as I could find. If you run into a different issue not mentioned here, feel free to post a comment and let us know. It's also worth noting that you can't install Office 2013 on Windows Vista or Windows XP, it's just not possible. You'll get an error message like: This is not a valid Win32 application or We are sorry, you couldn't install your Office product because you don't have a modern Windows operating system. You need Microsoft windows 7 (or newer) to install this product or The procedure entry point K32GetProcessImageFileNameW could not be located in the dynamic link library KERNERL32.dll Now let's talk about some of the problems that can occur when installing Office 2013 on Windows 7 and Windows 8. FIX "SOMETHING WENT WRONG" OFFICE 2013 You might get this error if a first installation stalled and you ended up starting a second installation over the first one. You might also get this error if the computer restarted for some reason before the installation was finished. In this case, you should go to the Control Panel, click on Microsoft Office 2013 or Microsoft Office 365 and click on Change. Office 2013 change - www.office.com/setup Blogs Depending on your version of Office installed, you should either see an option called Repair or Online Repair. If you have Office 365, you'll see Online Repair and then the Repair option. Office 2013 repair - www.office.com/setup Blogs If, for some reason, this fails or

www.office.com/setup Blogs: All cell content uses the same formatting by default, which can make it difficult to read a workbook with a lot of information. Basic formatting can customize the look and feel of your workbook, allowing you to draw attention to specific sections and making your content easier to view and understand. Optional: Download our practice workbook. Watch the video below to learn more about formatting cells in Excel. TO CHANGE THE FONT SIZE: Select the cell(s) you want to modify. Selecting a cell - www.office.com/setup On the Home tab, click the drop-down arrow next to the Font Size command, then select the desired font size. In our example, we will choose 24 to make the text larger. Selecting a font size in the dropdown menu - www.office.com/setup The text will change to the selected font size. The selected cell is a larger font size now - www.office.com/setup You can also use the Increase Font Size and Decrease Font Size commands or enter a custom font size using your keyboard. The custom font box, increase font size button, and decrease font size button - www.office.com/setup TO CHANGE THE FONT: By default, the font of each new workbook is set to Calibri. However, Excel provides many other fonts you can use to customize your cell text. In the example below, we'll format our title cell to help distinguish it from the rest of the worksheet. Select the cell(s) you want to modify. Selecting a cell - www.office.com/setup On the Home tab, click the drop-down arrow next to the Font command, then select the desired font. In our example, we'll choose Century Gothic. Selecting a font in the dropdown menu - www.office.com/setup The text will change to the selected font. The selected cell is a different font now - www.office.com/setup When creating a workbook in the workplace, you'll want to select a font that is easy to read. Along with Calibri, standard reading fonts include Cambria, Times New Roman, and Arial. TO CHANGE THE FONT COLOR: Select

SmartArt allows you to communicate information with graphics instead of just using text. There are a variety of styles to choose from, which you can use to illustrate different types of ideas. Watch the video below to learn more about working with SmartArt. TO INSERT A SMARTART GRAPHIC: Select the slide where you want the SmartArt graphic to appear. From the Insert tab, select the SmartArt command in the Illustrations group. selecting the SmartArt command on the Insert tab - www.office.com/setup A dialog box will appear. Select a category on the left, choose the desired SmartArt graphic, then click OK. choosing a SmartArt graphic - www.office.com/setup The SmartArt graphic will appear on the current slide. the inserted smartart - www.office.com/setup You can also click the Insert a SmartArt Graphic command in a placeholder to add SmartArt. Inserting a SmartArt Graphic from a placeholder - www.office.com/setup TO ADD TEXT TO A SMARTART GRAPHIC: Select the SmartArt graphic. The text pane will appear to the left Enter text next to each bullet in the text pane. The text will appear in the corresponding shape. It will be resized automatically to fit inside the shape. adding text to the SmartArt graphic - www.office.com/setup You can also add text by clicking the desired shape and then typing. This works well if you only need to add text to a few shapes. However, for more complex SmartArt graphics, working in the text pane is often quicker and easier. adding text directly in the shapes of the SmartArt instead of the text pane - www.office.com/setup TO REORDER, ADD, AND DELETE SHAPES: It's easy to add new shapes, change their order, and even delete shapes from your SmartArt graphic. You can do all of this in the text pane, and it's a lot like creating an outline with a multilevel list. For more information on multilevel lists, you may want to review our Lists lesson. To demote a shape, select the desired bullet, then press the Tab key. The bullet will move to the

www.office.com/setup Blogs: Part 1: Add An Account Go to Microsoft Office 365 Admin Center. From the top menu, click Admin and select Office 365. www.office.com/setup Blogs From the left navigation, go to USERS > Active Users and then click the + button. www.office.com/setup Blogs Specify Delegate Account information, including a temporary password, and then click Create. www.office.com/setup Blogs Note: Licenses automatically assign to the account. Unassign the license (9) because the Delegate Account does not require a license. Record the Delegate Account credentials (username and password). These credentials are also sent to the email address specified in the previous page. www.office.com/setup Blogs Click Close. Click the Delegate Account display name to configure additional settings. www.office.com/setup Blogs From the left navigation, click settings and then assign the Delegate Account the Service administrator role and specify an Alternate email address. www.office.com/setup Blogs Part 2: Assign Specialized Roles To The Delegate Account From the upper right corner of the screen, choose Admin > Exchange to open the Exchange Admin Center. www.office.com/setup Blogs Click permissions and then the + button to create a New Role Group. www.office.com/setup Blogs Type delegation_service as the name of the new role group. www.office.com/setup Blogs Under Roles, click the + button. www.office.com/setup Blogs Add the ApplicationImpersonation and Mailbox Search roles. www.office.com/setup Blogs Under Members, click the + button. www.office.com/setup Blogs Add the newly created Delegate Account. www.office.com/setup Blogs Click Save. Office 365 updates the organization settings. www.office.com/setup Blogs Sign out of Microsoft Office 365. Part 3: Change The Delegate Account Password Sign in to Microsoft Office 365 using the new Delegate Account credentials. www.office.com/setup Blogs Change the temporary Delegate Account password to a permanent one. www.office.com/se

www.office.com/setup Blogs: Indenting text adds structure to your document by allowing you to separate information. Whether you'd like to move a single line or an entire paragraph, you can use the tab selector and the horizontal ruler to set tabs and indents. Optional: Download our practice document. Watch the video below to learn more about how to use indents and tabs in Word. INDENTING TEXT In many types of documents, you may want to indent only the first line of each paragraph. This helps to visually separate paragraphs from one another. - www.office.com/setup It's also possible to indent every line except for the first line, which is known as a hanging indent. - www.office.com/setup TO INDENT USING THE TAB KEY A quick way to indent is to use the Tab key. This will create a first-line indent of 1/2 inch. Place the insertion point at the very beginning of the paragraph you want to indent. - www.office.com/setup Press the Tab key. On the Ruler, you should see the first-line indent marker move to the right by 1/2 inch. The first line of the paragraph will be indented. - www.office.com/setup If you can't see the Ruler, select the View tab, then click the check box next to the Ruler. - www.office.com/setup INDENT MARKERS In some cases, you may want to have more control over indents. Word provides indent markers that allow you to indent paragraphs to the location you want. - www.office.com/setup The indent markers are located to the left of the horizontal ruler, and they provide several indenting options: First-line indent marker adjusts the first-line indent Hanging indent marker adjusts the hanging indent Left indent marker moves both the first-line indent and hanging indent markers at the same time (this will indent all lines in a paragraph) TO INDENT USING THE INDENT MARKERS Place the insertion point anywhere in the paragraph you want to indent, or select one or more paragraphs. - www.office.com/setup Click and drag the desired indent marke

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Indenting text adds structure to your document by allowing you to separate information. Whether you'd like to move a single line or an entire paragraph, you can use the tab selector and the horizontal ruler to set tabs and indents. Optional: Download our practice document. Watch the video below to learn more about how to use indents and tabs in Word. INDENTING TEXT In many types of documents, you may want to indent only the first line of each paragraph. This helps to visually separate paragraphs from one another. - www.office.com/setup It's also possible to indent every line except for the first line, which is known as a hanging indent. - www.office.com/setup TO INDENT USING THE TAB KEY A quick way to indent is to use the Tab key. This will create a first-line indent of 1/2 inch. Place the insertion point at the very beginning of the paragraph you want to indent. - www.office.com/setup Press the Tab key. On the Ruler, you should see the first-line indent marker move to the right by 1/2 inch. The first line of the paragraph will be indented. - www.office.com/setup If you can't see the Ruler, select the View tab, then click the check box next to the Ruler. - www.office.com/setup INDENT MARKERS In some cases, you may want to have more control over indents. Word provides indent markers that allow you to indent paragraphs to the location you want. - www.office.com/setup The indent markers are located to the left of the horizontal ruler, and they provide several indenting options: First-line indent marker adjusts the first-line indent Hanging indent marker adjusts the hanging indent Left indent marker moves both the first-line indent and hanging indent markers at the same time (this will indent all lines in a paragraph) TO INDENT USING THE INDENT MARKERS Place the insertion point anywhere in the paragraph you want to indent, or select one or more paragraphs. - www.office.com/set

Sometimes there is frantic need to create links in database table to web pages, files, folders, images, etc. Access 2010 provides a convenient way to link up data field values with anything to complement the database in much better way. In this post we will guide you on creating a table field having Hyperlink data type. To start off with, launch Access 2010 and navigate to Create tab and click Table. createtable1 Create Hyperlink Field In Access 2010 - www.office.com/setup It will create a new table namely Table1. Right-click newly created table and select Design View to add fields with specific Data types. table11 Create Hyperlink Field In Access 2010 - www.office.com/setup Enter an appropriate table name and start adding fields. We will be entering some generic table fields with their data types such as, ID, Name, Phone Number, Email and other Links. design view - www.office.com/setup Select Email table field and under data type options, select Hyperlink. select hyperlink - www.office.com/setup Repeat the procedure for assigning Hyperlink data field for other fields as well. hyperlink other - www.office.com/setup Now close the Design view and save the changes made. Open the database table in Datasheet view. Start filling out table fields with values. In Hyperlink assigned data fields, you will notice that on entering values it will automatically turns them into blue, indicating linked data. hyerplinks created - www.office.com/setup Now we will move to editing Hyperlinks. In Email field, highlight the email address and right-click to select Edit Hyperlink. edit hyperlink - www.office.com/setup It will instantly open Edit Hyperlink dialog. Under E-mail address box, enter the email address, and from Subject box, write the subject of the mail. Click OK. edit hyperlink 1] - www.office.com/setup Upon clicking on hyperlink, it will immediately open Outlook mail compose window, with specified email address and subject inserted. email open - www.office.co

www.office.com/setup Blogs: Forgetting a password to your office folder can be annoying. Halting the work because of the password loss may cause immediate monetary loss. Then how to control over your own documents even if there are protected with a password. Office Password Recovery recovers and removes instantly passwords protecting or locking files created with Microsoft Office 2016. Actually it can unlock documents created with all versions of Microsoft Office from the ancient 97 to the latest 2016, and supports recovering passwords for Microsoft Word, Excel, Access, Outlook, PowerPoint, Money and all OpenOffice applications and Hangual Office suite. HOW TO RECOVER THE MICROSOFT OFFICE PASSWORD 2016 WITHIN 3 STEPS? Office Password Recovery is the most professional and powerful office documents password recovery software. Before you start, you have to make sure you have downloaded and installed it on your computer. Then you can easily crack and remove MS Office 2016 passwords. Step1. Run the program and click "Office Password Recovery". Then click "browse" in the main window to import protected Office files. click browse to import office files - www.office.com/setup Step2. Here are 3 types of attack available. Choose anyone from them in accordance with your real situation. 1. Brute-force Attack: If you can remember nothing about your password at all. It will try all possibilities to find your password. It is the default for password recovery. 2. Brute-force with Mask Attack: If you can remember anything about password such as customize number, symbols or characters. You can try this way to find your password. Click "Settings" to define the sets such as Min Length, Max Length, Character Set etc. 3. Dictionary Attack: If you have a dictionary already that is a text file listing character combinations such as a, ab, 123, 4, AB etc. Click "Settings" to use the default dictionary to recover. choose attack type - www.office.com/setup Step3. Finally, click "Recov

www.office.com/setup Blogs: The next step after signing up and configuring your domain, for Office 365, is to start adding some users. Keep in mind that this is for a new install with no user migration. If you are migrating from Exchange 2003, 2007 or 2010, then please skip to those posts as they will create users as part of the migration process. Open Internet Explorer Login to the Office 365 Admin Portal Click Users and Groups www.office.com/setup This will take you to the user administration page. Here you will be able to add, delete, restore and view all cloud users and groups for Office 365 Click the + (add) button www.office.com/setup Blogs Fill out the basic details for the user www.office.com/setup If you have multiple domains added to your Office 365 account, then you can use the drop down and change the domain to the one you want to use. Click Additional details and complete as needed or wanted Click Next Assign an Administrator role to the new user, if required Review the roles here Choose a location for the user, required www.office.com/setup Click Next Assign a license to the user www.office.com/setup Click Next Chose an administrator to receive the setup email, if not required uncheck. Click create www.office.com/setup Blogs Office 365 will create the user account and kick of the provisioning process for the Exchange and Lync accounts. You will also be given a temporary password for the user account. You will be asked to change this password on first login with that account. Click Finish

www.office.com/setup Blogs: Microsoft Word is an essential tool for any individual in today's digital age. Whether you are a working professional, a diligent student or an active retiree, proficiency in Microsoft Word is a vital skill1 that is useful for both complex business requirements as well as basic day-to-day purposes. Not only is Microsoft Word a flexible tool that allows you to achieve many of your digital document needs, it is also one of the most user- friendly applications from the Microsoft Office suite. Below are 10 MS Word features that you should be using at work, school or home but likely aren't. 1. SMART ART The Office 2007 and Office 2010 applications share very similar features for working with a range of graphics including pictures, Clip Art, Shapes, diagrams and Charts. It's easy to confuse SmartArt with the similarly named WordArt. Where WordArt just allows you to display text using a wide variety of different formats and effects, SmartArt is a comprehensive and flexible business diagram tool that greatly improves upon the 'Diagram Gallery' feature found in previous versions of Office. Smart Art screen shot 2 - www.office.com/setup The great thing about SmartArt is the ability to swap between different diagrams, even diagrams from other categories, without losing the information that you have already entered. From the selection available, use whichever SmartArt is appropriate to give your document that little bit extra charm. 2. TURN DATA INTO VISUAL CHARTS Charts are created using the same chart 'engine' that Excel uses. Accordingly, as your chart is created, another window will appear containing the Excel-generated data that the chart is based on. Use the Insert Chart button in the Illustrations group to insert a chart and select from the variety of options. The charts are versatile, just like the user-friendly data represented separately in MS Excel to smooth out the whole data-input-to-graph process. Visual Charts -

www.office.com/setup Blogs: Forgetting a password to your office folder can be annoying. Halting the work because of the password loss may cause immediate monetary loss. Then how to control over your own documents even if there are protected with a password. Office Password Recovery recovers and removes instantly passwords protecting or locking files created with Microsoft Office 2016. Actually it can unlock documents created with all versions of Microsoft Office from the ancient 97 to the latest 2016, and supports recovering passwords for Microsoft Word, Excel, Access, Outlook, PowerPoint, Money and all OpenOffice applications and Hangual Office suite. HOW TO RECOVER THE MICROSOFT OFFICE PASSWORD 2016 WITHIN 3 STEPS? Office Password Recovery is the most professional and powerful office documents password recovery software. Before you start, you have to make sure you have downloaded and installed it on your computer. Then you can easily crack and remove MS Office 2016 passwords. Step1. Run the program and click "Office Password Recovery". Then click "browse" in the main window to import protected Office files. click browse to import office files - www.office.com/setup Step2. Here are 3 types of attack available. Choose anyone from them in accordance with your real situation. 1. Brute-force Attack: If you can remember nothing about your password at all. It will try all possibilities to find your password. It is the default for password recovery. 2. Brute-force with Mask Attack: If you can remember anything about password such as customize number, symbols or characters. You can try this way to find your password. Click "Settings" to define the sets such as Min Length, Max Length, Character Set etc. 3. Dictionary Attack: If you have a dictionary already that is a text file listing character combinations such as a, ab, 123, 4, AB etc. Click "Settings" to use the default dictionary to recover. choose attack type - www.office.com/setup Step3. Finally, click "Recov

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: If you're new to PowerPoint, you'll need to learn the basics of working with text. In this lesson, you'll learn how to cut, copy, paste, and format text. Optional: Download our practice presentation. Watch the video below to learn more about the basics of working with text in PowerPoint. TO SELECT TEXT: Before you can move or arrange text, you'll need to select it. Click next to the text you want to select, drag the mouse over the text, then release your mouse. The text will be selected. www.office.com/setup Blogs COPYING AND MOVING TEXT PowerPoint allows you to copy text that is already on a slide and paste it elsewhere, which can save you time. If you want to move text, you can cut and paste or drag and drop the text. TO COPY AND PASTE TEXT: Select the text you want to copy, then click the Copy command on the Home tab. www.office.com/setup Blogs Place the insertion point where you want the text to appear. Click the Paste command on the Home tab. www.office.com/setup Blogs The copied text will appear. TO CUT AND PASTE TEXT: Select the text you want to move, then click the Cut command. www.office.com/setup Blogs Place the insertion point where you want the text to appear, then click the Paste command. www.office.com/setup Blogs The text will appear in the new location. You can access the cut, copy, and paste commands by using keyboard shortcuts. Press Ctrl+X to cut, Ctrl+C to copy, and Ctrl+V to paste. TO DRAG AND DROP TEXT: Select the text you want to move, then click and drag the text to the desired location. www.office.com/setup Blogs The text will appear in the new location. www.office.com/setup Blogs FORMATTING AND ALIGNING TEXT Formatted text can draw your audience's attention to specific parts of a presentation and emphasize important information. In PowerPoint, you have several options for adjusting your text, including size and color. You can also adjust the alignment of the

www.office.com/setup Blogs: Last year, we released Microsoft Bookings to customers in the U.S. and Canada, introducing an easy way for small businesses to schedule and manage appointments with their customers. Today, we are pleased to announce that we're beginning to roll out the service to Office 365 Business Premium subscribers worldwide. Based on your feedback, we are bringing several new features to Bookings: Add your Office 365 calendar to Bookings-Connect your Office 365 calendar to Bookings, so that the times you are busy will automatically be blocked in your public Booking page. Add buffer time before and after your appointments-Do you need prep time before or after an appointment? Adding buffer time to a service automatically blocks that time in your Booking page too. Bookings apps for your iOS and Android phone-Now you can book an appointment, contact a customer or check a staff member's appointments while away from the office. Customize your Booking page-We added more color customization options, so you can better personalize your Booking page. These new capabilities will start showing up automatically in Bookings in the coming weeks. Let's take a detailed look at what's new. ADD YOUR OFFICE 365 CALENDAR TO BOOKINGS One of the top pieces of feedback we've heard is that you want to be able to add events from your Office 365 calendar to Bookings. So, we added integration between these calendars to help you avoid booking customer meetings during the time you've set aside for personal appointments, staff and partner meetings or other aspects of running your business. To add Office 365 calendars to Bookings, click the Staff tab on the left navigation panel. On the Staff details page, select the Events on Office 365 calendar affect availability checkbox. www.office.com/setup Add Office 365 calendar events to Bookings. Once you activate this option, the system automatically blocks busy times on the Bookings calendar and on the self-ser

The new Excel offers a rich set of charting capabilities that make creating and customizing charts simpler and more intuitive. One part of the fluid new experience is the Formatting Task pane. - www.office.com/setup Until now, precise adjustments to chart elements were made in the Format dialog box. The box sometimes obscured a portion of the chart, changes entered in the box were not visible until you closed it, and you had to select the exact element on the chart in order to see the options that were the best fit for the job. In the new Excel, the Format dialog box is replaced by the Formatting Task pane. The pane aligns neatly with the right or left side of the screen, so it's less likely to obscure the chart, and changes happen in real time, so you can immediately see how your choices affect the chart. The Formatting Task pane also offers an element selector so you can jump quickly between different elements without having to select one to modify. The new Formatting Task pane is the single source for formatting-all of the different styling options are consolidated in one place. With this single task pane, you can modify not only charts, but also shapes and text in Excel. USING THE FORMATTING TASK PANE The fastest way to open the Formatting Task pane is to double-click a chart element. You can also use the keyboard shortcut CTRL+1 while a chart element is selected. There are two other ways to open the task pane: The first way: On a chart, select an element. On the Ribbon, select the Chart Tools Format tab, then click Format Selection. - www.office.com/setup The second way: On a chart, select an element. Right-click, then select Format where is the axis, series, legend, title, or area that was selected. - www.office.com/setup Once open, the Formatting Task pane remains available until you close it. Since it always stays on the right or left side of the screen, the pane remains unobtrusive as you concentrate on other tasks. The