Group items tagged

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Microsoft Access is a database creation and management program. To understand Access, you must first understand databases. In this lesson, you will learn about databases and how they are used. You will familiarize yourself with the differences between data management in Microsoft Access and Microsoft Excel. Finally, you will get a look ahead at the rest of the Access tutorial. Watch the video below to learn more about databases in Access. WHAT IS A DATABASE? A database is a collection of data that is stored in a computer system. Databases allow their users to enter, access, and analyze their data quickly and easily. They're such a useful tool that you see them all the time. Ever waited while a doctor's receptionist entered your personal information into a computer, or watched a store employee use a computer to see whether an item was in stock? If so, then you've seen a database in action. The easiest way to understand a database is to think of it as a collection of lists. Think about one of the databases we mentioned above: the database of patient information at a doctor's office. What lists are contained in a database like this? To start with, there's a list of patients' names. Then there's a list of past appointments, a list with medical history for each patient, a list of contact information, and so on. This is true of all databases, from the simplest to the most complex. For instance, if you like to bake you might decide to keep a database containing the types of cookies you know how to make and the friends you give these cookies to. This is one of the simplest databases imaginable. It contains two lists: a list of your friends, and a list of cookies. An illustration of two lists - www.office.com/setup However, if you were a professional baker, you would have many more lists to keep track of: a list of customers, a list of products sold, a list of prices, a list of orders, and so on.

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: If you need to share information from your database with someone but don't want that person actually working with your database, consider creating a report. Reports allow you to organize and present your data in a reader-friendly, visually appealing format. Access makes it easy to create and customize a report using data from any query or table in your database. In this lesson, you will learn how to create, modify, and print reports. 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 creating reports. TO CREATE A REPORT: Reports give you the ability to present components of your database in an easy-to-read, printable format. Access lets you create reports from both tables and queries. Open the table or query you want to use in your report. We want to print a list of cookies we've sold, so we'll open the Cookies Sold query. The Cookies Sold query - www.office.com/setup Select the Create tab on the Ribbon. Locate the Reports group, then click the Report command. Clicking the Report command - www.office.com/setup Access will create a new report based on your object. It's likely that some of your data will be located on the other side of the page break. To fix this, resize your fields. Simply select a field, then click and drag its edge until the field is the desired size. Repeat with additional fields until all of your fields fit. Resizing fields in the report - www.office.com/setup To save your report, click the Save command on the Quick Access Toolbar. When prompted, type a name for your report, then click OK. Saving and naming the report - www.office.com/setup Just like tables and queries, reports can be sorted and filtered. Simply right-click the field you w

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

The freshest organic and vegan cookies, brownies, salts and spices. Our products are sustainable, all natural, contain no additives and locally grown. We love to see what you create using our all natural sea salt and spice blends. From the very beginning we have been a green business, w/ no artificial ingredients, fresh & organic produce, dairy products, eggs, sweeteners, grains, flours & more. We have never used Styrofoam choosing instead, low waste packaging, recyclable & compostable materials, minimizing disposable products & we are committed to recycling and composting as much as we can. We continue to increase our organic profile & reduce our footprint each year.

Templates can be very helpful in providing the structure of online learning activities; however some templates can limit creativity and make presentations become very cookie-cutter and boring. Templates can also allow for the rapid creation of learning activities which enable timely development and revisions. If templates are easy to use and flexible; they facilitate the design of relevant, current, and creative activities.

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Access offers several advanced options for creating and modifying reports. The Report Wizard is a tool that guides you through the process of creating complex reports. Once you've created a report-whether through the Report Wizard or the Report command-you can then format it to make it look exactly how you want. In this lesson, you'll learn how to use the Report Wizard to create complex reports. You'll also learn how to use formatting options to format text, change report colors and fonts, and add a logo. 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 the Report Wizard in Access. THE REPORT WIZARD While using the Report command is a quick way to create reports from the current object, it's not as helpful if you want to create a report with data from multiple objects. The Report Wizard makes it easy to create reports using fields from multiple tables and queries. It even lets you choose how your data will be organized. TO CREATE A REPORT WITH THE REPORT WIZARD: Select the Create tab and locate the Reports group. Click the Report Wizard command. Clicking the Report Wizard command - www.office.com/setup Blogs The Report Wizard will appear. In the procedures below, we'll discuss the different pages in the Report Wizard. The Report Wizard dialog box - www.office.com/setup Blogs STEP 1: SELECT THE FIELDS TO INCLUDE IN YOUR REPORT Click the drop-down arrow to select the table or query that contains the desired field(s). Selecting a table that contains fields to include in the report - www.office.com/setup Blogs Select a field from the list on the left, and click the right arrow to add it to the report. Adding fields to a report - www.office.com/setup Blogs

WWW.OFFICE.COM/SETUP BLOGS: HAVE YOU EVER GOTTEN THIS ERROR MESSAGE? MICROSOFT TELLS YOU, "SORRY, SOMETHING WENT WRONG," BUT YOU DON'T KNOW THE BEST, MOST EFFECTIVE WAY TO TROUBLESHOOT THE PROBLEM. www.office.com/setup Blogs: great way to rescue your PC now We know this error can be frustrating. If you've gotten the "something went wrong" error during an Office 365/Office 2013 (or 2016) installation, we want to help! First, go to this Microsoft troubleshooting article and run the "Fix it" tool. This automated tool will take you through a process of uninstalling Office so you can re-install a clean version. Tip: we've seen the advice to NOT use Internet Explorer to run the tool, but rather another browser like Chrome or Firefox, so you can keep it running even when other Windows applications need to close. Be sure to select "Apply this fix" when offered. Once you're done running the Fix it tool, restart your computer and try re-installing Office. Often, this fix will suffice. If not, move on to alternate methods: Check your internet connection. Make sure you're not on a limited connection and your router's firmware is up to date (to do this, you may need to check with your router manufacturer). Clear your browser cookies & cache and reset Internet Explorer settings. Make sure you've removed older versions of Office. Uninstall earlier Office versions from the Control Panel, or visit this article for more help: How to uninstall Office 2003, Office 2007 or Office 2010 suites if you cannot uninstall it from Control Panel. Temporarily disable your antivirus software. Hopefully you're on your way with Office! But if these solutions don't work, you can find more detailed instructions in this Microsoft support article. If you still need help, post a topic on the Office 365 Community forum.