Relational Databases in MS Access

AcademyX
San Francisco, California, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' The information in most databases is compartmentalized so that changes to a particular set of data only need to be made in one place. For example, if a customer changes its address, it shouldn’t be necessary to change the address in each order for that customer. Instead, the database is designed in such a way that a relationship is established between a table of customers and a table of orders, so that the address only needs to be changed in the customers table. This process of building relationships has many implications in terms of your database design: linking tables, different types of relationships, data normalization, and referential integrity. Topics include:

This class is held at an AcademyX partner facility, also located in downtown San Francisco.

Introduction to Relational Databases
The Basics of Relational Databases
Database Integrity and Anomalies
What is Data Normalization?
Database Terminology
Database Relationships
Types of Relationships
Naming Conventions
Prefixes
Spaces
Case Sensitivity
The Design Process
Identify the Scope of the Database
Define Purpose
Forms and Reports
Field List Worksheets
Field Names
Controls
Table Definitions
Forms
Working with Key Fields
Primary Keys
Entity Relationship Diagrams
Normalizing the Design
Technical Definitions
Creating the Database
Review and Finalize
Prerequisites:

Good understanding of MS Windows file management, and the concepts of right-clicking and selecting the properties of an object
Intro to MS Access or equivalent experience: basic understanding of tables, queries, forms, and reports
...''

Phone:415-392-8024

School Address:

601 Montgomery St. #409
San Francisco, California 94111 USA
415-392-8024 tel
415-392-0743 fax


Jobs & Resumes: San Francisco
Houses & Roommates: San Francisco

Advanced ASP
XML Fundamentals
XML Schema
XSL and XSLT
PHP and MySQL Fundamentals
Java Fundamentals
Visual Basic 6 Fundamentals
ASP.Net Fundamentals
Microsoft Access Intro
Intermediate MS Access
Microsoft Excel Introduction
Microsoft Excel Intermediate
Microsoft PowerPoint Introduction
Microsoft PowerPoint Intermediate
Adobe Illustrator Level I
Introduction to Adobe Illustrator
Intermediate Adobe Illustrator
Photoshop Fundamentals
Photoshop Level II

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.