|
Access 2010 Introduction |
an eWord company |
|
|
|
General Course Information In this 2 day program, participants will be introduced to the fundamentals of database design and conventions and will be provided with the skills to use Microsoft Access effectively.
You will learn to:
Ø Interface Basics
Ø About Records
Ø Creating and Using Forms
Ø Creating and Using Reports
Ø Sorting and Filtering Data
Ø Printing a Database Object
What skills you need There are no prerequisites for this course.
Electus training Electus is a South Australian company with 25 + years of experience in training. Trainers and facilitators at Electus are chosen for their expertise, practical and broad experience in their field and a relaxed and friendly manner.
Training includes Each participant receives a training reference manual/workbook and supplementary training materials. Refreshments and lunch are provided.
|
|
Duration 2 days 9:00am-4:15pm
Who needs to come Anyone who needs to learn the basics of creating a database.
Regular venue 37 Angas Street Adelaide SA (near Victoria Square)
How to book Contact Electus by
Course dates Visit www.electus.com.au for the latest course schedule or ring us on (08) 8221 5517.
|
|
Access 2010 Introduction |
Course Content
|
Starting Out · What is Microsoft Access? · What’s New in Access 2010 · Basic Database Terminology · Opening and Closing Access Interace Basics · Understanding Backstage View (File Menu) · Interface Overview · Using the Standard Tabs · Using Contextual Tabs Database Security · Warnings You May See when Opening a Database · Enabling Content Getting Help · Opening the Help File · Overview of the Help File · Online vs. Offline Help · Searching for Help Creating a Table · About Tables · Creating a Table · Using Design View · Entering Data into a Table · Formatting a Table Customising Tables · Understanding Field Properties · Adding a Primary Key · Indexing a field · Indserting, deleting and moving fields · Adding Quick Start Elements 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 · Using the Table Tools – Design Tab · Validating data · Creating a Lookup field · Modifying a Lookup field · Creating a Value list · Modifying a Value list Referentail Integrity · Using the Relationship Tools – Design Tab · Types of Relationships · Establishing and enforcing Referentail Integrity · Testing Referential Integrity Table Relationships · About join lines · Normalising Tables · Using the Table Analyser Wizard · Setting fields for Indexing The Database Tools Tab · Tools Commands · Macro Commands · Relationships Commands · Analyse Commands · Move Data Commands · Add-Ins Commands First Steps · Planning a Database · Creating a Blank Database · Creating a Database from a Template · Using a Database Objects · Setting Navigation Options |
About Records · What is a Record? · Navigation Tips · Adding Records Editing Records · Deleting Records · Printing Records Viewing Data · Using the View Menu · Using the View Icons · Using the Object Tabs · Closing Individual Object Tabs Creating and Using Forms · What is a Form? · Bound vs. Unbound Controls · Creating a Basic Form · Creating a Form with the Wizard · Using Design View to Modify your Form · About the Form Design Tools Contextual Tabs · Using Forms Creating and Using Queries · What is a Query? · Creating a Query with the Wizard · Using Design View to Modify a Query · About the Query Design Tools Contexual Tabs · Using Reports Sorting and Filtering Data · Using Find and Replace · Sorting Ascending or Descending · Toggling Filter · Using Selection Sort · Using Advanced Sort Printing a Database Object · Print Commands · The Print Dialog Box · Using Print Preview · Printing vs. Exporting |