Looks like this event has already ended.
Check out upcoming events by this organizer, or organize your very own event.
Creating Solutions with Excel and Access 2007ThinkData Solutions, IncThursday, April 26, 2012 at 9:00 AM - Friday, April 27, 2012 at 4:00 PM (CDT)Birmingham, AL |
|
Event Details
creating solutions with Excel and access 2007
Course Description
The course introduces you to building solutions using the power of Excel 2010 and Access 2010 together to streamline processes.
COURSE OBJECTIVES
Upon completion of this course, the student will be able to:
· Perform calculations.
· Calculate and analyze data.
· Sort and filter data.
· Create, run, and edit macros.
· Create queries.
· Generate reports.
Lesson 1 – Working with Data Analysis
· What If Analysis?
· Scenarios
· Goal Seek
Lesson 2 – Calculating Data with Advanced Formulas
· Basic Formulas
· Built In Functions
· Copy Formulas and Functions
· Date Functions
· Text Functions
· Vlookup
· Absolute/Relative Referencing
· IF Function
· ISNA Function
· Remove Duplicates
Lesson 3 – Sort and Filter Data
· Sort Data
· Filter Data
· Clear Filters
· Subtotal Data
· Expand and Collapse Subtotals
Lesson 4 – Streamlining Workflow
· Set the Default Options for Excel
· Data Validation
· Create a drop down from a list
· Work with Conditional Formats
· Control Conditional Formats by Managing the Rules
· Create a Macro
· Edit a Macro
· Adjust Macro Settings
· Hide the results of macros while it runs
Lesson 5 – Querying a Database
· Create a Query
· Add Criteria to a Query
· Filter Records
· Add a Calculated Field to a Query
Lesson 6 – Joining Tables
· Relate Data within a Table
· Join Unrelated Tables
Lesson 7 – Creating Flexible Queries
· Set Select Query Properties
· Create Parameter Queries
· Create Append Queries
· Create Update Queries
Lesson 8 – Writing Advanced Queries
· Create Subqueries
· Create Duplicate Queries and Unmatched Queries
Lesson 9 – Generating Reports
· View an Access Report
· Create a Report
· Format the Controls in a Report
· Add a Custom Calculated Field to a Report
· Apply an AutoFormat to a Report
· Prepare a Report for Print
Lesson 10 – Simplifying Tasks with Macros
· Create a Macro with the Command Button Wizard
· Create a Macro from Scratch
· Attach a Macro
When & Where
ThinkData Lab
1500 1st Ave N
Ste E112
Birmingham,
AL 35203
Thursday, April 26, 2012 at 9:00 AM - Friday, April 27, 2012 at 4:00 PM (CDT)
Add to my calendar
Organizer
ThinkData Solutions, Inc
At ThinkData Solutions, our name says it all. We thoughtfully provide a wide variety of solutions to data and technology related challenges.
While every solution designed by ThinkData is customized to meet specific needs, we divide our services into three main categories: Training, Development, Consulting.
Training: Utilizing our technology lab at Innovation Depot and our full mobile training lab, we host a wide variety of technology training classes. Our training expertise ranges from productivity tools such as Microsoft Office to complex and integrated business systems. Whether the training is for an individual or several hundred employees in multiple locations, we customize our training to fit both your needs, and your budget. In addition to training classes held in our technology lab in the Innovation Depot, our team is also available for on-site training at your business.
Consulting: Through our corporate consulting services, we help companies stay ahead of technology trends to ensure employees can skillfully utilize the tools at their disposal. All engagements are different. For example, we have provided consulting from customized human resource skills tests and competency assessments to technology purchase evaluations and budget planning. If your company is looking bridge the gap between technology and success, we can provide options to maximize technology investments by designing a custom program to achieve your goals.
Development: In addition to training and consulting, the team at ThinkData is fully equipped to manage custom development projects. Our team is comprised of top-level programmers versed in multiple programming languages. From database development to custom software applications, we can build the tools your company needs to succeed. As experts in rapid custom development of web-based, distributed and standalone applications, we can quickly and efficiently meet your specific requirements and business needs. At ThinkData, programming is our passion.