Booking Enquiry
Microsoft Access 2010 - Level 2
Overview
Students will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.
Who Should Attend?
This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.
Course Outcome
Upon successful completion of this course, students will be able to:
- Restructure data into appropriate tables to ensure data dependency and minimize redundancy
- Restructure data into appropriate tables to ensure data dependency and minimize redundancy
- Write advanced queries to analyse and summarize data
- Create macros
- Customize reports by using various Access features
- Maintain your database using Access tools
Course Content
Lesson 1: Structuring Existing Data
- Restructure the Data in a Table
- Create a Junction Table
- Improve the Table Structure
Lesson 2: Writing Advanced Queries
- Create Sub-queries
- Create Unmatched and Duplicate Queries
- Filter Records Using Criteria
- Summarize Data Using a Crosstab Query
- Create a PivotTable and a PivotChart
Lesson 3: Simplifying Tasks with Macros
- Create a Macro
- Attach a Macro
- Restrict Records Using a Condition
- Validate Data Using a Macro
- Automate Data Entry Using a Macro
Lesson 4: Creating Effective Reports
- Include a Chart in a Report
- Print Data in Columns
- Cancel Printing of a Blank Report
- Publish a Report as a PDF
Lesson 5: Maintaining an Access Database
- Link Tables to External Data Sources
- Manage a Database
- Determine Object Dependency
- Document a Database
- Analyse the Performance of a Database
What happens next?
Once you have clicked above and sent us your enquiry, our team of advisors will then review your specific needs and email the details that best suit you. We may need to contact you to clarify requirements prior to processing the enquiry.
Once you have clicked above and sent us your enquiry, our team of advisors will then review your specific needs and email the details that best suit you. We may need to contact you to clarify requirements prior to processing the enquiry.
Telephone Hotline
01933 233884
(Monday to Friday - 8:00am to 5:30pm).
© 2024 Book My Course Limited. All rights reserved
Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy
