Access Introduction (1 Day)

Brief Outline:

This course is for those starting 'from scratch' with Access and so concentrates on the basics in creating, editing and formatting a database. You will learn database terms such as ‘field’, ‘record’ and ‘query’. You will learn about the planning process for setting up a database, and then how to set it up in Access.

Exercises are then carried out on how to create and format the database fields, how to enter data and create records, as well as importing data. You will create and format simple forms and reports, and understand how Access works 'behind the scenes'. A number of exercises cover Queries, what they are, and how they work, including creating basic and more advanced examples.

Finally, how to link tables together and why is an important aspect of the introductory course.

Detailed Outcomes:

By the end of your learning, you will be able to:

• Describe the Access screen layout.
• Plan a database.
• State meanings of database terms - primary key, fields, relational.
• Add fields to create a database.
• Create simple forms.
• Enter data to create records.
• Import data from other programs.
• Find, sort and navigate data.
• Create and format simple reports.
• Create simple queries to extract data.
• Create reports based on queries.
• Link tables together.
• Create queries to combine tables.

Recommended Prior Experience (Prerequisites):

No experience in using Access is required nor assumed. Participants are expected to have a sound knowledge of and experience with a Windows PC.

Dates & Bookings ► | Manuals for Sale ► | Intermediate ►

Access Intermediate (1 Day Course)

Brief Outline:

This course builds on the Introductory level and extends the important aspect of creating linked tables. The concepts of creating relationships and creating queries to combine and extract data are covered in the hands-on exercises. Customising forms and reports is covered, and forms and subforms are created to show you how to improve the functionality of your database.

You will learn how to make your database more user-friendly. Examples include adding command buttons, drop downs and check boxes. You will also learn how to create a 'front-end' menu system to more easily deploy your database.

Detailed Outcomes:

By the end of your learning, you will be able to:

• Revise the basics and shortcuts in using an Access database.
• Create more tables and link them.
• Use queries to combine tables.
• Create calculation queries.
• Change the design of forms and reports.
• Create forms and subforms.
• Add calculations to forms and reports.
• Format and validate data.
• Add Windows features to forms (drop downs, check boxes).
• Create a main menu system.
• Implement simple security features.

Recommended Prior Experience (Prerequisites):

CLASS Training Introductory Course or proven experience with Access.

Dates & Bookings ► | Manuals for Sale ► | Advanced ►

Access Advanced (1 Day Course)

Brief Outline:

This course is designed for the power-user or administrator of Access databases. Detailed implementation of database security features, advanced queries and the setting up of web pages are covered in the exercises.

Important database deployment issues are covered as well, including what is meant by 'splitting' a database and why you should consider it. There is an introduction to macros and VBA (Visual Basic for Applications) for Access, which allows you to implement more advanced controls and features into your databases.

You will create specific examples of database coding such as entering data that automatically populates other fields. You will create drop downs with content that will update automatically.

Detailed Outcomes:

By the end of your learning, you will be able to:

• Create mail merges with MS Word
• Assign detailed controls to forms
• Create automatic field population controls
• Use report dialogue forms
• Apply maintenance and security measures
• Integrate databases with Web pages
• Create and format macros
• Use Visual Basic modules
• Deploy databases to users without Access

Recommended Prior Experience (Prerequisites):

CLASS Training Intermediate Course or proven experience with Access.

Dates & Bookings ► | Manuals for Sale ►