Microsoft Excel and Access is a course designed to teach students how to successfully operate data management software and apply the software to real life situations. I had used Microsoft Excel in the past but had never used Microsoft Access, so I learned a lot about these programs. Microsoft Excel and Access both organize large quantities of data, so it was interesting to see the differences in their uses and functions. This course was self guided and revolved around independent learning, so it helped me learn how to manage my time and set priorities.
I received this certificate from Microsoft after completing the certifications for Word, Excel, PowerPoint, and Access.
Microsoft Access is a database program that organizes and stores large quantities of information so the user can create relationships between corresponding information. The screenshot shown above is an example of a navigation form in Design View. A form allows users to enter information. This type of form allows users to easily switch between different forms. Design View lets users edit the structure and appearance of the form. While using Microsoft Access, I learned how surveys and other information are stored and organized for analysis. If I were to use Microsoft Access again, I would like to make my own database with information about different clubs at school.
Microsoft Excel is a spreadsheet program designed to store and organize lots of data and make quick calculations about the data. The screenshot shown above is an example of a worksheet of data. There are columns for categories of information and rows for a specific set of data. By using Microsoft Excel, I learned how to input, store, and organize data as well as how to create formulas to analyze the data. If I used Microsoft Excel again, I would like to input data for all swimmers on my swim teams to determine the collective average times for each event.