Relational Database Design
Designing A Relational Database
Scoping The System
Determining The Inputs
Normalising A database
First Normal Form(1NF)
Second Normal Form
Second Normal Form-Case Study
Third Normal Form (3NF)
Database Indexing
Setting Table Relationships
Understanding Table Relationships
Understanding Lookup Relationships
Looking Up The Employees Table
Looking Up The Expense Types Table
Viewing Table Relationships
Understanding Table Joins
Editing The Employee Table Join
Editing The Expense Type Table Join
Creating A New Join
Creating A Relationships Report
Multi-Table Queries
Understanding Relational Queries
Creating A Relational Query Design
Filtering A Relational Query
Filtering Related Fields
Adding More Tables And Fields
Utilising Hidden Fields
Creating a CrossTab Query
Aggregation Queries
Creating An Aggregation Query
Working With Aggregation Queries
Multiple Aggregations
Modifying Aggregate Headings
Aggregating Calculated Fields
Applying Criteria To Aggregations
Understanding Nested Queries
Creating An Assembly Query
Creating The Nesting Query
Action Queries
Creating A Make Table Query
Using A Make Table Query
Expressions And Update Queries
Preparing An Update Query
Running An Update Query
Updating With Expressions
Running An Expression Based Query
Creating A Delete Query
Running A Delete Query
Creating An Append Query
Running An Append Query
Turning Action Messages Off
| 
| Modifying Forms
Understanding Form Design And Layout
Switching Form Views
Selecting Form Objects
Working With A Control Stack
Changing Control Widths
Moving Controls
Aligning Controls on a Form
Understanding Properties
Changing Label Captions
Adding An Unbound Control
Adding A Control Source
Formatting A Control
Checking the Tab Order of a Form
Changing Tab Order
Inserting the Date and Time into A Form
Development Basics
Understanding The Development Environment
Understanding Splitting Databases
Linking to Data Files
Maintaining Links
Using the Database Splitter
Using Queries For Reports and Forms
Developing Systesm for Other Users
Using The Switchboard
Creating a Switchboard
Creating the Subsidiary Menus
Creating a Menu Item
Returning to Another Menu
Creating a Number of New Menu Items
Linking Switchboard Menus
Modifying The Switchboard Form
Automatically Starting the Switchboard
Database Security for 2007
Understand Database Trust
Enabling Blocked Content
Understanding the Trust Centre
Creating A Trusted Location
Opening A Database From A Trusted Location
Encrypting A Database
Decrypting and Opening A Database
Removing A Database Password
Understanding Package And Sign
Creating A Self Signed Certificate
Creating A Signed Package
Extracting And Using A Signed Package
|
|
Navigation Pane Protection Measures
Navigation Pane Protection Measures
Understanding The Navigation Pane
Creating Custom Categories
Creating Custom Groups
Adding Objects to A Group
Hiding Groups And Objects
Showing Hidden Groups and Objects
Creating And Using Macros
Understanding Macros and VBA
Creating A Macro
Running A Macro
Modifying An Existing Macro
Interacting With The User
Stepping Through A Macro
Documenting Macros
Macro Techniques
Creating A Print Macro
Using Conditions To Enhance A Macro
Creating A Sequence of Conditions
Understanding the Versatility of MsgBox
Using The MsgBox Function
Reconfiguring A Message Box
Using The InputBox Function
Macros On Forms
Understanding Macros And Forms
Creating Navigation Macros
Accessing Event Macros
Creating Unassigned Buttons
Programming An Event
Running An Event Macro
Modifying An Event Macro
Setting Echo Off
Adding A Close Button
Creating A Search Macro
Running The Search Macro
Understanding The Search Macro
Naming Macros
Referencing Macro Sheet Macros
An Introduction To VBA
Understanding VBA
Coding VBA For An Event
Running VBA Event Code
MsgBox And InputBox
Modifying An Existing Procedure
Understanding The Modified Code
Creating A Standard Module
Running The Code
Understanding The Loan
Simulator Code
Creating A Button For The
Simulator
|
