Access Training

Getting Started

Training begins with a brief overview of the various Access user interface functions including task panes, personalized menus, object lists and toolbars. Students then learn how to open existing databases and how to access system help.

Designing Databases

This training section teaches various database creation concepts and considerations. Students learn key database terminology, such as relational database, fields, data types, primary keys and tables. Finally students acquire hands-on training in database development both from scratch and using the software’s table wizard. Other topics include table print and preview.

Working with Tables

A database is only useful when administrators and designers can manipulate the way data is presented. This portion of training focuses on ways designers can select and move data within tables or utilize MS Access to show relevant data.

Working with Records

Database records are fields of table entries that relate to one another. This course section shows students how to work with table or form records. Students also learn how to find, replace, add, delete, sort and filter records.

Enhancing Tables

Although databases are designed for text data, Microsoft Access lets you store other types of data objects. Students learn how to insert and retrieve images, videos and hyperlinks from tables. They also gain the skills necessary to import and export data to and from various applications. Students acquire hands-on experience modifying various database table aspects, i.e. setting field properties and masking input.

Working with Queries

Queries help database administrators retrieve and manipulate data. They’re more powerful than filters, assisting in the operation of columns within tables. This is an essential database feature, dramatically reducing search time. In this section, students learn query requirements and ways to use them to view, sort, calculate and group fields.

Working with Reports and Forms

Viewing data within large tables can be difficult, with modifications prone to error. With forms, you can present data on the screen in an organized and attractive manner, expediting data additions and edits. With reports, you can display table or query output in a print-ready, formatted layout. This section teaches students how to efficiently create and use forms and reports.

Enhancing Reports and Forms

Reports and forms can be designed in seemingly unlimited ways using Access. In this class, you learn about additional tools used to enhance these, like the formatting toolbar, toolbox, calculated controls and auto formatting.

Prerequisites:

• A solid understanding of Windows’ file management, the concepts of right-clicking and selecting object properties

Related MS Office Classes in Sacramento:

• Access Training Intermediate
• Excel Training Intro
• Excel Training Intermediate
• Excel Training Advanced
• PowerPoint Training Intro
• PowerPoint Training Intermediate
• Word Training Intro
• Word Training Intermediate