Access 2007 Introduction for Developers
Categories: Microsoft Access
Access 2007 Introduction for Developers.

About the Course:
This course is for Microsoft Access 2007. Have you been given the task of designing and developing a database in Microsoft Access? Finding it difficult to know where to start? This three-day course assumes no prior knowledge of Access, and covers all the basics of Access, including how to design your database, creating tables, creating Access queries, and using Access forms, reports and macros. 

Course Contents:
- Designing a database
- Identifying the tables
- What are relationships?
- Setting a primary key
- Using multivalue fields
- Creating tables
- Defining fields
- The types of field
- Entering data
- Different field types
- Creating attachments
- Rich text format fields
- Date fields (using calendars)
- Importing data
- Importing from Excel
- Making tables from Excel
- Drawing relationships
- Creating relationships
- Referential integrity
- Creating queries
- The query design grid
- Sorting
- Setting criteria
- Combining criteria
- Advanced queries
- Grouping and totalling
- Creating expressions
- Parameter queries
- Joins
- Creating ad hoc joins
- Types of join
- Crosstab queries
- Columns, rows and values
- Overriding column headings
- Action queries
- Making tables
- Updating records
- Appending records
- Deleting records
- Creating forms
- Layout and design view
- Using the form wizard
- Split forms
- Creating controls
- Creating reports
- Using the report wizard
- The group, sort and total pane
- Report design
- Creating subforms
- Multiple item forms
- Creating subforms
- Tidying up subforms
- Basic VBA coding
- Creating modules
- Using Project Explorer
- Writing comments
- Indenting code
- Uses of VBA
- Form validation
- Criteria forms
- A simple menu system
 
Tools
 
Key Details
Duration3 days
 
£695
per delegate