In this course, students will learn how to use Access 2010 to manage your data, including creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.
- Orientation to Microsoft Access
- Create a Simple Access Database
- Get Help in Microsoft Access
- Modify Table Data
- Sort and Filter Records
- Create Lookups
- Join Data from Different Tables in a Query
- Sort and Filter Data in a Query
- Perform Calculations in a Query
- Create Parameter Queries
- Create Action Queries
- Create Unmatched and Duplicate Queries
- Summarise Data
- Create a Report
- Add Controls to a Report
- Enhance the Appearance of a Report
- Prepare a Report for Print
- The Access Options Dialog Box
- Relational Database Design
- Create a Table
- Create Table Relationships
- Create Query Joins
- Join Tables That Have No Common Fields
- Relate Data within a Table
- Work with Subdatasheets
- Create Subqueries
- Data Normalisation
- Create a Junction Table
- Improve Table Structure
- Import Data in Access
- Export Data to Text File Formats
- Export Access Data to Excel
- Create a Mail Merge
- Organise Report Information
- Format Reports
- Include Charts in a Report
- Add a Calculated Field to a Report
- Add a Subreport to an Existing Report
This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2010, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
Students should be familiar with using personal computers and have used a mouse and keyboard. Students should be comfortable with the Windows environment and be able to use Windows to manage information on their computer. Specifically, students should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.
Upon successful completion of this course, students will be able to:
- Identify the basic components of an Access database
- Build the structure of a database
- Manage data in tables
- Query a database
- Design forms
- Generate reports
- Streamline data entry and maintain data integrity
- Join tables to retrieve data from unrelated tables
- Create flexible queries to retrieve data and modify tables
- Improve the functionality of Access forms
- Customise reports to organise the displayed information and produce specific print layouts
- Share data between Access and other applications
Register
Not currently scheduled
Fast track the availability of this course.
Add to watch list or call 1300 794 006.
Add to watch list or call 1300 794 006.
Request a Quote
About Microsoft On-Demand Learning
Build your Microsoft technical expertise while balancing the demands of your schedule. The new MOC On-Demand series courses combine high-quality video lectures, live hands-on labs and knowledge-checks in a self-paced format to help you build skills as your schedule allows—all at once or five minutes at a time.
MOC On-Demand at a Glance
Self-Paced Learning
The modular structure offered by MOC On-Demand courses lets learners complete training piecemeal or in an order they choose.
Immediate Feedback on Mastery
Knowledge checks at the end of each module and each course tell learners whether they’ve mastered the content and are ready to move on.
SATV Eligible
Similar to In-class Microsoft official curriculum courses, MOC On-Demand is eligible for payment via Software Assurance Training Vouchers (SATVs)
Direct From the Source
MOC On-Demand is brought to you by the people who wrote the software. The content is based on the official Microsoft official curriculum (MOC).
Learn Anywhere Anytime
The high-quality in-depth video content, labs and knowledge checks are all available to you via the cloud 24 X 7.
Live Hands-on
Labs
Unlike other on-demand offerings that offer simulated labs, MOC On-Demand gives customers a live, real-time environment for hands-on training.
