Learning objectives: – Learn all about an Access database and how it works. – Learn about each of the four objects in Access to understand how they interact with each other to create a fully functional relational database. – Familiarize yourself with the Access environment, including the Ribbon, Backstage view, Navigation pane, Document Tabs bar, and Record Navigation bar. – Learn how to to open and close an Access database, as well as how to open, close, and save objects. – Learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with. – Learn how to use forms to enter new records and view and edit existing ones. – Learn how to sort and filter data so you can customize how you organize and view your data. – Learn how to create a simple one-table query in Access. – Learn how to create a complex multi-table query in Access. – Learn how to modify and sort queries, as well as how to use the Totals function to create a query that can perform calculations with your data. – Learn learn how to create, modify, and print reports. – Learn how to use the Report Wizard to create complex reports and use Access formatting options to change the look of your report. – Learn how to create and rearrange table fields, as well as set validation rules, character limits, and data types. – Learn how to create and modify forms using options like design controls and form properties. – Learn how to add command buttons, modify form layouts, add logos and other images, and change form colors and fonts. – Learn how to create a database from an existing template and find resources to learn more about database design. – Learn how to create calculated fields and totals rows. – Learn how to run an Access parameter query to find the data you need using variable criteria in your search terms. – Learn how to run an Access duplicates query to erase duplicates and strengthen your database. – Use this quick reference guide for 20 of the most common criteria used in Access queries. – If you’re considering purchasing Office 2016, learn about some important changes you should know about. – Test your knowledge of Access by taking our quiz.
Most frequent questions and answers
Co-operative education is a three-way partnership between the university, students and employers. Students apply their classroom knowledge in a series of four-month work experiences. You, the employer, enhance a student’s education, while reaping the unique benefits of CO-OP employees.
- Year-round access to well-motivated, qualified employees.
- Access to potential full-time staff in a controlled environment, reducing your costs and risks.
- Access to a cost-effective source of temporary employees for peak periods or special projects.
- A say in what students learn by working with the university.
- Promotion of your organization as one that believes in developing the potential of young people.
- Access to a great pool of French-speaking, English-speaking and bilingual students.
Most work terms run at least 15 weeks, or four months. They can be no shorter than 13 weeks. Some master’s students, as well as some science and engineering students, are available for 8 or 12 months’ work terms.
All jobs are reviewed by a CO-OP Program Coordinator, and only those providing students with work experience related to their professional development are approved. Administrative activities involved in a job should be less than 10% of the entire workload.
When you first contact SSC, you are assigned one of our Program Coordinators, depending on your discipline of interest. This person is your main contact in our office. As you move through the recruitment process, you also work with a representative from CO-OP Administrative Services, who assists with job posting and interview scheduling.