Chapter 2 Assessments Access

Assessment 1.)Create relationships in an insurance company database.Assessment 2.) Create a new table and relate the table.Assessment 3.) Delete and Edit records in tables Pic 1) Clients tablePic 2) Claims tableAssessment 4.) Display and edit records in a subdata sheet Pic 1) Clients tablePic 2) Coverage table

Chapter 1 Access Assessments

Assessment 1) Inserting and deleting rows and columns.Assessment 2) Create a departments table.Assessment 3) Create a benefits table.Assessment 4) Sort Data.  Pic 1 Sort data in employee table in ascending order by last name Pic 2 Sort data in benefits table in descending order by Life Insurance amounts.Today was my first experience with Access ever. I have never had anything to do with it I am not even sure I have heard of it before today. I am assuming people don’t do as much with it as Excel and Word because there are a lot of steps to it. Hopefully it gets easier as this was only Chapter 1 and my head is spinning lol. Ok the spinning might have more to do with the fact that I am not feeling good.

Excel Performance Assessment Unit 2

Assessment 1) Copy and paste data and insert word art in a training scores workbook.Assessment 2) Manage multiple worksheets in a projected earnings workbook. Pic 1 and 2 customized 2 sheets in the workbook Pic 3 and 4 Determined the effect on monthly earnings if the projected yearly income increased 20% Assessment 3) Create charts in worksheets in a sales totals workbook. Pic 1 and 2 Pic 3 Filtered the chart to only display 3 companiesAssessment 4) Create and format a line chartAssessment 5) Create and format a pie chartAssessment 6) Use the PMT function and apply formatting to a workbookAssessment 7) Use the IF function and apply formatting to a workbook. 2 pics because it would have printed 2 pages because the display of formula. Assessment 8) Insert a textbox and hyperlinks in a travel workbook. I really enjoyed doing this one.Assessment 9) Insert an image and a smartart graphic in a workbookAssessment 10) Insert a symbol, wordart, and screenshot in a sales workbookAssessment 11) Insert and format a shape in a budget workbookI am done with the book Excel 2013. I have enjoyed learning how to do all the things in Excel I never thought I would be able to figure out let alone know how to do.

Chapter 8 Assessments in Excel

Assessment 1) Insert a clip art image and word art in an equipment sales workbook.Assessment 2) Insert Formulas and Format a travel company workbookAssessment 3) Insert and format shapes in a company sales workbookAssessment 4) Insert and format a smart art graphic in a sales workbookAssessment 5) Create and insert a screenshot

Chapter 7 Assessments for Excel

Assessment 1) Create a net profit ChartAssessment 2) Create company sales  column chartAssessment 3) Create quarterly Domestic and foreign sales bar chart.Assessment 4) Create a fund allocations pie chart.Assessment 5) Write a formula with the PMT Function.Assessment 6) Write a formula with the FV Function Pic 1.Pic 2. Changes madeAssessment 7) Write a Formula with the IF Function Pic 1.Pic 2. Displayed Formulas in the worksheet.Assessment 8) Create a stacked Chart.

 

 

 

 

02/20/2015 I am not in school.

Today I will not be in school. Bailey and I both have a Eye Dr.  appointment. She has a regular eye dr appointment. I have to do all the yucky eye tests to see if the tumor is adding in more pressure on the optic nerve. I usually can’t drive for an hour or so after they do these tests the preferential(not sure on the spelling lol) tests they do for some reason mess with me.

Excel Chapter 6 Assessment

Assessment 1) Manage workbooks- There is no picture because I created new folders in the open dialog box and it didn’t say print anything. Assessment 2) Move and Copy worksheets  between Sales analysis workbooks. There are 4 pictures because I had to have a worksheet for each quarter. I like how I was able to input all the data from the first worksheet and never had to mess with the other 3 except to move them, and they all have different but relative data.Assessment 3) Define and apply styles to a projected Earnings workbook pic 1 Defining 3 different styles C06Heading, C06Subheading, and C06Column.Pic 2 Merging and Applying styles from workbook styles to the workbook project earnings.Pic 3 Modify 2 of the 3 stylesPic 4 Final ready to be printed after adding formulas, and defining, and applying and modified styles.Assessment 4) Insert Hyperlinks in a Bookstore WorkbookAssessment 5) Apply conditional formatting to a sales workbook Pic 1 Before I applied formattingPic 2 After I applied data bar formatting, and a header with my name, page number and Today’s date.

 

Thank you! Thank you!

I am so grateful for all the help sending my daughter to Church Camp. It means a lot that she wants to go and that a way is being provided for her. Today I finished working on Chapter 5 Assessments Assessment 2)  Copy, Paste, and Format worksheets in an income Statement workbook. 2 pics for January and FebruaryAssessment 3) Freeze and Unfreeze window panes in a test scores Workbook. Pic 1 split panes, and frozen window panesPic 2 Normal view after entering formulas and unfreezing the window panesAssessment 4) Create, Copy, paste and format cells in an equipment usage workbook.Assessment 5) Copying and Linking data in a word document Pic 1 Inserted paragraph into Word from ExcelPic 2 Applied accounting format to Row A4-A10 with no doller signsPic 3 Word updated from linked files in Excel.

02/17/2015

I worked through Chapter 5 and started the Assessments. I only got Assessment 1 done Copy and Paste between worksheets in a sales workbook.

OH No its Friday the 13th.

I finished the Assessment Questions in Unit 1 of Excel.Assessment 4) Format a Department Budget Pic 1 determined the projected budget with an increase of 10% over current budget. Pic 2 Increase of 5%.Assessment 5) Format weekly payroll workbook Assessment 6) Format Customer Analysis Workbook. 2 pics because it would had to print two pages.Assessment 7) Format Invoices Workbook Pic 1 Formatted Invoice pic 2 Filter on for client# 04-325 onlyPic 3 Filter on Service Development onlypic 4 Filter on for 3 highest totals Amount Due.