Microsoft Access Training

Microsoft Access Training

  • Microsoft Access Training Level 1
  • Microsoft Access Training Level 2
  • Microsoft Access Training Level 3
  • Microsoft Access Training Level 4

In order to offer targeted training for our clients and a flexible schedule, our Microsoft Access training is available in both full day sessions and four-hour modules.

                                                                                                                  

Microsoft Access Level 1

Course Description:
Access provides a powerful set of tools that are sophisticated enough for professional developers, yet easy to learn for new users. Create or use powerful database solutions that make organizing, accessing, and sharing information easier than ever.

Module 1: Introduction to Access & Creating Tables

  • Introduction to database design concepts & terminology
  • Become familiar with the access interface: the Welcome Screen, Ribbon, Tabs & Tool-tips
  • Open and examine and existing Access database
  • Working with Tables and data records
  • Find, sort and filter records in a table
  • Create tables using the design view
  • Create tables with the Table Wizard
  • Introduction to table field properties

Module 2: Working with Relationships & Tables

  • Relational database design concepts
  • Create table relationships
  • Explore relationship types
  • Define referential integrity
  • Display object dependencies
  • How to “Normalize” databases
  • Additional table field properties
  • Create a lookup list

                                                                                                                  Microsoft Access Level 2

Course Description:
Access provides a powerful set of tools that are sophisticated enough for professional developers, yet easy to learn for new users. Create or use powerful database solutions that make organizing, accessing, and sharing information easier than ever.

Module 3: Queries

  • Create select queries
  • Use criteria to refine query results
  • Create multi-table queries
  • Create query joins
  • Implement query parameters
  • Performing calculations in a query

Module 4: Additional Queries, & Importing/Exporting Objects & Data

  • Create a totals queries
  • Create crosstab queries
  • Create Action Queries Import/export data
  • Linking tables from one database to another Use MS OfficeLinks
  • Overview of importing data from Microsoft Outlook
  • Overview of the collecting data via email feature

Prerequisites:
Microsoft Windows and Microsoft Access Modules 1 and 2, or similar experience.

Microsoft Access Level 3

Course Description:
Access provides a powerful set of tools that are sophisticated enough for professional developers, yet easy to learn for new users. Create or use powerful database solutions that make organizing, accessing, and sharing information easier than ever.

Module 5: Creating Forms

  • Creating an AutoForm
  • Using the Form Wizard to design new forms
  • Add and modify form controls
  • Work with control properties
  • Adding images and titles
  • Create calculated controls
  • Create forms in design view
  • Creating Forms with Sub-forms
  • Create tabbed forms

Module 6: Creating Reports

  • Using the Report Wizard to create new Reports
  • Modify report’s page setup settings
  • Modify report design and layout
  • Work with report sections
  • Create summary functions
  • Create reports in design view
  • Use the Mailing Labels Wizard

Prerequisites:
Microsoft Windows and Microsoft Access Modules 1 through 4, or similar experience.

                                                                                                                 Microsoft Access Level 4

Course Description:
Access provides a powerful set of tools that are sophisticated enough for professional developers, yet easy to learn for new users. Create or use powerful database solutions that make organizing, accessing, and sharing information easier than ever.

Module 7: Automating Access Databases

  • Create macros Implement and run macros
  • Event driven macros
  • Setting database startup options
  • Introduction to VBA concepts and terminology

Module 8: DB Maintenance and Deployment

  • Create switchboards
  • Discuss deploying
  • Access databases in a multi-user environment
  • Explore Microsoft Access security features
  • Compact and repair databases
  • Using hyperlinks in an Access database
  • Overview of Data Access Pages

Prerequisites:
Microsoft Windows and Microsoft Access Modules 1 through 6, or similar experience.

Course Cost:
$130 per module

Duration:
Each module is 4 hours in length.

In order to offer targeted training for our clients and a flexible schedule, our Microsoft Access training is available in both full day sessions and four-hour modules.

Dates:
These classes run frequently and are updated on a monthly basis. To get available dates that work best with your schedule, please contact us.

Location:
Workshops are held in San Francisco or may be attended remotely from your home or office. Logistic information will be sent with your confirmation.

       

Register-Online-Button Register-Phone-Button-1 Register-Fax-Button

 

LSA Public Classes can be customized and delivered onsite at your company. To speak with an LSA Global Expert about your customized onsite options, please contact us.

We turned to LSA Global to help us take our executive selling and solution selling skills to the next level, which will ultimately help our customers succeed. Their ability to formally assess our situation, identify key sales skill gaps, develop a plan to measure the results, and fully implement a key sales initiative – has been outstanding. LSA delivers the full solution; not just sales training and I would recommend them to any organization looking to transform its sales force the “right way” to sell higher and wider.

Daniel Heckman
Director of Sales-Enterprise Accounts

Avid

The LSA Organizational Alignment Survey gave us a comprehensive and poignant view of how our employees experience our culture, talent and strategy.  LSA customized the questions so we received information that was targeted and very useful to us.  Equally important, the survey and implementation process goes well beyond the typical engagement survey.  The combination of questions and feedback approach provided us with a great forum to discuss the strengths and opportunities in our organization, and then to quickly get focused on the key actions critical to our strategy implementation and improving our business results.

Mark Forrest
General Manager, FSM Division

Trimble

We selected LSA Global over 5 other companies to help some key executives improve their overall communication and executive presentation capabilities. Feedback has been great. Everyone had a great experience and many of them are feeding some of the lessons into their teams. I highly recommend LSA to any executive team looking to better organize and more effectively deliver key messages to C-Level individuals.

Todd Power
Office of the CEO

logo_SAP-gray

We turned to LSA Global to help take our Information Systems behavioral interviewing process to the next level in terms of both efficiency and effectiveness. LSA quickly understood our unique culture and requirements.  They immediately helped us to improve our ability to continue to hire top talent that fits our culture as we rapidly scale.

Julie Pearl
Technical Program Manager

Google

You have become our premier change leadership strategic partner. Your expertise in the human side of change is unparalleled and enabled our company to successfully implement our ERP Solution.

Ted Ramlet
CIO & SVP

McKesson

This was an extremely effective executive strategy session that helped our executive team efficiently navigate through our core objectives. It was exactly what we needed, and the approach was practical and valuable for our specific business and market. I would recommend LSA to anyone looking to push their strategic planning to the next level.

Blake Krikorian
CEO

Logo - Gray - Sling Media

We recently hired LSA to help us take our client delivery methodology to the next level as we continue to grow and help our clients succeed. The custom strategy and design session exceeded my expectations. They really understood our business and turned around the project within a tight timeframe. LSA’s consultants were the best I have seen for this type of project. LSA’s ability to get a group of 20+ executives from around the globe on the same page, push their thinking to new heights, and ensure an executable plan was excellent. I would recommend LSA to anyone looking to take their plans and execution to the next level.

Rob Sturgeon
EVP Client Delivery

Service Source

Having a training outsourcing partner like LSA to support our training and development needs has been a real benefit. In an emerging company where typically you can’t afford the infrastructure necessary to provide a full range of development venues to meet the broad needs of an organization, having an external partner who understands our business and our culture and offers everything from a wide range of open enrollment programs to customized organizational development consulting is almost as good (and in some cases better than) having your own internal Training and Organizational Development function.

Chris Wells
Vice President, HR and IT

Logo - Gray - Xoma

What a refreshing change from the half-baked psycho-babble you normally get from “training” organizations. LSA gives you the assistance you need to define and reach your goal, and then they give you a results driven plan – not just a temporary fix. They are great to work with, and even more importantly, they “get it!”

David Fiano
Vice President Human Resources

sonycomputer-large

Originally, we launched a RFP to identify and partner with a sales training provider to improve the skills of the sales teams in the distributor network. However, throughout the process, LSA Global challenged our thought processes and engaged with us by suggesting that we focus on the systemic factors that create a high performance environment first, before we focused on the more symptomatic needs of sales skills training. LSA Global has identified the two strategic moves that will enable us to create a high performance environment and we continue to seek their guidance on implementing those moves, as well as other key needs.

Kim Benson
Director Human Resources

Trimble

Gilead and LSA Global continue to build a mutually beneficial relationship. We have found LSA to be highly responsive to meeting our unique needs in learning and development. Their passion for high levels of customer satisfaction and quality align very closely with our core values.

Kudos to LSA Global for the program that they provided my team. It was exactly what I wanted, and your team did a great job of engaging our group and providing a solid introduction to key Project Management skill sets.

Laura McHugh
Director of Training and Organizational Development

Gilead

As a high growth digital marketing agency with cutting edge talent, we hired LSA Global to help clarify our strategy and work with our management team to implement it throughout the New York Office in a way that made sense for our unique culture . That work was so successful that we also hired them to coach one of our key leaders. LSA has been instrumental in helping us transition to a new leadership team and triple the revenue in our New York office. In this age of useless consultants, I highly recommend their practical and business-oriented approach to strategy, culture and talent.

David Bentley
General Manager

AKQA

We hired LSA to design and deliver a Project Post Mortem for 65 key people on a critical project with a very tight turnaround. LSA’s ability to identify the key trends, leverage points, and next steps was great. They really got to the heart of the issues in a constructive and unbiased manner that exceeded my expectations. It was not an easy task with so many skeptical people with different agendas, styles, experience, and perspectives.

Darrell Gallagher
Head of Studio

Crystal Dynamics

We reviewed the top Leadership Development offerings for one of our Senior Research Scientists and selected LSA’s 12 month Leadership Program based upon the value and systemic approach. The feedback on the program, approach, and results was phenomenal. While the other programs better known, they were more theoretical and did not compare in terms of practicality, quality, and results.

Stacey Porter
Senior Manager Learning and Development

Roche

It was a challenge to find a consultant with an approach to performance improvement that fit our unique culture and style. When we met with LSA we were surprised to discover their depth of expertise in the fields of motivation, developmental coaching and performance management and measurement.

Specifically, we were pleasantly surprised to find a company that could seamlessly integrate those three components without our folks feeling like the intervention was forced. They understood what we were trying to accomplish, helped us clarify our objectives, create a solid, refreshing approach that quickly got us moving and engaged people at all levels.

As they began to implement, I was thoroughly impressed with how they listened and made adaptations focused on our needs and business objectives. Overall, I couldn’t be happier that we found a partner in LSA.

Doug Hansen
President and Director

Redwood Trust

Evaluate your Performance

Toolkits

Toolkits

Download key published insights and tools from industry experts highlighting best practices in the areas of talent, strategy and culture.

More

Health Checks

Health Checks

Want to know how you stack up against leading organizations?  Receive a complimentary benchmarking analysis courtesy of an LSA Expert.

More

Whitepapers

Whitepapers

Get up to speed on timely solutions critical to your business. Published by LSA Experts based upon client feedback and key industry trends.

More

Methodology

Methodologies

First we identify the key metrics you want to improve. Then we assemble a dedicated team of elite experts who have successfully solved similar problems with similar clients.

More

icon_expert-blog

Blogs

Stay up to do date with the latest information on how we help high growth companies align their culture and talent with strategy.

More

Case Studies

Client Case Studies

Real world consulting and training approaches from LSA projects, providing insights on how your company can outperform the competition.

More