Overview: You will create complex Access databases and create forms, reports, and macros.
Prerequisites:
Access 2
Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.
Course Content
Lesson 1: Structuring Existing Data
Import Data
Analyze Tables
Create a Junction Table
Improve Table Structure
Lesson 2: Writing Advanced Queries
Create Unmatched and Duplicates Queries
Group and Summarize Records Using the Criteria Field
Summarize Data with a Crosstab Query
Create a PivotTable and a PivotChart
Display a Graphical Summary on a Form
Lesson 3: Simplifying Tasks with Macros
Create a Macro
Attach a Macro to a Command Button
Restrict Records Using a Where Condition
Lesson 4: Adding Interaction and Automation with Macros
Require Data Entry with a Macro
Display a Message Box with a Macro
Automate Data Entry
Lesson 5: Making Forms More Effective
Change the Display of Data Conditionally
Display a Calendar on a Form
Organize Information with Tab Pages
Lesson 6: Making Reports More Effective
Cancel Printing of a Blank Report
Include a Chart in a Report
Arrange Data in Columns
Create a Report Snapshot
Lesson 7: Maintaining an Access Database
Link Tables to External Data Sources
Back Up a Database
Compact and Repair a Database
Protect a Database with a Password
Determine Object Dependency
Document a Database
Analyze the Performance of a Database