About the Class:
This course is for anyone wanting to develop proficiency with Microsoft Access. In-class activities will require you to use the latest version of Microsoft Access to create and edit a database document according to specific requirements provided.
What You’ll Learn:
Upon completion of this class, participants will:
- Gain a basic understanding of a database, and when to use it.
- Understand the purpose of tables, queries, forms, and reports.
- Use an existing data base.
- Look at the design of tables, forms, reports, etc.
- Change, add, delete, sort, and filter records.
- Find basic information from a db searching or using filters.
- Create a small database using a template.
- Enter a few records using the switchboard.
- Examine the design of a form.
- Create a new database
- Add desired fields into a table.
- Enter data into a table.
- Create a form to make data entry easier.
- Create and browse a report.
- Use the design view to modify a report
- Preview and print a report.
- Create a query.
- Create a form and add a record.
- Create a report that generates labels.
- Create and save a query that shows all people not living in your most frequent city.
- Include at least one picture someplace.
- Sort the database.
What You Need to Know:
- Basic keyboarding and mouse skills are required.
If you don’t have those skills, consider first taking the workshop:
|Access 2010(PC)||Access 2012(Mac)|
|Microsoft Office: Make the Switch to Access 2010|
|Microsoft Office: Basic Tasks|
|Microsoft Office: Create Tables for a New Database|