See Similar Listings
Community Listing   Australia   NT   Community Listing -

Microsoft Access Introduction Course ...

Darwin Human Resource Computer Academy

This listing was posted on doMore - Learn Something New.

 

Microsoft Access Introduction Course (Microsoft Access Introduction Course -

Location:
Darwin, NT
Description:

ICTICT210 Operate Database Applications – Nationally Endorsed Industry Competency Duration : three x half days Prerequisite : Experience with Microsoft Windows and use of a mouse. Objectives : To provide a thorough understanding of the comprehensive concepts and skills that will enable the participant to effectively use Microsoft Access. Methodology : Group and individual instruction, hands on, practical exercises, visual aids, comprehensive course documentation. Expected Outcome : By the end of the course the participant should be able to use the following functions and features of Microsoft Access. Getting Started with Access :• Starting Access• Access Environment• Opening Databases• Database Window• Working with Database Objects• Working with Menus• Closing a Database• Exiting from Access Database Scenario :• Database Theory and Design• Overview of Databases• How Access Stores Data• Spreadsheets verses Databases• Database Objects in Tables• Designing a Relational Database• Normalisation of Tables Creating the Database :• Creating a New Database File• Creating Tables• Changing Field Properties• Assigning a Primary Key• Saving the Table• Using the Lookup Wizard Data Type• More on Field Properties Creating Relationships :• Relationship Overview• Creating Relationships• Editing Relationships• Cascade Update and Cascade Delete• Printing Relationships Working with Records :• Entering Records• Working with Records• Deleting Records• Importing Data• Data Violations and Integrity• Compacting a Database• Enforcing Referential Integrity Creating Forms :• Creating a Form using the Wizard• Creating Forms with SubForms Creating Queries :• Querying Overview• Creating Queries using a Wizard• Understanding the Query Design Window• Designing Single Table Queries• Sorting Data• Creating Select Queries• Designing Multiple Table Queries Creating Reports :• Reporting Overview• Previewing and Printing a Report• Creating Other Reports
Category:
Community
Posted:
Visit Our Partner Website
This listing was posted on another website. Click here to open: Go to doMore - Learn Something New
Important Safety Tips

These might be signs of fraud:

  • Really cheap prices
  • Irregular email adresses
  • Contact info in pictures

To learn more, visit the Safety Center or click here to report this listing.