Category: Access
The course provides students with an overview of knowledge and skills needed to create more complicated databases. Students will learn how to better utilize the capabilities of Microsoft Access and discover helpful features of the program.
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 – Quick review of the basics
- Understanding the purpose and features of Access
- How it all works? Forms, Tables, Queries, Reports.
- How to use it? Databases vs Applications.
- 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 document to a report.
- Grouping and adding Totals.
- Printing.
- Designing Forms.
- Understanding form types: Single Form, Continuous Form, Split Form.
- Adding Sub Forms.
- 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.
- Designing custom display formats. Designing custom Input Masks.
- Designing advanced validation rules and calculated default values.
- Setting validation rules for a row. Understanding data types of parameters.
- Introduction to database theory. Normalization.
- Importing data from Excel and text files. Exporting data.
- Collecting information via e-mail to populate a database.
- Working with PivotTables and PivotCharts.
- Creating custom forms.
- Controls.
- Simple macros.
- Linking data from other databases.
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 and analyze significant amounts of data and want to learn how to manipulate them efficiently.
Before attending this course, students must have:
- Basic computer knowledge.
- Basic file-management skills.
- Basic knowledge of the Access interface and database, table and form creation and manipulation.
Certificates
Course participants receive completion certificates signed by ALX.