Microsoft Access Introductory
Time & Location
About the Course
Microsoft Access is a relational database that can help you and your organization collect and manage large amounts of data. Access is a versatile tool. Use it as a personal management tool or use it as a construction set to develop applications for an entire department or organization. This course focuses the user on how to manage their data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
COURSE CONTENT
GETTING STARTED WITH ACCESS
• Orientation to Microsoft Access
• Create a Simple Access Database
• Get Help in Microsoft Access
WORKING WITH TABLE DATA
• Modify Table Data
• Sort and Filter Records
• Create Lookups
QUERYING A DATABASE
• Join Data from Different Tables in a Query
• Sort and Filter Data in a Query
• Perform Calculations in a Query
CREATING ADVANCED QUERIES
• Create Parameter Queries
• Create Action Queries
• Create Unmatched and Duplicate Queries
• Summarize Data
GENERATING REPORTS
• Create a Report
• Add Controls to a Report
• Enhance the Appearance of a Report
• Prepare a Report for Print
CUSTOMIZING THE ACCESS ENVIRONMENT
• The Access Options Dialog Box
- 4 or more Course Participants$299+$38.87 HST$299+$38.87 HST0$0
- 2 - 3 Course Participants$399+$51.87 HST$399+$51.87 HST0$0
- Course Calendar Date Pricing$299+$38.87 HST$299+$38.87 HST0$0
- 1 on 1 Training$499+$64.87 HST$499+$64.87 HST0$0