Microsoft Access 2007 Intermediate

Whats New In Access 2007

- New features in Access 2007
- Database templates
- Using local templates
- Downloading templates
- Enhanced Datasheet View
- New Layout View
- Improved Interface

Security Issues & The Trust Centre In Access 2007

- Security warnings
- Trusted Locations - Trust Centre
- Setting the default folder location within Access

Modifying Fiels In Access 2007

- Applying and modifying data types
- Modifying column data types
- Formatting Text data type
- Formatting Memo data type
- Examples of formatting a text box or memo
- Formatting Hyperlink data type
- Formatting Currency data type
- Formatting Date/Time data type
- Database object naming conventions
- Data types
- Converting between data types
- Changing a field to a different data type

Lookup Fields In Access 2007

- Creating and editing a lookup in a field or column
- Creating a lookup from values in a table or query
- Creating a lookup from values you type in

Validation Rules In Access 2007

- Creating a validation rule within a field

Input Masks In Access 2007

- Creating an input mask in a field

Default Values In Access 2007

- Applying a default value to a field

Mandatory Fields In Access 2007

- Setting a required field

Creating A Table In Access 2007

- Creating a new table
 
Basic Relationships In Access 2007

- Issues relating to creating valid relationships
- Identifying a related table
- Creating a relationship
- Deleting a relationship
- Creating a primary key and a composite key

Types Of Joins In A Relationship In Access 2007

- One-to-one
- One-to-many
- Many-to-many

Creating Relationships In Access 2007

- Creating a one-to-one relationship
- Modifying one-to-one relationship
- Creating a one-to-many relationship
- Modifying one-to-many relationship
- Creating many-to-many relationships

Applying Inner And Outer Joins In Access 2007

- Applying an inner join
- Applying an outer join

Applying And Using Referential Integrity In Access 2007

- Setting referential integrity

Applying Automatic Deletion Of Related Records In Access 2007

- Setting cascading options

Query Types In Access 2007

- Enabling the content
- Creating and using a query to update data in a table
- Populating data in the tables
- Creating an Update Query
- Creating and using a query to delete data within a table
- Creating a Delete Query
- Creating and using a query to save the selected information as a table
- Creating a Make-Table Query
- Appending records to a table using query
- Creating an Append Query

Grouping Information In A Query In Access 2007

- Using Aggregate Functions
- Counting column values using the COUNT function
- Summing column values using the SUM function
- Averaging column values using the AVG function
- Finding minimum column values using the MIN function
- Finding maximum column values using the MAX function
- Using a crosstab query
- Creating a crosstab query
- Creating a crosstab query using Crosstab Wizard
- Using wildcards as parameters

Using Arithmetic Or Logical Expressions In A Query In Access 2007

- Creating an arithmetic calculation within a query
- Creating a logical (condition based) expression within a query

Refining A Query In Access 2007

- Finding duplicates using the Find Duplicates Query Wizard
- Finding unmatched values using the Find Unmatched Query Wizard
- Finding the lowest range of values within a query
- Finding the highest range of values within a query
- Creating a parameter query
- Finding Null values
- Finding NOT values

Creating Bound And Unbound Controls In Access 2007

- Creating an unbound control
- Creating a bound control

Creating A Combo Box, List Box, Check Box & Option Groups In Access 2007

- Creating a combo box
- Creating a list box
- Creating a check box
- Creating an option button
- Creating an option group

Creating Arithmetic / Logical Expression Controls In Access 2007

- Creating an expression control
- Creating an arithmetic expression control
- Creating a logical expression control

Creating A Form Using The Form Wizard In Access 2007

- Creating a form with Form Wizard

Setting Sequential Order Of Controls On A Form In Access 2007

- Setting tab index for controls on a form

Creating Headers And Footers In Access 2007

- Creating a form header and footer area
- Numbering a form page

Creating A Subform And Linking To The Main Form In Access 2007

- Using a subform
- Adding a subform to a form

Modifying The Subform To Change Records Displayed In Access 2007

- Bringing a subtotal from a subform to a main form

Creating Arithmetic / Logical Calculation Controls In Access 2007

- Placing a control on a report
- Creating an arithmetic expression control
- Creating a logical expression control

Using Formulas And Expressions In Access 2007

- Using common functions in a report
- Using count and sum calculations within a report
- Using sum min, max and average calculations within a report
- Concatenating (combining) values within an expression

Creating Running Summaries In Access 2007

- Creating a report with running summaries

Presentation In Access 2007

- Creating page headers and footers
- Creating report headers and footers
- Grouping records on a report

Forcing Page Breaks For Groups On Reports In Access 2007

- Forcing page breaks after each group of records

Macros In Access 2007

- Creating a new macro
- Running a macro
- Using the single step method to run a macro
- Attaching a macro to a form control
- Attaching a macro to a report control

Importing Data In Access 2007

- Importing from a text file
- Importing from an Excel spreadsheet
- Importing from a dBase file
- Importing from a Paradox file

Exporting Data In Access 2007

- Exporting data to a text file
- Exporting data as an Excel spreadsheet file
- Exporting data to a dBase file
- Exporting data to a Paradox file
- Linking external data to a database
- Linking to an external text file
- Linking to an Excel worksheet