Access 2007 Part 4: Advanced Features
Pluralsight
Course Summary
Part 4 of 5 in the Access 2007 series. If you are tasked with building a new database, fixing your company's Access database, or just wish to ditch the bulky Excel spreadsheet, this is the course for you.
-
+
Course Description
Part 4 of 5 in the Access 2007 series. If you are tasked with building a new database, fixing your company's Access database, or just wish to ditch the bulky Excel spreadsheet, this is the course for you. This course will teach you to track and report data more efficiently by walking you through the database design process, teaching you how to build tables and forms to enter data, and how to design queries and reports to retrieve and view data. No experience with Access or database design is necessary; however, experience with Microsoft Office applications and data entry is helpful.
-
+
Course Syllabus
Creating PivotTables and PivotCharts- 52m 39s
—Creating a PivotTable 16m 21s
—Modifying a PivotTable 13m 42s
—Creating a PivotChart 21m 49s
—What We Covered 0m 47sCreating Basic Forms- 1h 53m
—Form/Report View 4m 8s
—Ways to Create Forms 2m 9s
—Tour of Create Tab Form Options 10m 24s
—Using the Form Wizard 5m 24s
—Creating a Form from Design View 10m 20s
—Parts of a Form 2m 13s
—How to Modify/Edit Forms 14m 1s
—Adding Form Controls 4m 7s
—Creating a Calendar Control 42m 24s
—Creating Command Buttons 7m 18s
—Setting Form Properties 7m 41s
—What We Covered 3m 6sDesigning Macros- 57m 44sCreating Basic Reports- 1h 32mCreating a Switchboard- 42m 24s