Microsoft Access Training
Information is the lifeblood of every business. How will you to store and organize your information so it is secure and easily accessible? The answer is Microsoft Access.
Microsoft Access is a relational database program that can be used to maintain a simple list of records or manage large amounts of information. Access stores data securely and efficiently in tables that are linked and work as a single entity. Forms can be easily created and customized to enable easy and accurate data entry or information can be imported from spreadsheets, XML files, or other databases. Information can be viewed and sorted in multiple ways by using filters or running queries. You can also run reports based on selected criteria. Dynamic web pages can also be created to view, edit, enter, and analyze data over a company intranet or over the Internet.
Master Instructors can teach you the basics of Access or, if you are an experience user, teach you the more advanced topics. Check with the Master Instructor in your area for class outlines and prices.
Microsoft has determined that learning the following skills will make you an Access expert:
Structuring Databases
- Create Access databases
- Create and modify tables
- Define and modify field types
- Modify field properties
- Create and modify one-to-many relationships
- Enforce referential integrity
- Create and modify queries
- Create forms
- Add and modify form controls and properties
- Create reports
- Add and modify report control properties
- Create a data access page
Entering Data
- Enter, edit and delete records
- Find and move among records
- Import data to Access
Organizing Data
- Create and modify calculated fields and aggregate functions
- Modify form layout
- Modify report layout and page setup
- Format datasheets
- Sort records
- Filter records
Managing Databases
- Identify object dependencies
- View objects and object data in other views
- Print database objects and data
- Export data from Access
- Back up a database
- Compact and repair databases
