Microsoft Access® Introduction starts Tuesday September 23. Seats still available.
Learn your database fundamentals with Microsoft Access! You have your data and want to use the computer to organize it in ways that will allow you to capture, manipulate and analyze it easily.
Microsoft Access allows you to capture, manipulate and analyze data easily. Learn the fundamental concepts, terminology, objects and tools that make up a database. Design and create tables, queries, forms and reports, and get an introduction to the standard language of databases: SQL.
Duration: 12 hours Location: Robson Square
- Data Normalization
- Database terminology
- Access 2010 / 2007 User Interface
- Create Access databases
- Open database objects in multiple views
- Move among records
- Format datasheets
- Viewing and Organizing Information
- Enter, edit, and delete records
- Create queries
- Sort records
- Filter records
- Creating and Modifying Tables
- Add a predefined input mask to a field
- Create Lookup fields
- Modify field properties
- Defining Relationships
- Create one-to-many relationships
- Enforce referential integrity
- Creating and Modifying Queries
- SELECT queries
- Multiple Tables
- Calculated expresssions
- SELECT queries
- Creating and Modifying Forms
- Create/Display Forms
- Modify Form properties
- Producing Reports
- Create and format reports
- Add calculated controls to reports
- Preview and print reports
- Integrating with Other Applications
- Import data to Access
- Export data from Access
Please note: We will be using Access 2010 during this course. If you are using Access 2003 or earlier, you will find that the principles will be applicable, but the user interface will be different.
Some experience with Microsoft Windows and a mouse.
Experience with Excel will be an asset but is not required.