OBT 134 - MS Excel and Access I

1. Create, enter, and edit data in spreadsheets.
2. Format worksheets in a uniform, attractive style.
3. Write formulas using mathematical operators and absolute and mixed cell references.
4. Find numerical solutions using common mathematical, statistical, financial, date and time, and logical functions.
5. Create, modify, and format charts. 
6. Create diagrams and use other graphical devices to add visual interest to worksheets. 
7. Manage multiple Excel worksheets. 
8. Create and modify database tables to organize business or personal records.
9. Modify and manage database tables to ensure that data is accurate and up to date.
10. Create relationships between Access tables.
11. Design queries to extract data needed for reporting or decision making.
12. Design forms and reports to meet communication needs.
13. Manage the electronic storage of files. 
14. Analyze workplace scenarios requiring number-based solutions or the analysis and reporting of data and apply appropriate strategies to arrive at solutions using Excel and Access.

1. Microsoft Excel: Worksheet creation and editing.
2. Microsoft Excel: Formatting techniques.
3. Microsoft Excel: Formula-writing concepts.
4. Microsoft Excel: Common Excel functions.
5. Microsoft Excel: Chart creation and modification.
6. Microsoft Excel: Graphic enhancements.
7. Microsoft Excel: Basic workbook management techniques.
8. Microsoft Access: Relational database concepts.
9. Microsoft Access: Table design and creation.
10. Microsoft Access: Table relationships.
11. Microsoft Access: Data filtering and sorting.
12. Microsoft Access: Query design.
13. Microsoft Access: Basic form design.
14. Microsoft Access: Basic report design.