Access: Now Playing (Page 1) 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

 

Table Tools -> Database Tools -> Table Analyzer

Table Analyzer

Microsoft Access has a Table Analyzer which reviews your design and prompts you to consider Normalizing your table.

 

1: Analyze the Customer Table

Select tblCustomer.

Go to Table Tools -> Database Tools.

Select: Table Analyzer.

 
   

 

  Microsoft Access 2007 Exam 77-605 Topic: 2. Creating and Formatting Database Elements

  2.3. Modify tables  2.3.2. Evaluate table design using the Table Analyzer