Access_Instructions

Access_Instructions - Access 2010 Practice Assessment...

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

View Full Document Right Arrow Icon
Access 2010 Practice Assessment Instructions Getting Started: Download and save the Access file called “ Holidays.accdb ” to your Desktop. Launch Microsoft Access 2010 and open this Access file from your Desktop. Click on Enable Contents button. Make the following changes to the Access database. WORKING WITH TABLES 1. Open the Trips table in the Design View. Set the TripID field as the primary key and format the DailyCost field to Currency . Save the changes to the Trips table design. 2. Go into Datasheet view to view the information stored in the Trips table. Change all the trips that are going to Orlando so that they are going to Miami instead. 3. Use the Table Design to create a second table (called Holidays ) with the following 3 fields as outlined below: Details for Field 1: Details for Field 2: Details for Field 3: Name: Destination Name: AverageTemp Name: DirectFlight Data Type: Text Data Type: Number Data Type: Yes/No Field Size: 10 Field Size: Integer Set the Destination
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

Access_Instructions - Access 2010 Practice Assessment...

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

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