Learners will become familiar with the Access window, Navigation Pane, Ribbon, Quick Access toolbar, and File Backstage. Learners will learn how to create, edit, and save Databases, Tables, and Queries, as well as use Filters, Sort, Data Types, Field Properties, and create basic Criteria in Select Queries, and Multi-table Queries.
Course Topics:
- Understand database concepts
- Open an existing database
- Explore tables, queries, forms, and reports
- Preview and print Access objects
- Create a database from a template
- Create a database and a table manually
- Create a table from a template
- Manipulate table columns and rows
- Create a form by using the Form tool
- Refine form properties
- Change the arrangement of a form
- Collect data through e-mail
- Sort information in a table
- Filter information in a table
- Filter information by using a form
- Import information from another Access database
- Import information from an Excel worksheet
- Import or link to a SharePoint list
- Export information to another Access database
- Export information to Excel and Word
- Export information to a SharePoint list, a text file, an XML file, or an HTML file
- Copy information to other Office programs
|
Login/Create account
checkout
view cart (
0
)
