Microsoft Access
Part 2

Contact Us
Feed Back Form
E-Mail Us

Tel:
024 7637 2073

To return to the Microsoft Access Course Index please Click Here

A.K.Solutions: Microsoft Access Part 2 Course Content
Learn how to create a small application using multiple tables and simple relationships / more on field properties / Linking fields to other tables / Forms / Command Buttons / Append and Delete Queries / Macros / Archiving Data / Calculated Controls / Combo Boxes plus many useful tips and tricks..

• Setting up a small application

  • Designing the tables

  • Setting up Primary and Foreign keys

  • Using a multi field primary key

  • Setting up relationships between tables

  • More on field properties

• Designing the forms required

  • Calculated controls

  • Nesting functions in a calculated control

  • Adding a command button control

  • Viewing the Visual Basic for Applications behind a command button

  • Modifying the position and tab order of controls

  • Aligning controls

  • Inserting labels

• Queries

  • Creating queries to fill a table with data

  • Creating queries to archive old data

  • Do's and Don'ts with delete queries

• Macro

  • Automating a sequence of events

  • How to make a macro wait whilst a user fills in a form

  • Modifying macros

  • Prevent warnings appearing when running automated queries

• Copying tables

  • From another access database

  • Within the database

• Main Form / Sub Form

  • Creating a Sub form within a Main form

  • Setting up a relationship based on multiple fields

  • Selecting which records appear in the Sub form via a combo box control

• Main Menu Form

  • Creating a Blank Form

  • Adding Command Buttons to call other database objects

  • Testing the Main Menu

  • View / Modify properties for a Command Button

  • Add a command button to Exit the application

You may print this page by selecting File Print in your Browser Window

Before taking this course.  All candidates are advised to have a good working knowledge of Access basics such as table design, forms and simple queries.  See Microsoft Access Part 1

To contact A.K.Solutions:- enquiries@aksolutions.co.uk

E-Mail Us

Contact Us
Feed Back Form

Tel:
024 7637 2073

Copyright © 1994 - 2006 A.K.Solutions. All rights reserved.  Revised: January 13, 2006.