Intermediate Microsoft Access 2010
Instructor-led Access Intermediate Outline
Duration: |
Intended audience: |
1 day |
Anyone who is comfortable and familiar with using Access 2010 at Introduction level and wants to expand their knowledge |
Aims: |
To enlarge on an Introduction level of knowledge by the use of worked examples |
Objectives:
|
By the end of the session delegates will be able to:·
|
Prerequisites: |
A good knowledge of Access 2010 at Introduction Level |
TABLES
Modifying fields
Lookup fields
Validation rules
Input masks
Default values
Mandatory fields
Creating a table
RELATIONSHIPS
Basics of relationships
Types of joins in a relationship
Creating relationships
Applying inner and outer joins
Applying and using referential integrity
Applying automatic deletion of related records
QUERIES
Query types
Grouping information in a query
Using arithmetic or logical expressions in a query
Refining a query
FORMS
Creating bound and unbound controls
Creating a combo box, list box, check box & option groups
Creating arithmetic / logical expression controls
Creating a form using the form wizard
Setting sequential order of controls on a form
Creating form headers or footers
Creating a subform and linking to the main form
Modifying the subform to change records displayed
REPORTS
Creating arithmetic / logical calculation controls
Using formulas and expressions
Creating running summaries
Presentation
Forcing page breaks for groups on report
USING MACROS
Macros
Running a macro
Attaching a macro to a form control
Attaching a macro to a report control
IMPORTING, EXPORTING AND LINKING DATA
Importing from a text file
Importing from an Excel spreadsheet
Exporting data to a text file
Exporting data as an Excel spreadsheet file
Linking to an Excel worksheet
Microsoft Access Intermediate Courses
We have versions for Microsoft Office 2007, Microsoft Office 2010 and Microsoft Office 2013