Training Classes | Learning and Development Resources | Training Directory | New Training Programs | New Training Providers | Site Map | Promote Training | Training Keywords | Training Programs | Training Providers | Regions | Training Search | Advertise Training Programs | Login
Provided by: AcademyX

Access (classroom training) in San Francisco at AcademyX

Click here for more information or to take this course
AcademyX


  home  : Computer  : Microsoft Office  : Access

Get More Information
Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by AcademyX

Access Introduction is taught by AcademyX, (www.academyx.com, 415-392-8024), the San Francisco's only Internet-focused, instructor-led training company in the Bay Area. This course is for the new user of Access and assumes no experience with relational databases. The topics cover the critical skills you need to get started creating databases in Access and working with the data by using tables, queries, forms, and reports.

Course Objective: You will practice the critical skills necessary to create a database and enter, find, edit, and report on the data it contains.

Training Avaliability and Delivery

This is primarily ilt training
instructor led trainingThis class may be available at a classroom in San Francisco, CA,
Contact AcademyX for more information
Course Level:introductory
Schedule:2 days
Training Presented in:English

Related Keywords:  access   microsoft access   access class   access course   access introduction class   access introduction course   macromedia access   access mx   access class   access training   access training san francisco   access class san francisco   access training bay area   access class bay area 

Training Program Details


Course Content
Lesson 1: Working with a Relational Database
Topic 1A: Identify Uses of a Relational Database
Topic 1B: Define Database Terminology
Topic 1C: Create a New Database Based on a Template
Topic 1D: Examine the New Database


Lesson 2: Planning a Database
Topic 2A: Identify Database Purpose
Topic 2B: Review Existing Data
Topic 2C: Determine Fields
Topic 2D: Group Fields into Tables
Topic 2E: Normalize the Data
Topic 2F: Designate Primary and Foreign Keys
Topic 2G: Identify Table Relationships


Lesson 3: Building the Basic Structure
Topic 3A: Create a Blank Database
Topic 3B: Create a Table using a Wizard
Topic 3C: Compare Datasheet and Design Views
Topic 3D: Create Tables in Design View
Topic 3E: Create Relationships between Tables


Lesson 4: Working with Tables
Topic 4A: Modify a Table Design
Topic 4B: Work in Datasheet View
Topic 4C: Work with Subdatasheets


Lesson 5: Creating and Working with Select Queries
Topic 5A: Examine a Query
Topic 5B: Create a Query Using a Wizard
Topic 5C: Work in Query Design View
Topic 5D: Select Records
Topic 5E: Edit Values in a Query Datasheet
Topic 5F: Add a Calculated Field to a Query
Topic 5G: Perform a Calculation for a Group of Records


Lesson 6: Creating and Using Forms
Topic 6A: Create AutoForms
Topic 6B: Create a Form Using a Wizard
Topic 6C: Modify the Design of the Form
Topic 6D: Use Forms to Work with Data


Lesson 7: Creating and Using Reports
Topic 7A: Create an AutoReport
Topic 7B: Create a Report Using a Wizard
Topic 7C: Examine a Report in Design View
Topic 7D: Create a Calculated Field
Topic 7E: Change the Format of a Control
Topic 7F: Change the Style of a Report
Topic 7G: Adjust Report Width

About AcademyX - Training Provider

AcademyX - Since 1998, AcademyX's (www.academyx.com) mission has been to provide the highest quality Internet training in the world. AcademyX is an Adobe Certified Training Center, as well as an authorized training company for ActiveState (Perl) and Altova (XMLSpy). We are located in downtown San Francisco near BART. Please call us if you have any questions: 415-392-8024. We offer hands-on, instructor-led...

More Microsoft Access Training from AcademyX

Click here for more information or to take this course

Training Directory | New Training Programs | New Training Providers | Search | Site Map | Promote Training | Login | Links


Connecting people who want to learn with people who love to teach
 Are you an Access training provider?
You could be on this page today - for FREE!