|
Provided by: Act Training Access Level 2Computer |
 |
Training
Provided by Act Training
Intermediate level one day hands-on instructor led course on Microsoft Access. Topics include: The Principles of Table Design, The Principles of Table Relationships, Table Design Techniques, Designing Select Queries, Customising Form Designs, Working with Data Access Pages, Customising Reports.
The prerequisite for this course is Access Level 1 or equivalent knowledge.
Related Software Programs or Products: Microsoft Access
|
|
||||||||||||
Access Level 2
Lesson 1: Principles of Table Design
Normalising Data
Normalising Data for Fourth and Fifth Normal Forms
Lesson 2: Principles of Table Relationships
Analysing Table Relationships
Establishing and Testing Referential Integrity
Lesson 3: Table Design Techniques
Data Validation Techniques
Indexing Techniques
Lesson 4: Designing Select Queries
Using Calculated Fields in Queries
Creating Multiple-Table Queries
Lesson 5: Customising Form Designs
Customizing the Form Design
Performing Calculations on a Form
Adding Combo Boxes to a Form
Adding Unbound Controls
Lesson 6: Working with Data Access Pages
Creating Data Access Pages
Integrating with Other Applications
Lesson 7: Customising Reports
Customising a Report Created by the Report Wizard
Working with Sub reports
Creating a Report in Design View
Normalising Data
Normalising Data for Fourth and Fifth Normal Forms
Lesson 2: Principles of Table Relationships
Analysing Table Relationships
Establishing and Testing Referential Integrity
Lesson 3: Table Design Techniques
Data Validation Techniques
Indexing Techniques
Lesson 4: Designing Select Queries
Using Calculated Fields in Queries
Creating Multiple-Table Queries
Lesson 5: Customising Form Designs
Customizing the Form Design
Performing Calculations on a Form
Adding Combo Boxes to a Form
Adding Unbound Controls
Lesson 6: Working with Data Access Pages
Creating Data Access Pages
Integrating with Other Applications
Lesson 7: Customising Reports
Customising a Report Created by the Report Wizard
Working with Sub reports
Creating a Report in Design View
About The Training Provider: Act Training
Act Training - We provide training in Computer Applications such as Microsoft Word, Excel, PowerPoint, Access, Outlook, Sage Accounts and Sage Payroll; Professional IT subjects such as CompTIA A plus, CompTIA N plus, MCP, MCSA, MCSE and CISCO; Office skills such as Bookkeeping, Accounting, Pitman & Teeline Shorthand, OCR Text Processing and Keyboard skills.
These subjects are taught on site for individuals...
