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

About the Course:
This course is for Microsoft Access versions up to 2003. 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
- Creating tables
- Defining fields
- Types of field
- Entering data
- Drawing relationships
- Creating relationships
- Referential integrity
- Importing data
- Importing from Excel
- Linking to Excel spreadsheets
- Problems with importing
- 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
- Action queries
- Making tables
- Updating records
- Appending records
- Deleting records
- Crosstab queries
- Columns, rows and values
- Overriding column headings
- SQL Queries
- Union queries
- Pass-through queries
- Creating forms
- Using the form wizard
- Using forms to enter data
- Form design
- Creating controls
- Creating subforms
- Creating tabular forms
- Merging forms and subforms
- Tidying up subforms
- Creating reports
- Using the report wizard
- Using print preview
- Report design
- Basic VBA macros
- Creating macros
- Using Project Explorer
- Writing comments
- Indenting code
- Uses of macros
- Form validation
- Criteria forms
- A simple menu system
- The VBA code editor
- Two ways to create modules
- Using Project Explorer
- Basic subroutines and comments
 
Tools
 
Key Details
Duration3 days
 
£695
per delegate