Courses / Access 2002 Advanced
Access 2002 Advanced
- Provider
- Solveway
- Course ID
- 084402
- Summary
- Your training in and use of Access has provided you with a solid foundation in the basic and intermediate skills for working in Access. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities.
Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities
About the Course
- Target
- This course targets persons who have job responsibilities that include structuring existing data into properly designed tables, analyzing data, automating work in Access, implementing advanced form and report capabilities, and using Access tools. Persons who have some or all of these responsibilities and who perform these tasks for their own work or in support of less-advanced Access users.
- Entry requirements
- This course targets persons who have job responsibilities that include structuring existing data into properly designed tables, analyzing data, automating work in Access, implementing advanced form and report capabilities, and using Access tools. Persons who have some or all of these responsibilities and who perform these tasks for their own work or in support of less-advanced Access users.
- Outcome
- You will use advanced capabilities of Access to work with improperly structured data, perform summary operations on data, create macros to automate tasks, enhance forms and reports, and use Access data in other Office applications
- Qualifications
- Certificate of attendance
- Content
- Lesson 1: Structuring Existing Data
Topic 1A: Use the Table Analyzer Wizard for Help
Topic 1B: Decide on Your Own Design
Topic 1C: Create a Junction Table
Topic 1D: Modify the Original Tables and Complete the Design
Topic 1E: Compact and Repair a Database
Lesson 2: Summarizing Data
Topic 2A: Group and Summarize Records in Different Ways
Topic 2B: Summarize with a Crosstab Query
Topic 2C: Pivot Query Results
Topic 2D: Display a Graphical Summary on a Form
Lesson 3: Simplifying Tasks with Macros
Topic 3A: Create a Macro
Topic 3B: Attach a Macro to a Command Button
Topic 3C: Restrict Records
Lesson 4: Adding Interaction and Automation with Macros
Topic 4A: Require Data Entry with a Macro
Topic 4B: Display a Message Box with a Macro
Topic 4C: Automate Data Entry
Lesson 5: Making Forms More Usable
Topic 5A: Change the Display of Data Under Certain Conditions
Topic 5B: Display a Calendar on a Form
Topic 5C: Organize Information with Tab Pages
Lesson 6: Making Reports More Powerful
Topic 6A: Cancel Printing of a Blank Report
Topic 6B: Include a Chart
Topic 6C: Arrange Data in Columns
Topic 6D: Distribute Reports as a Snapshot
Lesson 7: Expanding the Reach of Your Data
Topic 7A: Merge Access Data with a Word Document
Topic 7B: Publish Access Data as a Word Document
Topic 7C: Analyze Access Data in Excel - Cost
- Deals Available for Single and Group Bookings.
Please call 0203 015 4316 or email us at info@solveway.co.uk for our latest deals - Enrolment
Availability
- Duration
- 1 Day
- Provider
- Solveway
Venues/Contact
Company registered address.
20, Heathcliff Avenue
Fairfield Park
Stotfold
Hertfordshire
SG5 4EY
UK
Telephone 0203 015 4316
Email info@solveway.co.uk
Website www.solveway.co.uk
Courses
Syndicate
