Categories:
Microsoft Access
£880 per delegate. This may be less for special offers on specific course dates and in-company training courses
Duration: 3 days
Trainer: S047OW
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...
Introduction
The first (and most important) part of any Access database is getting the design right, which is where this 3-day course begins. You'll learn about primary keys and relationships, and find out how to create an Access database consisting of multiple linked tables.
The course then goes on to show how to create queries (to display data from one or more tables) and a front-end to your system, using forms, reports and the VBA coding language.
If you've been given the job of creating an Access database - and you're not sure where to start - this is the course for you!
The course then goes on to show how to create queries (to display data from one or more tables) and a front-end to your system, using forms, reports and the VBA coding language.
If you've been given the job of creating an Access database - and you're not sure where to start - this is the course for you!
Prerequisites
You do not need to have used Access before to attend this course, although you should be a confident computer user.
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)
- Calculated fields
Importing data
- Importing from Excel
- Making tables from Excel
Table rules (*)
- Record-level validation
- Basic triggers
Drawing relationships
- Creating relationships
- Referential integrity
Creating queries
- The query design grid
- Sorting
- Setting criteria
- Combining criteria
- 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
Advanced controls (*)
- Webbrowser controls
- Navigation bars
- Multitabs
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
- 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)
- Calculated fields
Importing data
- Importing from Excel
- Making tables from Excel
Table rules (*)
- Record-level validation
- Basic triggers
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
Advanced controls (*)
- Webbrowser controls
- Navigation bars
- Multitabs
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
Please note that any items marked with a * will be covered if time allows.
Course Times
Usually 9.30am - 4.30pm. Course times will be confirmed in the joining instructions once the course has been booked.
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Telephone Hotline
01933 233884
(Monday to Friday - 8:00am to 5:30pm).
© 2020 Book My Course Limited. All rights reserved
Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy