|
Provided by: Sonic Training Microsoft Access 2003 - Introduction / IntermediateDatabases and SQL |
 |
Course Description
Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management computer applications is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database by using the Microsoft Office Access 2003 relational database application and its information management tools.
Course Objective: You will be introduced to the features of the Access 2003 application.
Performance-based Objectives
Upon successful completion of this course, students will be able to:
Examine the Microsoft Office Access 2003 database application.
Manage the data in a database.
Examine existing table relationships.
Query the database.
Design simple forms.
Create and modify Access reports.
SEE DAY 2 FOR MORE TOPICS
Welcome to Sonic Training!. (http://www.sonictraining.com 877-760-0078) Macromedia (Dreamweaver, Flash, Fireworks), Adobe (Photoshop, InDesign, Illustrator), Database (SQL, Access, Filemaker Pro, Goldmine), Programming (HTML, CSS, XML, Access VBA, Excel VBA), MS Office (Excel, Access, PowerPoint, Word, Outlook, Project) instructor-led, classroom training at our location or your company location. Sonic Training blends the fun and challenge of learning into to a classroom environment. Since all we do is training, (see Why choose Sonic Training) we know what works best and what doesn't.
Here at Sonic Training, we take your technical education seriously...but not too seriously. With 12 years of design and training experience, our mix of learning in a fun environment makes understanding complex design applications, like Dreamweaver or Access VBA, easy to digest. We also realize each student is unique and the company they work is unique, so our small class sizes (never over 8 students) makes it easy to incorporate your project at work into our class. We actually encourage work-related scenarios to help give the other students another real-life perspective.
Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management computer applications is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database by using the Microsoft Office Access 2003 relational database application and its information management tools.
Course Objective: You will be introduced to the features of the Access 2003 application.
Performance-based Objectives
Upon successful completion of this course, students will be able to:
Examine the Microsoft Office Access 2003 database application.
Manage the data in a database.
Examine existing table relationships.
Query the database.
Design simple forms.
Create and modify Access reports.
SEE DAY 2 FOR MORE TOPICS
Welcome to Sonic Training!. (http://www.sonictraining.com 877-760-0078) Macromedia (Dreamweaver, Flash, Fireworks), Adobe (Photoshop, InDesign, Illustrator), Database (SQL, Access, Filemaker Pro, Goldmine), Programming (HTML, CSS, XML, Access VBA, Excel VBA), MS Office (Excel, Access, PowerPoint, Word, Outlook, Project) instructor-led, classroom training at our location or your company location. Sonic Training blends the fun and challenge of learning into to a classroom environment. Since all we do is training, (see Why choose Sonic Training) we know what works best and what doesn't.
Here at Sonic Training, we take your technical education seriously...but not too seriously. With 12 years of design and training experience, our mix of learning in a fun environment makes understanding complex design applications, like Dreamweaver or Access VBA, easy to digest. We also realize each student is unique and the company they work is unique, so our small class sizes (never over 8 students) makes it easy to incorporate your project at work into our class. We actually encourage work-related scenarios to help give the other students another real-life perspective.
|
|
||||||||||
Training
Provided by Sonic Training
- B asked: Looking for Intermediate and Advance Access courses to attend
- A asked: we need a two weeks training at US to our clients Topic: Human Resources Management Database Request: we will like to know if the topic is a kind treated by you and the possible rate or charges. best regards
- T asked: CAN YOU SEND ME A CLASS SCHEDULE FOR THE VIRGINIA BEACH/ NORFOLK AREA FOR ACCESS
- K asked: Please send me information on any upcoming classes in/ around Santa Cruz, CA. Thank you!
- asked: Schedule of classes (I am in Oklahoma City, OK)
- L asked: Dear Sir or Madam, Am trying to determine whether I need training in Access or Excel VBA/ macros. I need to create a report after viewing three databases and doing simple calculations. I can provide detailed steps in how to complete the desired report if it would help. Sincerely,
- R asked: Do you have any classes in ACCESS in the Springfield, VA area? What are the costs/ timeframes/ day/ night, etc.
- J asked: Is this training available online or locally in City, OK? Thank you for your time...
- M asked: In this computer class can I bring my own files and be taught one by one on a app;ication to populate list boxes in VB
- V asked: Hi, Do you have any courses for both office access and excel during weekends? im interesting in learning both and is wondering how long will a normal training like this take and how much is it per training? Thank you very much.
- S asked: Course date, time, location and cost
- K asked: Are you offering this class in the Norfolk, VA area soon?
- O asked: I would like info on MS Access training in New Jersey please. I need to know how to create forms reports. (My alternate email address is com in case orlando. com gives you a problem.)
- S asked: When will this class be offered in the Nashville area?
- B asked: I would like to find out when does this couse satarts (Microsoft Access). How much is the course for the study?
- E asked: is there a more advanced class?
- S asked: Hi, I was wondering if you have dates/ prices for this training. I am looking for a training in the San Francisco/ Bay Area (San Francisco, San Mateo, and Santa Clara counties). Thank you,
- asked: I would like to know how much that will be for the two days training.
- asked: I would like to know how much that will be for the two days training.
- A asked: Dates and cost
- asked: Please forward me the schedule & location of the subject class. Thank you
- asked: Requesting schedule information for training course in El Paso, TX or in the west coast region
- asked: Need schedule information for training course in El Paso, TX or in the West Coast region.
- N asked: I would like to learn more about Microsoft Access or version. I am interested in participating in an online class or a face to face class. I would like to know class length, cost and information covered. Thank you, Grakon LLC
- K asked: is this class being held in mountain view or redwood city, ca. if so when, where, and how much.
Microsoft Access 2003 - Introduction / Intermediate
Course Content
Lesson 1: An Overview of Access 2003
Topic 1A: Understand Relational Databases
Topic 1B: Examine the Access Environment
Topic 1C: Open the Database Environment
Topic 1D: Examine an Access Table
Lesson 2: Managing Data
Topic 2A: Examine an Access Form
Topic 2B: Add and Delete Records
Topic 2C: Sort Records
Topic 2D: Display Recordsets
Topic 2E: Update Records
Topic 2F: Run a Report
Lesson 3: Establishing Table Relationships
Topic 3A: Identify Table Relationships
Topic 3B: Identify Primary and Foreign Keys in the Relationships Window
Topic 3C: Work with Subdatasheets
Lesson 4: Querying the Database
Topic 4A: Create a Select Query
Topic 4B: Add Criteria to a Query
Topic 4C: Add a Calculated Field to a Query
Topic 4D: Perform a Calculation on a Record Grouping
Lesson 5: Designing Forms
Topic 5A: Examine Form Design Guidelines
Topic 5B: Create a Form Using AutoForm
Topic 5C: Create a Form Using the Form Wizard
Topic 5D: Modify the Design of a Form
Lesson 6: Producing Reports
Topic 6A: Create an AutoReport
Topic 6B: Create a Report by Using the Wizard
Topic 6C: Examine a Report in Design View
Topic 6D: Add a Calculated Field to a Report
Topic 6E: Modify the Format Properties of a Control
Topic 6F: AutoFormat a Report
Topic 6G: Adjust the Width of a Report
Day 2 -- Access Intermediate
Course Description
As you begin this course, you should have the basic skills you need to work with a Microsoft Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
follow the steps required to properly design a simple database.
create a new database with related tables.
control data entry by modifying the design of a table to streamline data entry and maintain data integrity.
find and retrieve desired data by using filters and joins between tables and within a single table.
create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries.
enhance the appearance, data entry, and data access capabilities of your forms.
customize reports to better organize the displayed information and produce specific print layouts such as mailing labels.
use Access data in other applications, including Microsoft Word and Access.
Course Content
Lesson 1: Planning a Database
Topic 1A: Design a Relational Database
Topic 1B: Identify Database Purpose
Topic 1C: Review Existing Data
Topic 1D: Determine Fields
Topic 1E: Group Fields into Tables
Topic 1F: Normalize the Data
Topic 1G: Designate Primary and Foreign Keys
Lesson 2: Building the Structure of a Database
Topic 2A: Create a New Database
Topic 2B: Create a Table Using a Wizard
Topic 2C: Create Tables in Design View
Topic 2D: Create Relationships between Tables
Lesson 3: Controlling Data Entry
Topic 3A: Restrict Data Entry with Field Properties
Topic 3B: Create an Input Mask
Topic 3C: Create a Lookup Field
Lesson 4: Finding and Joining Data
Topic 4A: Find Data with Filters
Topic 4B: Create Query Joins
Topic 4C: Join Unrelated Tables
Topic 4D: Relate Data Within a Table
Lesson 5: Creating Flexible Queries
Topic 5A: Set Select Query Properties
Topic 5B: Create Parameter Queries
Topic 5C: Create Action Queries
Lesson 6: Improving Your Forms
Topic 6A: Enhance the Appearance of a Form
Topic 6B: Restrict Data Entry in Forms
Topic 6C: Add Command Buttons
Topic 6D: Create a Subform
Lesson 7: Customizing Your Reports
Topic 7A: Organize Report Information
Topic 7B: Set Report Control Properties
Topic 7C: Control Report Pagination
Topic 7D: Summarize Information
Topic 7E: Add a Subreport to an Existing Report
Topic 7F: Create Mailing Labels
Lesson 8: Expanding the Reach of Your Data
Topic 8A: Publish Access Data as a Word Document
Topic 8B: Analyze Access Data in Access
Topic 8C: Export Data to a Text File
Topic 8D: Merge Access Data with a Word Document
Campbell
Cupertino
Fremont
Gilroy
Los Altos Hills
Los Gatos
Milpitas
Morgan Hill
Mt View
Palo Alto
Redwood City
San Jose
San Mateo
Santa Clara
Santa Cruz
Saratoga
Sunnyvale
Union City
National Regions:
=====================
Training regions include:
=========================
Alabama -- Montgomery, Birmingham
Arizona -- Phoenix, Tulsa
California -- San Jose, Santa Clara, Fremont, Orange County, Costa Mesa, Irvine, San Diego
Colorado -- Denver, Colorado Springs
Connecticut -- Hartford
DC -- Washington DC
Florida -- Orlando, Fort Lauderdale, Miami, Gainesville, Jacksonville, Saint Petersburg, Tampa
Georgia -- Alpharetta, Atlanta, Augusta , Savannah, Columbus
Illinois -- Bloomington, Chicago
Indiana -- Indianapolis
Kansas --Wichita
Kentucky -- Murray, Paducah, Louisville
Maryland -- Greenbelt , Silver Spring / Baltimore
Massachusetts -- Boston, Cambridge, Springfield
Ann Arbor / Farmington Hills / Detroit, Grand Rapids
Michigan -- Detroit, Saginaw, Flint, Bay City, Midland
Minnesota -- Saint Paul, Minneapolis
Mississippi -- Gulfport, Biloxi
Missouri -- Whiteman Air Force Base, Kansas City
Nevada -- Reno, Las Vegas
New Mexico --Carlsbad, Albuquerque
New Jersey, Newark, Princeton
Pennsylvania -- Philadelphia
New York -- New York City, Buffalo, Long Island
North Carolina -- Charlotte
Ohio -- Cleveland, Columbus
Oklahoma -- Tulsa, Oklahoma City
Oregon -- Portland, Salem
Pennsylvania -- Pittsburgh
Rhode Island -- Providence
South Carolina --Columbia, Charleston
Tennessee -- Memphis, Jackson, Nashville
Texas -- Houston, Dallas, Austin, San Antonio, El Paso
Utah -- Ogden, Salt Lake City
Vermont -- Burlington
Virginia -- Virginia Beach, Norfolk, Fairfax, Dulles, McLean, Herndon
Washington -- Tacoma, Seattle, Spokane
Wisconsin -- La Crosse
Lesson 1: An Overview of Access 2003
Topic 1A: Understand Relational Databases
Topic 1B: Examine the Access Environment
Topic 1C: Open the Database Environment
Topic 1D: Examine an Access Table
Lesson 2: Managing Data
Topic 2A: Examine an Access Form
Topic 2B: Add and Delete Records
Topic 2C: Sort Records
Topic 2D: Display Recordsets
Topic 2E: Update Records
Topic 2F: Run a Report
Lesson 3: Establishing Table Relationships
Topic 3A: Identify Table Relationships
Topic 3B: Identify Primary and Foreign Keys in the Relationships Window
Topic 3C: Work with Subdatasheets
Lesson 4: Querying the Database
Topic 4A: Create a Select Query
Topic 4B: Add Criteria to a Query
Topic 4C: Add a Calculated Field to a Query
Topic 4D: Perform a Calculation on a Record Grouping
Lesson 5: Designing Forms
Topic 5A: Examine Form Design Guidelines
Topic 5B: Create a Form Using AutoForm
Topic 5C: Create a Form Using the Form Wizard
Topic 5D: Modify the Design of a Form
Lesson 6: Producing Reports
Topic 6A: Create an AutoReport
Topic 6B: Create a Report by Using the Wizard
Topic 6C: Examine a Report in Design View
Topic 6D: Add a Calculated Field to a Report
Topic 6E: Modify the Format Properties of a Control
Topic 6F: AutoFormat a Report
Topic 6G: Adjust the Width of a Report
Day 2 -- Access Intermediate
Course Description
As you begin this course, you should have the basic skills you need to work with a Microsoft Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
follow the steps required to properly design a simple database.
create a new database with related tables.
control data entry by modifying the design of a table to streamline data entry and maintain data integrity.
find and retrieve desired data by using filters and joins between tables and within a single table.
create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries.
enhance the appearance, data entry, and data access capabilities of your forms.
customize reports to better organize the displayed information and produce specific print layouts such as mailing labels.
use Access data in other applications, including Microsoft Word and Access.
Course Content
Lesson 1: Planning a Database
Topic 1A: Design a Relational Database
Topic 1B: Identify Database Purpose
Topic 1C: Review Existing Data
Topic 1D: Determine Fields
Topic 1E: Group Fields into Tables
Topic 1F: Normalize the Data
Topic 1G: Designate Primary and Foreign Keys
Lesson 2: Building the Structure of a Database
Topic 2A: Create a New Database
Topic 2B: Create a Table Using a Wizard
Topic 2C: Create Tables in Design View
Topic 2D: Create Relationships between Tables
Lesson 3: Controlling Data Entry
Topic 3A: Restrict Data Entry with Field Properties
Topic 3B: Create an Input Mask
Topic 3C: Create a Lookup Field
Lesson 4: Finding and Joining Data
Topic 4A: Find Data with Filters
Topic 4B: Create Query Joins
Topic 4C: Join Unrelated Tables
Topic 4D: Relate Data Within a Table
Lesson 5: Creating Flexible Queries
Topic 5A: Set Select Query Properties
Topic 5B: Create Parameter Queries
Topic 5C: Create Action Queries
Lesson 6: Improving Your Forms
Topic 6A: Enhance the Appearance of a Form
Topic 6B: Restrict Data Entry in Forms
Topic 6C: Add Command Buttons
Topic 6D: Create a Subform
Lesson 7: Customizing Your Reports
Topic 7A: Organize Report Information
Topic 7B: Set Report Control Properties
Topic 7C: Control Report Pagination
Topic 7D: Summarize Information
Topic 7E: Add a Subreport to an Existing Report
Topic 7F: Create Mailing Labels
Lesson 8: Expanding the Reach of Your Data
Topic 8A: Publish Access Data as a Word Document
Topic 8B: Analyze Access Data in Access
Topic 8C: Export Data to a Text File
Topic 8D: Merge Access Data with a Word Document
Campbell
Cupertino
Fremont
Gilroy
Los Altos Hills
Los Gatos
Milpitas
Morgan Hill
Mt View
Palo Alto
Redwood City
San Jose
San Mateo
Santa Clara
Santa Cruz
Saratoga
Sunnyvale
Union City
National Regions:
=====================
Training regions include:
=========================
Alabama -- Montgomery, Birmingham
Arizona -- Phoenix, Tulsa
California -- San Jose, Santa Clara, Fremont, Orange County, Costa Mesa, Irvine, San Diego
Colorado -- Denver, Colorado Springs
Connecticut -- Hartford
DC -- Washington DC
Florida -- Orlando, Fort Lauderdale, Miami, Gainesville, Jacksonville, Saint Petersburg, Tampa
Georgia -- Alpharetta, Atlanta, Augusta , Savannah, Columbus
Illinois -- Bloomington, Chicago
Indiana -- Indianapolis
Kansas --Wichita
Kentucky -- Murray, Paducah, Louisville
Maryland -- Greenbelt , Silver Spring / Baltimore
Massachusetts -- Boston, Cambridge, Springfield
Ann Arbor / Farmington Hills / Detroit, Grand Rapids
Michigan -- Detroit, Saginaw, Flint, Bay City, Midland
Minnesota -- Saint Paul, Minneapolis
Mississippi -- Gulfport, Biloxi
Missouri -- Whiteman Air Force Base, Kansas City
Nevada -- Reno, Las Vegas
New Mexico --Carlsbad, Albuquerque
New Jersey, Newark, Princeton
Pennsylvania -- Philadelphia
New York -- New York City, Buffalo, Long Island
North Carolina -- Charlotte
Ohio -- Cleveland, Columbus
Oklahoma -- Tulsa, Oklahoma City
Oregon -- Portland, Salem
Pennsylvania -- Pittsburgh
Rhode Island -- Providence
South Carolina --Columbia, Charleston
Tennessee -- Memphis, Jackson, Nashville
Texas -- Houston, Dallas, Austin, San Antonio, El Paso
Utah -- Ogden, Salt Lake City
Vermont -- Burlington
Virginia -- Virginia Beach, Norfolk, Fairfax, Dulles, McLean, Herndon
Washington -- Tacoma, Seattle, Spokane
Wisconsin -- La Crosse
About The Training Provider: Sonic Training
Sonic Training - About Sonic Training
====================
Macromedia, Adobe, Database, Programming, MS Office instructor-led, classroom training in most major U.S. cities at our location or your company location. Sonic Training blends the fun and challenge of learning into to a classroom environment. Since all we do is training, we know what works best and what doesn"t. Classes include: Macromedia...
