Existing users of Microsoft Access 2003 who want to get grips with some of the more advanced features of this package as quickly as possible.
Delegates on this course should have a good working knowledge of the topics covered in the Introduction course.
Course outline
- Database Normalisation
- The Rules of Normalization
- Relating Tables
-
- One-to-One Relationships
- One-to-Many Relationships
- Many-to-Many Relationships
- Referential Integrity
-
- Planning Relationships Between Tables
- Orphan Records
- Cascading Deletes
- Cascading Updates
- Database Management
-
- Repairing a Database
- Compacting a Database
- Backing up Your Database
- Editing Database Properties
- Saving Your Files
-
- Save As Dialogue
- Object Properties
- AutoRecover
- Exporting Files
-
- Exporting to Word
- Exporting to Excel
- Exporting to Older Versions of Access
- Exporting vs. Save As
- Linking Files
-
- Linking to an Excel Spreadsheet
- Linking to Another Database
- Creating a Hyperlink
- Customising Tables
-
- Understanding Field Properties
- Adding a Primary Key to a Table
- Indexing a Field
- Inserting, Deleting, and Moving Fields
- Importing a Table from Another Source
- Formatting Tables
-
- Formatting Number Fields
- Formatting Text Fields
- Adding Field Descriptions
- Changing Field Data Types
- Adding Captions
- Controlling Table Data Entry
-
- Setting a Default Value
- Setting a Required Value
- Creating and Using Input Masks
- Creating and Removing Table Relationships
- Managing Table Data Entry
-
- How to Validate Data
- Creating a Lookup Field
- Modifying a Lookup Field
- Creating a Value List
- Modifying a Value List
- Basic Form Controls
-
- Adding a Control
- The Control Wizard
- Cutting, Copying, Pasting, and Moving a Control
- Formatting a Control
- Advanced Form Controls
-
- Modifying a Control’s Properties
- Changing a Control’s Data Source
- Changing a Control’s Default Value
- Creating a Calculated Control
- Using Form Properties
- Formatting a Form
-
- Formatting Gridlines
- Modifying the Font
- Adding Images
- Using AutoFormat
- Organising Report Data
-
- Adding and Removing Fields
- Using Report Sections
- Changing Section Properties
- Grouping and Sorting in a Report
- Changing Group Properties
- Using Calculated Controls in a Report
- Formatting Reports
-
- Formatting Gridlines
- Modifying the Font
- Adjusting the Layout of your Report
- Using AutoFormat
- Common Report Tasks
-
- Adding a Photo
- Adjusting Page Properties
- Adding Headers and Footers
- Adding Page Numbers
- The Label Wizard
- Basic Queries
-
- Review of Queries
- Creating a Query
- Sorting a Query
- Filtering a Query
- Hiding Fields
- AND/OR Operators
- IIF Functions
- Multiple Table Queries
-
- Creating a Multiple Table Query
- Creating a Calculated Field
- The Expression Builder
- Using Queries to Summarize
- Make-Table Queries
- Management (Action) Queries
-
- Append Queries
- Delete Queries
- Update Queries
- Exporting Queries
Class time is 10:00 a.m.- 4:30/5:00 p.m. Breaks are scheduled throughout the day and lunch is typically scheduled between 1-2 pm. We provide you with Tea, Coffee, Biscuits and other refreshments on the house. We also have a fridge and a microwave available for you to store/warm up any food you wish to bring along for your lunch.
#
| Course Duration |
1 Day |
| Scheduled Course Price |
£99 +VAT |
| Private Course Price |
This course is only available as individual 1:1 on a bespoke
Please call centre on 0208 443 2888 for a quote and to arrange dates |
| Course Times |
10:00 till 16:00 |