Access 2007 Essential Training

Wrangle your data by leveraging the power of Microsoft Access 2019. Learn how to use Access to build databases that help you store and retrieve your data more efficiently.

Introduction

• Building databases with Access
• What you should know

1. Getting Started

• Database concepts
• Create the database file
• Understand the Trust Center
• Digging into Ribbon tabs
• The database Navigation pane
• Customize the Quick Access Toolbar
• Create a database backup

2. Creating Tables

• Table structures and relationships
• Create a table and set data types
• Enter data
• Primary and foreign keys
• Importing tables

3. Setting Field Properties

• Relationships and referential integrity
• Editing table structure in Design view
• Control input with masks
• Set a default value
• Data validation rules
• Data lookup fields
• Additional field properties

4. Organizing Records

• Sorting table data
• Filtering table data
• Deleting records
• Searching and replacing values

5. Using Queries

• What are queries?
• The Simple Query Wizard
• Build queries in Design view
• Establishing constraints with criteria
• Specifying criteria with wildcards
• Incorporating AND and OR statements
• Filtering with mathematical comparisons
• Create flexible queries with parameters
• Build expressions
• Obtain summary statistics

6. Creating Forms

• Understand the role of forms
• Generate forms from tables
• Adjusting form elements in Layout view
• Using the Form Wizard
• Form Design view
• Find records

7. Creating Reports

• Introducing reports
• The Report Wizard
• Edit a report in Design view
• Edit a report in Layout view
• Group and sort records
• Creating calculated totals
• Apply conditional formatting rules
• Create labels
• Adjust print settings

8. Maintaining the Database

• Customize groups in the Navigation pane
• Compact and repair the database
• Examine database object relationships
• Document your thought process
• Print the blueprint of your database
• Split a database into front and back ends
• Protect the database with a password
• Set startup options

Conclusion

• Next steps