Microsoft Access Introduction (Discounted Price)
Vantage Training Limited
Duration: 1 Day
£190
(1st person full price, 2nd person booked £140)
Detailed information
| Duration: | 1 Day |
|---|---|
| Price: | £190 (1st person full price, 2nd person booked £140) |
| Type: | Training |
| Method: | In a classroom |
| Accreditation: | vtl certification |
| Prepares for: | At the end of this course you will be able to: Create a basic database structure. Create standard forms for inputting and amending your data. Use simple queries to manipulate your data. Produce basic Access reports. |
| Geared towards: | Who is this course for? As a new user, with little or no experience of Microsoft Access, the topics covered on this course introduce you to the main concepts involved in creating and maintaining a simple relational database. |
| Requirements: | What do I need to know before attending? It is assumed only that you have a basic knowledge and understanding of the Windows environment. |
| Students per class: | 5 |
Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course program
Introducing Access
An overview of the power and benefits of computer databases.
Terminology.
Tour of the Access initial screen.
Menus and toolbars.
Tables
Creating tables.
Setting field attributes.
Data Entry & Editing
Adding and editing records.
Navigation through data.
Finding specific records.
Sorting and filtering data.
Relational Databases
What they are and why relational databases are useful.
How data stored in different tables can be related.
Queries
Using SELECT Queries to build new record sets.
Sorting and basic filtering.
Deriving new information in queries.
Combining data from different tables through a query.
Forms
Creating forms with and without the Access Forms Wizard.
Using queries and tables as the basis for forms.
Introducing object properties within forms to change data and display characteristics.
Reporting
Creating simple reports with and without the Access Reports Wizard.
Introducing object properties within forms to change report definitions.
Printer set up and printing.
An overview of the power and benefits of computer databases.
Terminology.
Tour of the Access initial screen.
Menus and toolbars.
Tables
Creating tables.
Setting field attributes.
Data Entry & Editing
Adding and editing records.
Navigation through data.
Finding specific records.
Sorting and filtering data.
Relational Databases
What they are and why relational databases are useful.
How data stored in different tables can be related.
Queries
Using SELECT Queries to build new record sets.
Sorting and basic filtering.
Deriving new information in queries.
Combining data from different tables through a query.
Forms
Creating forms with and without the Access Forms Wizard.
Using queries and tables as the basis for forms.
Introducing object properties within forms to change data and display characteristics.
Reporting
Creating simple reports with and without the Access Reports Wizard.
Introducing object properties within forms to change report definitions.
Printer set up and printing.
Do you need clarification regarding the course program?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course location
Vantage Training Limited
vtl are a specialist software training and application development company providing your total office solution. Our training can be tailored to your needs and our development team can provide you with time saving solutions to simplify and speed up your tasks at work. We formed as a limited company in 1995, have offices in Nottingham and Cheshire and deliver our services nationwide.
Our aim is to help you make the most of your software – whether this is through providing your staff with the skills they need to utilise programs, or through working with you to develop bespoke applications. We don’t see these as two distinct options, but more a continuum that our services can travel along. Because of our customisation, we are able to offer you what ever level of support you need – from standard classroom training, through workshop style sessions that can solve your problems on specific projects, to building applications for you with your design input. We even design and deliver courses on your existing bespoke software packages.
Our aim is to help you make the most of your software – whether this is through providing your staff with the skills they need to utilise programs, or through working with you to develop bespoke applications. We don’t see these as two distinct options, but more a continuum that our services can travel along. Because of our customisation, we are able to offer you what ever level of support you need – from standard classroom training, through workshop style sessions that can solve your problems on specific projects, to building applications for you with your design input. We even design and deliver courses on your existing bespoke software packages.
Search similar to Access
- Courses IT, ICT and Computing
- Courses Database Administration and Development
- Courses Access
- IT Training
- Access Training Nottingham
- IT Training Nottingham
- ICT Training Nottingham
- Software Training Nottingham
- Computer Training Nottingham
- Access Database
- Database Design
- Database Training Nottingham
- Courses Vantage Training Limited
