ECDL Advanced – Access
Starting dates and places
Description
Who is the course for?The database software unit will help learner to get more from the database application, giving them the skills to use the many advanced tools available in database applications to better manage and organise structured information.
What will I study?Advanced Database requires the candidate to understand key database concepts and use a relational database application to create an advanced database structure and outputs. The candidate shall be able to:
- Understand key concepts of database development and usage.
- Create a relational database using advanced table creation features and complex relationships between tables.
- Design and use queries to create a table, update, de…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
The database software unit will help learner to get more from the database application, giving them the skills to use the many advanced tools available in database applications to better manage and organise structured information.
What will I study?Advanced Database requires the candidate to understand key database concepts and use a relational database application to create an advanced database structure and outputs. The candidate shall be able to:
- Understand key concepts of database development and usage.
- Create a relational database using advanced table creation features and complex relationships between tables.
- Design and use queries to create a table, update, delete and append data. Refine queries using wildcards, parameters and calculations.
- Use controls and sub forms to enhance forms and improve functionality.
- Create report controls to perform calculations. Create sub reports and enhance report presentation.
- Enhance productivity by working with macros and use linking and importing features to integrate data.
- Know that different types of database models exist like: hierarchical, relational, object-oriented.
- Know the life cycle stages of a database: logical design, database creation, data entry, data maintenance, information retrieval.
- Recognize common business applications of databases like: dynamic website, customer relationship management systems, enterprise resource planning systems, website content management systems.
- Know the term SQL (structured query language) and understand its main use in querying database content.
- Create, modify, delete a lookup in a field/column.
- Create, modify, delete an input mask in a field/column.
- Set data entry for a field/column: required, not required.
- Create, modify, delete a one-to-one, one-to-many relationship between tables.
- Create, modify a many-to-many relationship using a junction table.
- Apply referential integrity between tables.
- Apply automatic update of related fields.
- Apply automatic deletion of related records.
- Apply, modify an inner join, outer join.
- Create, modify a subtract join.
- Apply a self join.
- Create, run a query to update data in a table.
- Create, run a query to append records to a table.
- Create, run a query to delete records in a table.
- Create, run a query to save selected data as a new table.
- Create, run a crosstab query.
- Create, run a query to show duplicated records within a table.
- Create, run a query to show unmatched records in related tables.
- Create, modify, run a one, two variable parameter query.
- Use wildcards in a query: [ ], !, -, #.
- Show highest, lowest range of values in a query.
- Create and name a calculated field that performs arithmetic operations.
- Group information in a query using functions: sum, count, average, max, min.
- Create, modify, delete bound controls: text box, combo box, list box, check box, option groups.
- Apply, remove bound control properties like: limit to list, distinct values.
- Create, modify, delete unbound controls containing arithmetic, logical expressions.
- Modify sequential tab order of controls on a form.
- Create, delete a linked subform.
- Format arithmetic calculation controls in a report: percentage, currency, to a specific number of decimal places.
- Apply a running sum for a group, over all.
- Concatenate fields in a report.
- Insert, delete a data field in group, page, report headers and footers.
- Sort, group records in a report by field(s).
- Force page breaks for groups in a report.
- Create, delete a linked subreport.
- Link external data to a database: spreadsheet, text (.txt, .csv), existing database files.
- Import spreadsheet, text (.txt, .csv), XML, existing database files into a database.
- Create a simple macro like: close an object and open another object, open and maximize an object, open and minimize an object, print and close an object.
- Assign/attach a macro to a command button, object, control.
The 10 week course is delivered in an evening.
Course Entry RequirementsIn order to take an Advanced ECDL module you do not need to have passed ECDL Level 2, however, you do need Intermediate skills as the course builds upon the knowledge and skills gained from basic ECDL. Ideally you should also be using the software as part of your daily work. By booking onto this Advanced Access course, you are agreeing that you are proficient in the following:
Manipulating Data, Reports and Macros, Automatically Creating and Modifying Forms, Integrating Access, Manually Creating and Modifying Forms, Finding and Ordering Data, Filtering
Basic Queries and Advanced Queries.
If you are not proficient with any of the above, please contact us before booking onto the course.
The college operates a no refunds policy as detailed below. Cancellations and transfer requests are subject to the following conditions:
- More than 4 weeks notice – no charge
- 4 weeks notice – 30% of the cost
- 2-3 weeks notice – 50% of the cost
- 1-2 weeks notice – 75% of the cost
- Less than 1 weeks notice – 100% of the cost
All cancellations must be made in writing and are subject to a £10 administration charge. The full fee’s policy is available on request.
What will I get at the end of the course?ECDL Unit Certificate upon successful achievement following examination.
What can I do next?ECDL Advanced – Excel
ECDL Advanced – Word
How much does it cost?This 10 week course is priced at £275.000 per delegate (including all tuition, Registration, ECDL Test fees (First Attempt) and Certification). (Prices Subject to Change)
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.