You will learn how to use Access to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
This course is suitable for anybody wanting to learn 2013, 2010 or 2007, as it cover all the aspects and differences between the versions.
Instructor led, group-paced, classroom-delivery learning model with structured... more details
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Target Students
This course is designed for students who wish... more details
This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
Prerequisites
To ensure success, students should be familiar with... more details
To ensure success, students should be familiar with using personal computers, and should have experience using a keyboard and mouse. Students should be comfortable in the Windows® 8 environment, and be able to use Windows 8 to manage information on their computers. Specific tasks the students should be able to perform include: launching and closing applications, navigating basic file structures, and managing files and folders.
This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets. The Microsoft Certified Application Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.
Course Objectives
Upon successful completion of this course, students will... more details
Upon successful completion of this course, students will be able to:
Identify the components of the Microsoft Access environment.
Identify the components of a database.
Organize data in tables.
View data in tables.
Query a database.
Design forms.
Generate reports.
Course Content
Lesson 1: Getting Started with Access
Topic A: Orientation... more details
Lesson 1: Getting Started with Access
Topic A: Orientation to Microsoft Access Topic B: Create a Simple Access Database Topic C: Get Help in Microsoft Access
Lesson 2: Working with Table Data
Topic A: Modify Table Data Topic B: Sort and Filter Records Topic C: Create Lookups
Lesson 3: Querying a Database
Topic A: Join Data from Different Tables in a Query Topic B: Sort and Filter Data in a Query Topic C: Perform Calculations in a Query
Topic A: Create a Report Topic B: Add Controls to a Report Topic C: Enhance the Appearance of a Report Topic D: Prepare a Report for Print
Lesson 6: Customizing the Access Environment
Topic A: The Access Options Dialog Box
Locations
Training courses take place at the following locations... more details
Training courses take place at the following locations including Nottingham, London, Birmingham, Manchester, Leeds, Liverpool, Sheffield, Leicester or Your Office
What you get
Professional Microsoft Certified Trainer
Comfortable Premises, equipped with all the technology you need