Access 2010 Essentials
Welcome to the Microsoft Access2010Essentials course. Access is the world’s premier database software. You can use Access to create and edit databases -- just download a ready-made database template and start typing. It’s that easy. You can create a database of contacts, expenses, household and/or business inventory. In other words, if you have data, you can create a database of that data using Access. Microsoft’s newest version of Access uses the new ribbon interface, and offers significant improvement to its database capability.
Course Objectives
Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly.
By the end of this course, participants should be able to:
- Understand common database terms
- Open and close Access
- Create a blank database or a database from a template
- Understand the interface and the Ribbon tools
- Understand the Backstage View
- Use the Navigation Pane
- Work with database objects
- Sort and filter the view
- Create a blank table from a template, in Datasheet view, and Design View
- Use Lookup columns in a table
- Add information to a table
- Edit, delete and search records
- Save a table
- Create a Navigation Form
- Create a form with the Wizard and in Layout View
- Modify a form in Design View
- Perform common formatting tasks on forms
- Use Themes
- Add or move controls on a form
- Create reports using the Report Wizard
- Understand the Report Design View
- Add a Logo to a report
- Create Queries using the Wizard
- Execute a Query
- Understand the Query Design View
- Understand Access file formats and save a database as another file format
- Print an Object
- Back up the database
- Email the database
Categories
Microsoft Access