Microsoft | Access Training

Course curriculum

1. Create a database in Access
2. Add a primary key to a table in Access
3. Backup your database in Access
4. Create a query, form, or report in Access
5. Learn more about Access
1. What is Access?
2. Get started with databases
3. Get to know database objects
1. Decide whether to create a desktop database or an Access web app
2. Video: Create an Access desktop database
3. Create an Access web app
1. Build tables and set data types
2. Build tables with Table Designer
3. Combine fields using the Calculated data type
1. Get started with table relationships
2. Create relationships with the Lookup Wizard
3. Create relationships with the Relationships Pane
4. Create many-to-many relationships
5. Create one-to-one relationships
1. Copy data from Excel
2. Link to shared data
1. Get started with queries
2. Create basic queries
3. Create queries with more than one data source
4. Create queries with outer joins
5. Query unrelated data sources
1. Create navigation forms
1. Create basic reports
2. Modify and print reports
1. Create a column chart
2. Create a bar chart
3. Create a line chart
4. Create a pie chart
5. Create a combo chart
1. Back up databases

Enroll today