How to add or delete a Field in Design View in Access

Table Of Content

• Add Fields to the Table
• Set the Field Properties for an Existing Table
• How Do I Create a Table in Access in Datasheet View?
• Step 1- Click on Table Design Option
• Access Versions
• Datasheet View

The following steps demonstrate how to switch to Design view. Take a break if youlike, but don't forget to save. When you come back, we'll create the nexttable and link them together.

Add Fields to the Table

This dialog is shown in Figure 165 with a currency format chosen, which might be appropriate for the Amount field. Also, be sure to set up both DateCreated fields with the same properties as on the Customers table. This is one of the most powerful things about Access (and all relational database management systems). Relationships provide an efficient way to store data, as you can enter data once, then reference it from elsewhere in the database. When you switch to Design View, you will be prompted to save your changes (if you haven’t already done so).

Set the Field Properties for an Existing Table

If there is no caption, then the heading used in displays of data is the field name. Sometimes the field name is not what you want your users to see. For example, instead of the heading deptCode above a list of department codes, you may prefer to use the words Department Code. To accomplish this just enter such a heading in the caption property for the field. If a field contains date and or time values, then the Date/Time data type should be chosen. The Format property (discussed later) allows you to control how these values will appear to the user.

How Do I Create a Table in Access in Datasheet View?

Once the table has been configured, be sure to save it. In any case, you will be prompted to save it when you try to switch to Datasheet View or close the table. It provides a different view of the table to Datasheet View, and is typically used to configure the table. Now we have a new row; edit the row with a field name.

Step 1- Click on Table Design Option

If this happens you must view the table in Datasheet View and find the duplicated value and make necessary changes. To set a primary key the table must be open in Design View. You must first select the field (or combination of fields) and then click the Primary Key icon. This is straightforward for the Department table, but not for the Course table because its’ primary key comprises two fields. Because the PK involves more than one field we say this primary key is composite. Consider the firstName and lastName fields in the Member table of the Library database.

Access Versions

When individuals want to add Fields to their table, they usually add fields in the Design view. The Design View allows you to design and set up the database. The Design View is where you configure your table, forms, reports, etc. You can see that we have configured just two of many options in this pane.

How to use, modify, and create templates in Word - PCWorld

How to use, modify, and create templates in Word.

Posted: Wed, 22 Jan 2020 08:00:00 GMT [source]

Other DB Tutorials

On the Design View interface, we want to add a new field below the Telephone field name. Expressions can be quite complicated, so Access provides the Expression Builder which helps you build expressions by “point-and-click”. Dummies has always stood for taking on complex concepts and making them easy to understand.

Ken Cook is a professional database developer, instructor, and author. The two experts have teamed to write the previous three editions of Access For Dummies. Get it right the first time and you’ll save yourself a lot of aggravation down the road.

Create a new Table in Design View

This is where you set up and configure your tables, forms, reports, etc. The Loan table has fields that are defined with the DateTime datatype. Experiment with different formats for these dates. In order to set the field as the primary key, simply right-click the field & select the Primary Key. But there are some things that are just easier to do in Design View.

Its attributes will be about thecharacteristics of the specific recordings in your collection. Well, there’re two views available while working with the tables in MS Access, one is the Design view & another is the Datasheet view. However, if you want to switch from Datasheet view to design view or vice-versa then click on a down arrow that you can see next to a View button on a toolbar.

The Text data type provides for values that have fewer than 256 characters. You might remember that the fields with the little key icon are called primary keys (they are the unique identifier for the table). Well, the fields that link to those are called foreign keys. A Table is anentity (thing) that has attributes (fields) that fit together.

The Format property tells Access what format to store the data in. By using General Date, we tell Access to store this field in a general date format. When you click on a field, the field’s properties will be displayed in the bottom frame. You'll also see that the Ribbon now has a DESIGN tab with a new set of design-related options.

You can also use Design View to edit any existing table. Whether the table was created in Design View or Datasheet View doesn't matter. To add and delete fields in Design View in Microsoft Access, follow the methods below. In Access, fields can be added and removed from the list of available fields. If you don’t select that option, the system won’t check the data and you could end up with lots of orphaned records.

A field is aspecific category that should have a name that makes sense. In a musiccollection database, "Artist" or "Artists" would be goodfield names. If the data type is AutoNumber you can use New Values to specify whether the next value for the field will be the next highest integer, or if it will be a random integer. If the data type is Date/Time, then this selection enables the user to select a date using a picker – a convenient tool for data entry. Yes, the tables can be created in both Datasheet view as well as Design view.

Design View is a more flexible method for creating a new table, in which you directly enter information about each field in the table. We will use this method for the rest of the tables of our database. Strictly speaking, it is possible to have linked fields with non-matching data. You could allow this by disabling the Enforce Referential Integrity option on the Edit Relationships screen while setting up the relationship. So go ahead and create two more tables using the same steps you used to create the first table. Click the View icon to return to Datasheet view, and we'll look at the options for adding data to our table.

You can, via the New Values property, arrange the numbers to be generated sequentially or randomly. Often control numbers for things like orders, invoices, registrations, etc. are numeric and we can leave it to the system to generate a next value for us. If a field is used for storing values that are used in numerical calculations (e.g. quantity ordered) then Number is appropriate. The Field Size property (properties are discussed later) can be used to limit the number of storage locations used per value. Creating a table in MS Access using a query is not an easy task as you think it is. To make it simpler, we have below discussed the complete steps for how to create table in MS Access using query.

2 2: Using Design View to Create Tables Engineering LibreTexts

Table Of Content

• Can Tables Be Created in The Datasheet View and The Design View?
• Creating fields
• Set the Field Properties for an Existing Table
• MS Access 2016 Tutorial
• Setting data types

Moreover, you can change each & every field’s properties. To create a column in the Design View, click an empty cell under Field Name and type the desired name. So now that we've established that Design View and Datasheet View are just two ways of looking at the same table, let's go ahead and create a table in Design View.

Can Tables Be Created in The Datasheet View and The Design View?

Validation rules and validation text are important features to assist database users. If a field will contain monetary values then the Currency data type should be chosen. This data type provides for numeric calculations that are accurate to 15 digits to the left of the decimal and 4 digits to the right of the decimal. You should still be in Design View for the Department table. Note that you can press the F1 function key to get help pertinent to the location of the mouse cursor. If your cursor is positioned on a Field Name and you press F1 you will see a window pop open that displays suggestions from MS Access regarding how you should name fields.

Creating fields

20 independent magazines that every creative should have on their coffee table - Creative Boom

20 independent magazines that every creative should have on their coffee table.

Posted: Mon, 31 Jan 2022 08:00:00 GMT [source]

Though by following the simple steps mentioned below in this post, you can add a new table in design view in a hassle-free manner. If you specify that a field has the Text data type then Access will permit any characters to be placed in that field in a row of the table. This is a common choice when the data will not be used in calculations.

Set the Field Properties for an Existing Table

If some value for a field is very common then you should consider setting a default value. For example, if most courses are 3-credit hour courses then the value 3 can be set as the default for all new courses. This data type restricts possible values to yes or no. If you choose AutoNumber MS Access will generate a value for you when a row is inserted into the table.

MS Access 2016 Tutorial

You may have noticed the little key icon next to the CustomerId field. A primary key is a unique identifier field for the table. No two records can contain the same value in their primary key field. This becomes crucial when establishing relationships between tables. You can use Design View to create a tables, set up data types for each field, specify default values, specify how data should be entered and displayed, and more.

Database-driven Navigation Bars Using Text & Images - Princeton University

Database-driven Navigation Bars Using Text & Images.

Posted: Fri, 11 Feb 2011 20:46:51 GMT [source]

We have just set a default value for the DateCreated field. This means that, whenever a new record is entered, this field will automatically be populated with the current date and time. We have also specified a format for all dates that are stored in this field. Design view enables you to design and set up your database (kind of a "behind the scenes" view of your database).

Suppose the University uses 3 and 4 character values for department codes. In this way we can limit the kinds of errors users make when they enter data and thus improve the overall quality of our database. Add a field, paperback, that can be used to indicate whether or not a book is a paperback. Now you will see how to enter such values – MS Access provides a box that is to be checked, or not. You can select (a ‘Yes’) using the mouse or by using the space bar. When users create an Access database, the data is stored in the table.

Then, click the field updates from a bottom sheet with properties for a specific field. First of all, you have to click on Table Design option (from a Create tab).

Relationships

Dummies helps everyone be more knowledgeable and confident in applying what they know. In this section we will step through the process of creating a table. From the web page for these notes download and open the MyUniversity Database.

Also, you might find that you prefer to do certain tasks in Design View and other tasks in Datasheet View. Shantel has studied Data Operations, Records Management, and Computer Information Systems. Her goal is to become a Database Administrator or a System Administrator. Right-click the field that contains Address and selects Insert Rows.

Modify the caption for these fields to be First Name and Last Name respectively. You will see these captions at the top of their respective columns. Consider the deptName field of the Department table. If a user enters data for a new department then it is unreasonable for the deptName field to not have a value. To ensure there will be a value we make the field required – i.e. we choose Yes for the Required property.

After that, choose a view that you wish from a drop-down list. Input masks are type of expression that allows you to specify exactly how data should be entered into a field. For example you could set it up so that users can only enter dates in a certain format, phone numbers in a certain format, etc. If MS Access rejects your primary key then you must examine the values you previously entered for deptCode – there must be some duplicated value.

You might have noticed the little "key" icon to the left of the CustomerId field. A primary key ensures that the data in this column is unique - no two values can be the same. This is important for when you want to perform queries or run reports against the table, and it is vital for establishing relationships with other tables. Save the table and enter datasheet view so you can test out the datatype you have just created. You will notice the user sees a drop down list containing Male and Female, and so the user cannot enter/select an inappropriate value.

However, creating a table in Design View mode is an outdated method. So, if you want to create a table in this era, then it is suggested to create a table in Datasheet view. The Field properties will help you to specify the default value for each field, create the input mask and even stipulate whether it is an essential field, etc. Now, the properties shown in a bottom pane will be changed, it is completely depending on a file type of a selected field.

The first time you do this, you will be prompted to provide a name for your table. Laurie Ulrich Fuller is a professional technology author and trainer. She's created training materials that cover Microsoft Office and Adobe Creative Suite.

The 11 Best Luxury Cruise Lines, According to T+L's Experts

Table Of Content

• Best cruise ships and cruise lines of 2023, according to readers
• The best cruises of 2022, according to U.S. News & World Report
• These Are the Best Cruises of 2024, According to T+L's Expert

The publication evaluated 17 cruise lines through a combination of expert evaluations (30%), traveler reviews (50%) and health ratings published by the U.S. Centers for Disease Control and Prevention's Vessel Sanitation Program (20%). Complementing the itinerary will be gourmet Pacific Northwest cuisine and more than 40 regional wines curated by an onboard culinary team.

Best cruise ships and cruise lines of 2023, according to readers

For instance, SeaDream's intimate yachts can stealthily visit ports that large ships can't manage. Regent Seven Seas packs all-inclusive gourmet dining and suites into their luxury offerings. While Scenic Eclipse makes adventurous expedition sailing a posh white-gloved affair. To help you navigate the waters of luxury cruises (and to help you find the best pampering cruise ship), check out the seven best luxury cruises sailing right now. The line's ships are sleek and modern, and sail to some of the world's most interesting ports of call.

The best cruises of 2022, according to U.S. News & World Report

Before the pandemic, about 10% of people that had never cruised said they "never" would. According to the survey, this number rose to 17% in June 2021, but fell to 14% by August. Pre-pandemic, 62% of people who had never cruised indicated they wanted to try it.

These Are the Best Cruises of 2024, According to T+L's Expert

The ship is small enough to access private ports at remote beaches and take travelers well off the beaten path. Named the best small-ship ocean cruise line in T+L's 2022 World's Best Awards, Golden said the line is known for Tahitian-inspired massage techniques in the onboard spa and noted that cruisers particularly love the wonderful staff. Oceania Cruises has just seven ships, but the debut of the brand-new Oceania Vista catapults this cruise line into the luxury division. The cruise line's relatively new Go Local shore excursions for small groups bring travelers to under-the-radar destinations, T+L contributing editor and long-time cruiser Sarah Greaves-Gabbadon reported recently.

River Awards

In fact, Silversea's butlers take white-glove service to a whole new level — they'll handle your laundry with more care than you do, scour port towns to find your favorite tastes of home, and even help you pack and unpack your suitcase. Further, Silversea's new culinary program, nicknamed S.A.L.T. (for Sea and Land Taste), brings the taste of destinations on board through cooking classes. Of course, there's no need to cook for yourself aboard a Silversea ship, as each one features several restaurants with multi-course menus to whet your appetite every night. Carnival Cruise Line caters to families and casual cruisers with its fleet of ships. Sky Princess carries up to 3,660 passengers on itineraries around Europe and the Caribbean.

How travelers can use the list

Cruise Critic is an online cruise community with more than 650,000 ship reviews of 700 ships from experts and cruise aficionados. For the best in-suite views, book a room at the back of the ship, Kelly Cochrane, executive chef of Regent Seven Seas Cruises tells T+L. Meena Thiruvengadam is a lifelong traveler and veteran journalist who has visited more than 50 countries across six continents. Her writing has appeared in The Wall Street Journal, Departures, TripSavvy, and other publications. These are the best cruise lines in the world, according to the 2023 Readers' Choice Awards.

More In CNBC Travel

It's a self-contained cooking school at sea that offers hands-on experience at 12 individual cooking stations (two people per station). Classes focusing on a variety of topics do incur an extra fee, but get rave reviews from past participants. Impressively, all the top lines that readers chose as the best cruise lines for large ships are WBA Hall of Fame honorees. Read on to find out why Disney Cruise Line is the crème de la crème. Holland America Line, celebrating 75 years in Alaska in 2022, is in the No. 4 spot. "Food is excellent, crew is friendly and attentive; and cabins are large compared to other cruise lines," one voter wrote.

The Best Cruise Lines for Every Traveler: Couples, Families, Luxury, Budget - Business Insider

The Best Cruise Lines for Every Traveler: Couples, Families, Luxury, Budget.

Posted: Fri, 27 Oct 2023 07:00:00 GMT [source]

Viking Cruises

Those assessments were combined to generate results for the cruise lines in six categories, including river cruising. French luxury cruise line Ponant aims to make passengers feel as if they're traveling on their own private yachts. Guests enjoy Ladurée macarons, Veuve Clicquot Champagne, and luxurious Hermès bath products on board.

Cruises

"T+L readers rave about the consistency of Viking's vessels and their Scandinavian design," cruise expert Fran Golden reported when Viking once again topped T+L's World's Best Awards last year. Viking came in at No. 1 in T+L's best mid-size ship category and river cruise category. Golden said the WBA Hall of Fame honoree's 50 river "longships" are "light-filled floating boutique hotels."

Chefs spend the day preparing for this pull-out-all-the-stops event at which they serve roast suckling pig, carved meats, pasta, salads and an array of mouth-watering desserts. Beautiful interiors and intuitive spaces that are designed for the way people want to gather and relax are hallmarks of Seabourn Ovation's indoor and outdoor public areas, which were created by renowned designer Adam D. Tihany. All 300 suites have balconies that are perfect for enjoying breakfast, drinks or dinner alfresco.

Disney dominates the family cruise category, as it has every year since U.S. To qualify for this category, at least 62% of a cruise line's online traveler reviews must be made by couples. Viking dominates this category due to its "adult-focused environment and luxurious and romantic amenities, such as fireplaces in each ship's common area and private verandas in every stateroom," according to a U.S. Viking, a cruise line based in Basel, Switzerland, is no stranger to accolades. News' luxury list last year too — despite Chairman Torstein Hagen indicating he isn't a fan of the word. On the Pacific end of your voyage, you'll visit Astoria, Oregon — the oldest American settlement west of the Rocky Mountains.

The luxury cruise line operates river cruises in Europe and Asia, while ocean cruises on Scenic Eclipse (and the forthcoming Scenic Eclipse II) can take guests to Antarctica, the Arctic, Australia, South America, and Greenland, among other coveted destinations. On board, you'll find fine dining, expansive spas and fitness facilities, and butler service. Viking Cruises is a river and ocean cruise line that recently added expedition sailings and the Great Lakes trips to its repertoire.

This decadent spread includes a Champagne toast and buffet loaded with caviar and other snacks, all to be enjoyed during a shoreside beach barbecue. The first thing you notice about Viking Venus is its open, airy feel and the care put into the design of every space onboard. All accommodations include a veranda, and even the tightest quarters -- the Deluxe Veranda and the Veranda categories -- are comfortably sized at 270 square feet. Larger accommodations include the Penthouse Veranda at 338 square feet, the 405-square-foot Penthouse Junior Suite and the Explorer Suite, which spans 757 to 1,163 square feet, including balcony. Thoughtful touches in all cabins include bedside USB ports, quiet-closing drawers, heated bathroom floors and anti-fog mirrors. Foodies might also wish to pay a visit to the well-equipped Culinary Center onboard Oceania Riviera (as well as on twin sister ship Oceania Marina).

Emerald Yacht Cruises, a line best known for its river ships, launched its first ocean-going vessel, Emerald Azzura, in 2022 followed by an identical sister ship, Emerald Sakara, in 2023. Both ships are intimate with a capacity of 100 passengers in 50 staterooms. The line was recognized for offering for Best Value for the Money. The line’s newest ship, Silver Nova, which holds 728 passengers was ranked as the Best New Luxury Ship. This environmentally-friendly ship, which began its inaugural cruise in August, 2023 is the industry’s first hybrid luxury cruise ship.

Cruises are booming right now, buoyed partly by the popularity of domestic seacations that hauled in first-time sailors. So much so that Regent Seven Seas Cruises’ 34,000-mile world trip for 2024 sold out in just over two hours, while the adults-only Virgin Voyages, which aims to throw cruise stereotypes overboard, rose to first place in Large Ships. And we’ve brought back last year's new category showcasing the expedition cruises – small, often sustainable vessels with a shoal of scientific experts onboard – that follow in the wake of adventurers such as Sir Ernest Shackleton. Over two weeks, you'll visit Native American burial grounds and archeological sites in West Virginia and learn about the underground railroad in Ohio. You can taste bourbon and explore the Louisville Slugger Museum & Factory or the Kentucky Derby Museum & Horse Park in Louisville. Take time to appreciate American artistry at the National Quilt Museum in Paducah, Kentucky.

These Are the Best Cruises of 2024, According to T+L's Expert

Table Of Content

• Best Cruise Ship for Entertainment: Celebrity Beyond - Celebrity Cruises
• Regent Seven Seas Cruises
• Oceania Cruises
• Windstar Cruises
• best US river cruises
• Ship Tip
• Crystal

A focus on the destination at hand means that Viking Ocean Cruises stay longer in port -- often overnight -- so passengers can get a true taste of the destination. As a tip of the hat to its river cruise roots, the line offers a choice of included tours in every port (though there are for-fee options available as well). Itineraries range from eight-night voyages to cruises of more than a month. On the flip side, onboard daytime and evening entertainment options are limited. Every year for our World's Best Awards survey, T+L asks readers to weigh in on travel experiences around the globe — to share their opinions on the top hotels, resorts, cities, islands, cruise ships, spas, airlines, and more. Readers rated individual cruise ships on their cabins and facilities, food, service, itineraries and destinations, excursions and activities, and value.

Best Cruise Ship for Entertainment: Celebrity Beyond - Celebrity Cruises

The new Regent Seven Seas Grandeur is headed for the Caribbean and then Europe, but will return to the U.S. in the fall for a series of scenic New England cruises that also hit New Brunswick, Nova Scotia, and Quebec. A favorite of T+L readers, the Paul Gauguin will spend Christmas and New Year’s going round-trip from Tahiti to the Society Islands. Oceania Vista, the line’s first new ship in 11 years, will spend next summer in the Mediterranean. One highlight will be an epic 24-day journey from Venice to Athens that calls in at iconic cities such as Rome, Monte Carlo, Barcelona, and Istanbul. Silversea also loves to throw a good soiree and does so on every warm-weather cruise in the form of its deck party.

Regent Seven Seas Cruises

In the fall it heads to Asia for trips that include a 16-day Tokyo-to-Singapore swing. Scenic’s latest expedition ship, Scenic Eclipse II, will head for New Zealand in late 2024, where it will do two-week itineraries that navigate the fjords and offer plenty of pulse-quickening adventures like jet-boat and helicopter tours along the way. And let's not forget that the cruise line offers its signature Champagne and Caviar Splash on Caribbean voyages.

Oceania Cruises

Though mass Covid-19 outbreaks early in the pandemic exposed health concerns surrounding cruising, a new survey indicates travelers may not abandon ship travel after all. Living up to its name, the Miami-based Celebrity Cruises partners with well-known names in the arts and entertainment industry. It's newest ship, Celebrity Beyond, has Gwyneth Paltrow as its "wellbeing advisor" and a restaurant created by Michelin-starred chef Daniel Boulud, according to its website. "I have outlawed the use of the word 'luxury' … I think we are elegant, we are … understated and hopefully timeless," he said at a naming celebration for seven new river boats in March 2019, according to cruising website QuirkyCruise.com. U.S. News & World Report on Tuesday published its ranking of the "best" cruise lines of 2022.

Windstar Cruises

The Avalon Envision is among the more recent additions to the Avalon Waterways fleet. Included and specialty dining both shine, with plenty of options for everyone. To help narrow it down, we asked a panel of cruise industry experts to nominate their top picks for cruise lines and ships across 12 categories. The latest Silversea ship, Silver Nova, will spend the summer cruising the Inside Passage between Vancouver and Seward, Alaska.

best US river cruises

Onboard amenities include a fitness center, a Sky Deck with a whirlpool and shade system, free Wi-Fi, flat-screen TVs and a self-serve beverage station. The Avalon Choice program allows cruisers to customize the details of their experience, ensuring each vacation is a perfect fit. SeaDream Yacht Club's SeaDream II offers an intimate and luxurious yachting experience. With just 56 cabins, travelers and crew get to know each other quickly, and it really does feel like you're traveling on a friend's yacht instead of a cruise ship. Oceania Riviera dining is legendary across all of the cruise ship's dining venues, including complimentary specialty restaurants. If you've ever dreamed of having your own butler, Silversea is the luxury cruise line for you.

Ship Tip

The line's Seabourn Pursuit will be sailing the South Pacific come 2024. In April and August, it will offer itineraries that focus on the history of World War II, with visits to islands involved in the conflict, including Chuuk and Guadalcanal. In January, Ponant kicks off the first of 12 expeditions in partnership with the Explorers Club, the science-minded nonprofit. The series begins with a 30-day “half-circumnavigation” of Antarctica aboard the luxury icebreaker Le Commandant Charcot, starting in South America and wrapping in New Zealand. The cruise lines and itineraries to consider in the year ahead, as selected by T+L news director Paul Brady. If you're willing to pay, up to 24 passengers a night can enjoy a seven-course meal at La Reserve by Wine Spectator.

In The Dalles, you can enjoy a sommelier-led tasting of Columbia Valley wines, visit Multnomah Falls or get adventurous on a river kayak tour. During a call on Richland, Washington, you can admire the scenic beauty around the confluence of the Columbia and Snake rivers at Sacajawea State Park. More wine tasting or outdoor adventure awaits on the way to Clarkstown.

Sailings are available from late September to early November 2024, 2025 and 2026. Sailings are onboard either the 100-passenger American Eagle, American Liberty, American Glory or American Legend (all built in 2023 or 2024), or the older 90-passenger American Star and American Independence, launched in 2007 and 2010, respectively. Next, during a call at Kingston/Hyde Park, you can tour the Franklin D. Roosevelt National Historic Site, home to the 32nd U.S. president's library and museum. You can also head to the Vanderbilt Mansion National Historic Site, featuring an American Beaux-Arts mansion completed in 1899. The United States Military Academy at West Point, founded in 1802, is also on the itinerary, as is Sleepy Hollow.

These are the top 4 cruise lines in the world, according to travelers - CNBC

These are the top 4 cruise lines in the world, according to travelers.

Posted: Sat, 21 Oct 2023 07:00:00 GMT [source]

Complimentary choices on Silver Moon include Asian-fusion Indochine, Italian La Terrazza, seafood grill Atlantide, tapas restaurant and bar Silver Note, pizza place Spaccanapoli, and The Grill, a grill-your-own meat venue. During the day, La Terrazza is the ship's buffet, offering breakfast and lunch. Likewise, Atlantide is the closest to a main dining room you'll find, serving breakfast, lunch and dinner for those who prefer a sit-down option.

By definition, small ships hold fewer than 1200 passengers, usually making the cruise experience more intimate with more individualized service. Celebrity Cruises' new Edge Series ships are taking things up a notch. Celebrity Beyond, which debuted in 2022, accommodates 3,260 guests has 32 bars and restaurants, like Le Voyage by chef Daniel Boulud, and two-story villas on board. Paul Gauguin Cruises operates just one ship, but it is exquisite, hosting 330 guests and sailing only in the South Pacific to destinations like Tahiti, Fiji, Tonga, and the Cook Islands.

Royal Caribbean International, with its smaller 1990s ships such as Enchantment of the Seas and Vision of the Seas, comes in at No. 5. Most luxury cruise lines allow kids, though they often don't cater to them the way the larger lines do. Off-ship experiences include sampling local beer and oysters in Astoria, Oregon; visiting Multnomah Falls or hiking Beacon Rock; and having a private vineyard visit and downtown wine walk in Walla Walla, Washington. In Tennessee's two famous music cities, you'll have a chance to visit Elvis Presley's Graceland, stroll blues club-lined Beale Street and check out the Grand Ole Opry. You'll also visit Paducah, Kentucky, and Dover and Clarksville in Tennessee, where experiences include whiskey and bourbon tasting, tours of landmark art murals and, of course, Civil War history. Fares include transfers, complimentary wine and beer at lunch and dinner, no-fee specialty restaurants and free unlimited internet.