CIS 1323 Test 3 Review

CIS 1323 Test 3 Review - Adding Tables Creating field/table...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
TEST #3 Preview Access & PowerPoint
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Test #3 It will be just like the 2 nd Excel Test You will have files to download from Blackboard but will ONLY open the accdb file and complete the tasks You will create a PPT file from scratch You will submit the completed access db and the PPT files to the Digital Drop Box just like homework Manage your time!
Background image of page 2
Test #3 Study Tips The tasks that we do/discuss in class are the ones to know/remember Use the Hands-On Exercises in the book to prepare for the test tasks! Try to re-do the parts of the homework that involve the skills on the next slides By doing the Hands-On exercises and the Capstone Exercises – you are preparing for the test!
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Test Subject Weights Office 2007 Component % of Test Access 65% PowerPoint 35%
Background image of page 4
Access: Tables Creating a table from scratch Data for the table Importing an External Data file (xlsx/csv/text) ultimately creating a table
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Access: Relationships Closing all open tables Opening the Database Relationship Builder
Background image of page 6
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 8
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 10
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 12
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Adding Tables Creating field/table relationships enforcing Referential Integrity Access: Queries Simple Query Wizard Query Design Tool Adding Tables Selecting Fields Sorting Summarizing Grouping By Criteria Builder (creating fields) Access: Reports Simple Reports from tables Reports from a Query View by Group by Sort Field Sizing PowerPoint Skills Design Themes New Slides & Different Layouts Clip Art & Smart Art Shapes, Text Boxes, Fill Colors Tables Footers Test #3 Scoring The test document/handout will reflect how many points each task is worth Good Luck! Note: The homeworks are HARDER than the test will be! Grades will be posted on Blackboard ASAP including your course letter grade Remember to try to re-do ALL your homework assignments from scratch as the BEST way to prepare for the test. There will be Extra Credit too! Happy Holidays!...
View Full Document

This note was uploaded on 04/15/2008 for the course CIS CIS 1310 taught by Professor Jetton during the Spring '08 term at Texas State.

Page1 / 12

CIS 1323 Test 3 Review - Adding Tables Creating field/table...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online