Description

Prepare for the Microsoft Office Specialist Access 2013 exam and use the challenge files included in the course to practice your Access skills.

Tags

Syllabus

Syllabus IntroductionWelcomeWhat you should know before watching this courseUsing the exercise filesUsing the challenges1. Microsoft Office Specialist Exam OverviewCompare the Microsoft Office Specialist certificationsPrepare for the examReview the exam objectives and format2. Create and Manage a DatabaseCreate a new databaseSet up the primary keyManage relationshipsNavigate through a databaseProtect and maintain a databaseSave and export a databaseChallenge: Create a databaseSolution: Create a database3. Build TablesCreate a new tableFormat a tableManage recordsCreate and modify fieldsChallenge: Build tablesSolution: Build tables4. Create QueriesWork with simple select queriesCreate multi-table queriesCreate crosstab queriesModify a queryUtilize calculated fields and group within a queryChallenge: Create queriesSolution: Create queries5. Create FormsCreate basic formsCreate navigation forms and split formsSet form controlsFormat formsChallenge: Create a formSolution: Create a form6. Create ReportsCreate a reportSet report controlsFormat a reportChallenge: Create a reportSolution: Create a report7. Final Practice ExamChallenge: Full-length practice examSolution: Full-length practice examConclusionNext steps Read more