MS Access 2007 Introduction - Course Outline
COURSE INFORMATION
Duration: Two Days: 9am - 4:30pm
Price: $780
Book: Enquire or make a course booking
TARGET AUDIENCE & PURPOSE
This Access Introduction Course is for people new to databases, and for self-taught users to enhance their knowledge. It is a pre-requisite for the Intermediate and Advanced courses.
OBJECTIVES
By the end of this course participants should be able to:
- Design and create a database
- Create tables and set the primary key
- Define the fields and properties for a table
- Enter data and modify the layout of a table
- Find data in tables
- Create queries
- Create table relationships
- Design and create forms and reports
- Print reports
PREREQUISITES
Participants should already be competent in using a mouse and keyboard and have an understanding of Windows.
COURSE CONTENT
| Exploring Access Start Access, Open & Close a Database, Use the Ribbon, Use the Contextual Tabs, Use Toolbar, Use Database Objects, Use Navigation Pane, Open a Database Object, Use & Close All Tabbed Documents, Use the Status Bar, Use the Options Dialog Box, Exit Access Creating Tables Use Database Templates, Create a Database, Design Tables, Create a Table in Datasheet View, Create a Table in Design View, Add Field Names, Assign Data Types, Save a Table, Add a Field Description, Set a Primary Key, Use Multi-valued Fields Working with Tables Use Datasheet View, Navigate Fields in Tables, Add & Move through Records, Select, Editing, Save, Delete Records Editing Tables Change Row Height & Column Width, Change Font Attribute, Change Cell Effect, Use Alternate Background Colors, Select, Move, Hide, Unhide & Freeze a Column Finding & Filtering Data Sort Records, Find Specific Records, Find Records using Wildcards, Use Replace, Use Filter By Selection, Apply/Remove a Filter, Use Filter Exclude Selection, Use the Search Box, Use Quick Filter, Use AutoFilter Printing Data Change Page Setup, Use Print Preview, Print Selected Records Creating Relationships Use Related Tables, Create a Relationship between Tables, Set Referential Integrity, View Subdatasheets, Delete a Join Line Using Simple Queries Use Queries & Recordsets, Simple Query Wizard, Create Query in Design View, Open a Query, Add a Table, Join Tables, Run a Query Modifying Query Results Sort a Query, Add Criteria to a Query, Hide a Field in a Query, Display a Totals Row in a Query, Add a Record using a Query, Print a Query Creating Basic Forms Use Form Button, Add a Record using a Form, Use the Calendar for Date Picking, Use the Form Wizard, View Records in a Form, Print Records in a Form, Base a Form on a Query Creating Basic Reports Use Report Button, Use Print Preview, Print Pages of a Report, Report Wizard, Change Views in a Report, Group & Summarize Report Data, Base a Report on a Query |
Modifying Tables Insert a Column into a Table, Insert a Lookup Column, Insert a Hyperlink Column, Create a Many-to-Many Relationship Setting Field Properties Limit Field Size, Set Number Formats, Set Date/Time Formats, Setting Yes/No Formats, Set Default Values, Set Validation Rules, Create an Input Mask – Wizard, Create an Input Mask Manually, Create a Custom Input Mask, Lookup List, Modify Lookup Properties Using Operators in Queries Use Comparison Operators, Use an & Condition, Use an Or Condition, Use the Between & Operator, Use a Wildcard Character Designing Advanced Queries Set Top Values in a Query, Create a Calculated Field, Format a Calculated Field, Create a Function Query, Create a Parameter Query, Multivalued Fields, Create a Concatenation in a Query, Filter a Query Using Advanced Query Wizards Use the Crosstab Query Wizard, Find Duplicates Query Wizard, Find Unmatched Query Wizard Manipulating Form Controls in Design View Select, Delete, Size Controls, Set Control Margins & Padding, Hide the Ruler, Disable Snap to Grid Feature, Display Field List, Add a Field, Move Part of a Paired Control, Align & Space Controls Using Design View Add a Label, Add an Image, Add a Rectangle, Add a Line, Edit an Unbound Control, Use Multiple Undo/Redo in Design View Using Editing Tools Change the Font, Change Character Format, Change Fill & Background Colors, Format Lines & Borders, Apply Special Effects, Conditional Formatting, Use Format Painter, Use AutoFormat, Use Error Checking, Run Spelling Checker, Set AutoCorrect Options, Add AutoCorrect Entries Using Advanced Form Design Use Forms in Design View, Create a Combo Box, Edite List Items, Create a List Box, Create an Option Group, Add a Logic Control, Set the Tab Order Automatically, Set the Tab Order Manually, Add a Form Header & Footer, Create a Blank Form Using Advanced Report Design (Time Permitting) Add Report Sections in Design View, Create a Calculated Control, Create a Running Summary, Insert a Date/Time Control, Insert a Page Break, Chang the Report Margins, Use the Label Wizard, Create a Report without Using a Wizard |