What are the different products within Microsoft Office Suite and how are they used?
The different products within the Microsoft Office Suite are Word, Excel, Powerpoint, Access, and Outlook. Word is used to create documents for school papers, meeting agendas, and can even be made into more complicated things like envelope labels or forms. Excel is a spreadsheet tool that can be used for many things such as storing data or analyzing data. Powerpoint is used to create slideshows and presentations. Access is a database tool used to store large amounts of data within tables, and analyze that data using queries and reports. You can also add forms to simplify data entry for your user(s). Outlook is an email/calendar service used to send and receive emails through a server, as well as organize them. You can also create calendar events and reminders.
You have a table of raw data and you want to make it into a pivot table. Explain how you would do so.
Open the spreadsheet containing the data. Under the Insert tab in the Tables group, click on PivotTable (far left). It should discern the range, but if it doesn't, click in the blank Table/Range: box and manually select or type in your range of data. We're going to put the pivot table into a new worksheet within the workbook, so leave the rest of the options in the message box as is and click OK. On the right-hand side, you'll see the PivotTable Fields box with all the fields from the data range you selected. You can add these data points to either a column, row, value, or filter to analyze it in different ways. To add fields to your column, simply drag the field from the top and place into the Columns section. You can move them around to the different sections as you wish to see how the pivot table will change. If you want to use a count or a sum of a field, place the field into the values box, click the drop-down button on that field once it's in the values field, then click Value Field Settings. This will allow you to choose whether you want a Sum, Count, Average, etc. We'll leave it in the default setting and click OK.
Describe the steps you would take to create a new database in Microsoft Access and then design the first table.
When you first open Microsoft Access, you will be shown choices for different database templates. For this assignment, choose "Blank database", which should be the first option, and double-click to open. Your database will already have a blank table started for you. Right click on the tab at the top of the table that says "Table1" and selects "Design View." It will ask you to name your table. You can leave as Table1, or name it something else. Click OK. For this table, our primary key will simply be an auto number, meaning that the database will automatically generate the number for you starting with 1 so that each record in the table will have a unique ID. You can add fields as necessary in Design View, such as FirstName, LastName, etc, and then choose the corresponding data type. For example, if you want to have a date field, you could name it "DateCreated" and then choose a data type of Date/Time from the Data Type drop-down menu. If you want to add any notes or a description to any of the fields to help you remember what they're for, you can add a description (which will not be visible in the table view. Once you have added your fields, right click on the tab at the top where the table name is and select Datasheet view. It will ask you to save your table if you have not yet done so. You can now start adding data to your table in the Datasheet view. To save a record, simply move off the row of the current record, or right-click the tab at the top of the table and click Save. You will know if a record has not yet been saved if there is a little pencil on the left-hand border of the table.