Tutor profile: Luis A.
Subject: Microsoft Suite
Excel or Access? Which Office Suite application should I use to create simple tables? For example: a list of office supplies; or a table of students and grades.
Excel. Creating a table in Excel is easy. Just type your table in the cells you want and voila! You have an instant table. With Access, you have to set up your table first before you can type in your data. It's more complex, but also more powerful than Excel when it comes to managing tables of data. Most office workers and students choose Excel to create simple tables. It may not be as powerful as Access when it comes to data management, but it's easy and good enough. Instant table!
Subject: Microsoft Excel
Excel has hundreds of features. Which Excel topics should a student focus on?
Just 4 things for beginning students: Basic Navigation and selection The two most important Excel topics are: a.) Formulas and Functions b.) Absolute versus Relative addressing If you understand those 2 concepts, you will have a solid foundation on how to use Excel properly. More advanced Excel features build on those concepts. They are at the heart of what a spreadsheet does.
Subject: Microsoft Access
What is a table? Please explain in the simplest terms possible.
A table is just a LIST. Like the contact list on your phone. Academics like using technical terms like "table", but it's really just a list. Other examples include: a list of customers, a list of products your business sells or "price list", or a list of employees. Technically, there is more to it than that; but when your teacher asks you to explain what a table is, just mention the word "list". Then give examples. Access lets you create lists (tables) to keep track of or manage your data. This is the simplest explanation that I have tested on non-technical students.
needs and Luis will reply soon.