Category: Access
The course is designed to help the students familiarize themselves with Microsoft Access and gain the fundamental knowledge and skills required when working with the program. The students will learn how to create simple databases: including forms for entering data, queries to manipulate it and reports to show it.
Microsoft Certificate: for an additional fee of 20 GBP per person, we provide registration with Microsoft Authorized Training system. Training participant registered in this system receives a certificate recognized and respected anywhere in the world, and additional electronic training materials provided by Microsoft.
Genuine Microsoft certification not only confirms the holder's skills - it can also be a valuable part of a resume. Important: authorization is available for on-demand training courses only.
Duration
2 days
Agenda
- Introducing MS Access
- Understanding purpose and features of Access
- How it all works? Forms, Tables, Queries, Reports.
- How to use it? Database vs Application.
- Designing Tables.
- Data Types.
- Field Size.
- Display Format.
- Input Mask.
- Validation Rules.
- Default Values.
- Understanding Relationships.
- Primary key, Foreign Key.
- Designing Reports.
- Manual creation.
- Using the Report Wizard.
- Adjusting report design.
- Adding Word documents to a report.
- Grouping and adding Totals.
- Printing.
- Designing Forms.
- Understanding forms types: Single Form, Continuous Form, Split Form.
- Adding Sub Form.
- Designing Queries.
- Adding calculated columns.
- Sorting results.
- Filtering output. Designing advanced conditions.
- Adding calculations on other data types: Manipulating text , date, boolean values.
- Joining data from multiple tables.
- Grouping and summarizing informations.
- Passing values to Queries and Reports.
- Introduction to database theory.
- Importing data from Excel and text files. Exporting data.
For open training, the course materials are prepared for MS Office 2010. Other versions (2013, 2007, 2003) are available on request. Contact us for details.
Audience and prerequisites
This course is intended for professionals and office workers who need to process significant amounts of data efficiently and successfully.
Before attending this course, students must have:
- Basic computer knowledge, such as keyboard and mouse skills.
- Basic file-management skills. The student should know how to navigate to folders and files on a computer running Windows Vista / Windows 7.
- Basic knowledge of MS Office, such as interface navigation, opening documents.
Certificates
Course participants receive completion certificates signed by ALX.