Bcc Info
 
Microsoft Access Intermediate

Microsoft Access 2007 Intermediate Courseware                                                          12 Hrs.

WHAT’S NEW IN ACCESS 2007

 
 
 
  • New features in Access 2007
  • Database Templates
  • Local templates
  • Downloading templates
  • Enhanced Datasheet View
  • New Layout View
  • Improved Interface
 
 

ACCESS 2007 - TABLE DESIGN

 
   
  • Modifying Fields
  • Lookup Fields
  • Validation Rules
  • Input Masks
  • Default Values
  • Mandatory Fields
 

ACCESS 2007 - RELATIONSHIPS

 
   
  • Basics of Relationships
  • What are relationships?
  • Understanding the basis for creating relationships
  • Types of joins in a relationship
  • Creating and modifying one-to-one, or one-to-many relationships
  • Applying inner, outer, and self joins
  • Applying and using referential integrity
  • Applying automatic deletion of related records
 

ACCESS 2007 - QUERY TYPES

 
   
  • Creating and using a query to update data in a table
  • Creating and using a query to delete data in a table
  • Creating and using a query to save the selected information as a table
  • Appending records to a table using query
 

ACCESS 2007 - QUERY FORMULAS

 
   
  • Grouping information in a query
  • Using functions in a query
  • Using Aggregate Functions
  • COUNT function
  • SUM function
  • AVG function
  • MIN function
  • MAX function
  • Using a crosstab query

ACCESS 2007 - FORMS

 
   
  • What are bound and unbound controls?
  • Creating bound and unbound controls.
  • Creating and editing a combo box, list box, check box and option groups.
  • Creating arithmetic and logical expression controls on a form.
  • Setting sequential order of controls on a form.
  • Inserting data fields to appear within form header or footers
  • What are sub forms?
  • Creating a sub form and linking to parent.
  • Modifying the sub form to change records.
 

ACCESS 2007 - REPORTS

 
   
  • Creating arithmetic and logical calculation controls within a report.
  • Calculating percentage calculation control within a report.
  • Using formulas and expressions within a report.
  • Creating running summaries within a report.
  • Inserting a data field to appear within report header or footers
  • Forcing page breaks for groups on reports.
 

ACCESS 2007 - MACROS

 
   
  • Recording & assigning macros
  • Running macros.
  • Assigning macros to a form, report or control.
 

ACCESS 2007 - MPORTING, EXPORTING AND LINKING DATA

 
   
  • Importing files into a database.
  • Exporting data as different formats.
Linking external data to a database
 

 ออกแบบหลักสูตรโดย  อ.รชต รัตนวสวัต

 โรงเรียนศูนย์อบรมคอมพิวเตอร์ ชลบุรี
แก้ไขล่าสุดเมื่อ ( Thursday, 18 February 2010 )
 
Advertisement

Mambo is Free Software released under the GNU/GPL License.
เว็บนี้ขับเคลื่อนด้วย แมมโบ้ลายไทย
Mambo LaiThai base on MamLang