|
Training Materials Include
Microsoft Word
Microsoft Excel
PowerPoint
Microsoft Access
Internet Explorer
Outlook
Expression Web
Microsoft Project
Microsoft Publisher
Microsoft FrontPage
Microsoft Visio
Windows Vista
Windows 2000 / XP
Computer
Concepts
ECDL / ICDL Downloads
PLUS MANY OTHERS
...
|
Microsoft Access 2 Courseware
Foundation Level IT Training Course
Training Course Outline
1. Database design and table creation
- Design and document your database
- Questions to ask yourself
- Define your needs
- Basic design rules
- Determine relationships
- Creating a database
- Using the table wizard
- Adding fields from the wizard
- Creating a table without a wizard
- Adding fields to a new table
- Using the field builder
- Defining field (data) types
- Field properties
- The input mask property
- Setting a primary key
- Adding records to a table datasheet
2. Formatting a table
- Editing records
- Selecting techniques
- Deleting records and fields
- Changing the look of the datasheet
- The datasheet grid
3. Relationships
- Defining relationships
- Opening the relationship window
- Adding tables to the relationship window
- Making relationships
- Referential integrity
- Editing relationships
4. Locating and replacing information
- Finding and replacing information
- A simple search
- The find dialog box
- Wildcards
- Finding specific values
- Find and replace
- Quick sorting records
- Sorting records on more than one field
- What is a filter?
- Filtering records
- Applying and saving filters
- Removing a filter
5. Creating simple queries
- Types of query
- The query wizard
- Creating queries
- The query window
- Adding fields to the query
- Setting simple criteria
- Logical operators in search expressions
- Applying queries
6. Creating calculated fields
- Creating calculated fields
- The expression builder window
- Calculated fields - an example
- Combining fields in a query
- Combining fields - an example
- Using wildcard characters
7. Parameter, action and crosstab queries
- Parameter queries
- Creating a single parameter query
- Creating a multiple parameter query
- Action queries
- Crosstab queries
8. Introducing forms
- Creating a form with forms wizard
- Opening the properties dialog box
9. Creating forms
- Form design
- Manipulating controls
- Types of control
- The toolbox
- Creating text box controls
- Creating controls with the toolbox
- Calculated controls
- Changing properties
- Forms and subforms
10. Creating forms for data input
- Controlling data input
- Adding a list box or combo box with a wizard
- Adding check boxes, option buttons and toggle buttons
- Adding an option group
- Adding command buttons
- Adding page breaks
11. Reports
- Basic report structure
- Previewing and navigating reports
- Printing reports
- Creating a report with a wizard
- Sorting and grouping
- Creating reports
- Grouping reports
- Setting properties
Microsoft Office 2007 Courseware materials
|
