search our courses:
Quick Navigation
Microsoft Access 2007 Introduction course
Download PDF version of Access 2007 Introduction course outline
Overview
This course introduces delegates to the skills necessary to create databases. Knowledge gained will include an understanding of database design which will facilitate better usage of data tasks such as finding, sorting, retrieving and analysing.
Audience
Users new to Access who need to learn the fundamentals of creating a database.
Course Objectives
At the end of this course, delegates will be able to design a database and be able to create and enter tables, create and add controls to forms and create queries and reports to analyse data.
Prerequisites
No prior knowledge of Access is assumed. Familiarity with database concepts is advantageous.
Course Contents (2 days)
- Introduction
- Overview of Database concepts
- Database Design tips
- Screen layout, Menus and Toolbars
- Database Objects
- Object Types
- On-Line Help
- Screen Tips
- Help Contents
- Help Tabs
- Wizard & Index
- Tables
- Creating a New Database
- Designing Tables
- Design View
- Field Names And Data Types
- Primary Key
- Datasheet View
- Fields in Tables
- Navigating Records
- Select/Edit/Save/Delete Records
- Field Properties
- Field Size
- Formats
- Default Values
- Validation Rules
- Input Mask
- Editing Tables
- Adding / Editing / Deleting Records
- Analysing a Table
- Relationship in Splits
- Modifying Tables
- Lookup Column
- Hyperlink Column
- Many-to-Many Relationships
- Finding and Filtering Data
- Sorting Records
- Find & Replace
- Filters
- Queries & Operators
- Queries And RecordSets
- Simple Query Wizard
- Add Tables To A Query
- Join Tables In A Query
- Use Operators
- Calculated Fields
- Using Parameters
- Action Queries
- AND/OR Condition
- BETWEEN AND Condition
- Wildcards
- Relationships
- Create a Relationship
- Referential Integrity
- Advanced Queries
- Top Values in Query
- Calculated Field
- Function Query
- Parameter Query
- Concatenation Query
- Multiple Tables in Query
- Query Modification
- Sort Query
- Add Criteria/Record
- Hide Fields
- Print Query
- Analysis Table
- Relationships in Splits
- Table Analyser
- Forms
- Using Forms
- Form Wizard
- Viewing, Editing and Printing
- AutoForm
- Reports
- Use Reports
- Reports Wizard
- Print Reports (inc. headers & footers)
- AutoReport
- Printing
- Table Data
- Page Setup and Selected Records