$595

Microsoft Access 2016/2013 Level 2 Training in Portland, Oregon

Event Information

Share this event

Date and Time

Location

Location

Kinetic Technology Solutions

15495 SW Sequoia Parkway

Suite 100

Portland, OR 97224

View Map

Friends Who Are Going
Event description

Description

This 2-day, hands-on, instructor-led course will be held in our brand new, expanded, computer training facility in Portland, Oregon.

In this course, you will learn advanced techniques for designing tables and working with queries, and you will also create basic forms. First, you will learn how to make modifications to the design of a table, including setting data entry restrictions. Then, you will review the three types of table relationships: One-to-Many, Many-to-Many, and One-to-One. You will then learn how to enhance these relationships to provide automatic data updates and deletes. You will learn how to approach the task of designing a system of related tables by learning the formal rules of table design. These rules (called Normal Forms) must be applied in order to create well-designed tables. You will use query wizards to find erroneous data. You will also import and export data into and out of an Access database. Additionally, you will learn how to use Action queries to modify data on a mass scale. You will also split one table into several tables to fix data duplication problems. You will use functions to perform advanced calculations in queries. You will create basic a form to add and edit data in a table. Finally, you will begin to develop user-friendly forms by adding dropdown lists (combo boxes), radio buttons (option groups), tabs, and calculations. Prerequisite Course: Access Level 1.

Feedback from our Clients

an employee from The Standard wrote:
I now feel more comfortable navigating, repairing, modifying, updating, etc. an existing database created by my predecessor at work.

an employee from Johnstone Supply wrote:
I will now be able to create queries much faster. Before, I spent a lot of time reading help documentation to do the simplest things. Now I can move right on to making the queries I need.

an employee from City of Portland wrote:
I appreciate that the class is extremely hands-on and the accompanying training manual is an excellent resource.

FAQs

What are my transportation/parking options for getting to and from the event?

Kinetic is located just off I-5's Carman Drive exit in SW Portland, a 10 minute drive from downtown. FREE parking. Go to kinetictraining.com/customer_resources/locations.asp for driving instructions and a map of the area.

What can I bring into the event?

You do not need to bring anything. Computers are provided in the classroom as well as participant course manuals.

When should I arrvive, what can I expect the day of class, are there refreshments?

Please arrive approximately 15 minutes prior to class to check in and get situated in your classroom. Starbucks coffee, tea, juice and sodas will be available throughout the day. Snacks will be provided before class and at breaks. Restaurant maps are available to help you plan your lunch break. If you prefer to bring your lunch, a refrigerator is available as well as a place to eat and relax. Dress is casual and comfortable to allow for the optimum learning environment. Please bring a jacket or sweater as room temperatures may vary.

How can I contact the organizer with any questions?

Please call 503.520.0555 or email Register@KineticTraining.com with any questions. Additional information about our course offerings is also available on our website, KineticTraining.com

Share with friends

Date and Time

Location

Kinetic Technology Solutions

15495 SW Sequoia Parkway

Suite 100

Portland, OR 97224

View Map

Save This Event

Event Saved